Skip to content

Commonwealth 185

NTSB investigations · 17

Matched to the registry by N-number and event date, newest first.

Query with SQL

SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('2370608') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('2370608')
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('2370608')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB WPR13LA364Accident · No injuriesLimited investigationFinal reportCommonwealth 185 · Burlington, WAThe pilot's inadequate control inputs during a crosswind landing, which resulted in a hard landing and loss of directional control.Aug 8, 2013 · N67045 · Substantial damage NTSB DEN08LA096Accident · Minor injuriesLimited investigationFinal reportCommonwealth 185 · Roanoke, TXThe pilot's physiologic impairment and failure to attain the proper touchdown point during an intentional off airport landing. Contributing to the accident was the pilot's improper in-flight planning.May 24, 2008 · N33384 · Substantial damage NTSB SEA07CA176Accident · Minor injuriesData collectionFinal reportCommonwealth 185 · Redlands, CAThe pilot's inadequate weather evaluation which resulted in the airplane's lack of climb performance and subsequent collision with terrain. Contributing factors included the downdraft and the high temperature.Jun 22, 2007 · N92827 · Substantial damage NTSB CHI98LA227Accident · Minor injuriesLimited investigationFinal reportCommonwealth 185 · Oregon, WIthe improper adjustment of the carburetor by an unqualified person. Factors to the accident were the annual inspection not being complied with and the lack of recent experience of the pilot.Jun 28, 1998 · N92997 · Substantial damage NTSB SEA91LA173Accident · No injuriesLimited investigationFinal reportCommonwealth 185 · Toledo, WADirectional control was not maintained.Jul 12, 1991 · N90683 · Substantial damage NTSB LAX89LA220Accident · No injuriesLimited investigationFinal reportCommonwealth 185 · Sacramento, CAFuel exhaustion due to the pilot's failure to accurately determine the fuel load prior to departure.Jun 17, 1989 · N92827 · Substantial damage NTSB MKC79DTG15Accident · Minor injuriesClosedCommonwlth 185 · Bottineau, NDAug 26, 1979 · N73825 · Substantial damage NTSB LAX76AL040Accident · 2 fatalClosedRearwin 185 · Etiwanda, CADec 20, 1975 · N33392 · Destroyed NTSB FTW74DPG18Accident · No injuriesClosedCommonwlth 185 · Jonesboro, ARAug 27, 1973 · N92830 · Substantial damage NTSB SEA70AS049Accident · 1 fatalClosedCommonwlth 185 · Shaw Island, WAJun 28, 1970 · N31210 · Destroyed NTSB CHI69D0157Accident · No injuriesClosedCommonwlth 185 · Lapeer, MIAug 4, 1968 · N92904 · Substantial damage NTSB DIA68F0160Accident · No injuriesClosedCommonwlth 185 · Newport News, VAFeb 3, 1968 · N34135 · Substantial damage NTSB NYC67F0396Accident · No injuriesClosedRearwin 185 · Yorktown Hts, NYNov 21, 1966 · N93245 · Substantial damage NTSB MIA66D0242Accident · No injuriesClosedCommonwelth 185 · Jonesboro, GASep 11, 1965 · N60966 · Substantial damage NTSB UNK65X1332Accident · No injuriesClosedCommonwlth 185 · Meriden, CTJan 22, 1965 · N93250 · Substantial damage NTSB UNK64X4080Accident · Serious injuriesClosedCommonwealt H185 · Fortville, INSep 20, 1964 · N34132 · Substantial damage NTSB UNK64X2259Accident · No injuriesClosedCmnwealth 185 · Kellam Field, VAJun 13, 1964 · N92830 · Substantial damage

Back to Commonwealth 185