Skip to content

NTSB investigations: Continental 0-200 series

6,416 cases on aircraft whose registry engine model is Continental 0-200 series. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases, 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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17020')) 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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17020'))
  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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17020'))
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 MIA73FKT83Accident · No injuriesClosedCessna 150L · Dania, FLApr 18, 1973 · N6773G · Substantial damage NTSB OAK73FVD30Accident · No injuriesClosedCessna 150H · Hayward, CAApr 15, 1973 · N23234 · Substantial damage NTSB NYC73FNC69Accident · No injuriesClosedCessna 150 · Norridgewock, MEApr 15, 1973 · N4024U · Substantial damage NTSB CHI73DEP48Accident · No injuriesClosedCessna 150K · Rhinelander, WIApr 13, 1973 · N6243G · Substantial damage NTSB MKC73DCD56Accident · No injuriesClosedCessna 150 · Jefferson, IAApr 11, 1973 · N7148S · Substantial damage NTSB IAD73FKM32Accident · Serious injuriesClosedCessna 150 · Advance, NCApr 9, 1973 · N5471Q · No damage NTSB LAX73DUJ77Accident · Minor injuriesClosedCessna 150 · Glendale, AZApr 7, 1973 · N6568G · Substantial damage NTSB NYC73DGM24Accident · No injuriesClosedCessna 150 · Franklin, PAApr 6, 1973 · N6400G · Substantial damage NTSB MIA73DKT79Accident · Minor injuriesClosedCessna 150 · Opa Locka, FLApr 5, 1973 · N6038G · Substantial damage NTSB LAX73DUJ62Accident · No injuriesClosedCessna 150 · Parker, AZApr 1, 1973 · N5607G · Substantial damage NTSB NYC73FHM24Accident · No injuriesClosedCessna 150H · Stormville, NYMar 28, 1973 · N50146 · Substantial damage NTSB MIA73DLD67Accident · Serious injuriesClosedCessna 150 · Silver Spring, FLMar 28, 1973 · N1641M · Substantial damage NTSB MKC73DCJ32Accident · No injuriesClosedCessna T-50 · Omaha, NEMar 27, 1973 · N54302 · 2 aircraft · Minor damage NTSB LAX73FUQ24Accident · Minor injuriesClosedChampion 7ECA · Pacoima, CAMar 26, 1973 · N11081 · Substantial damage NTSB MIA73DLG37Accident · No injuriesClosedCessna 150F · Timmonsville, SCMar 24, 1973 · N3086X · Substantial damage NTSB FTW73DPA29Accident · No injuriesClosedCessna 150 · Dallas, TXMar 24, 1973 · N7854Z · Substantial damage NTSB MKC73DCG34Accident · No injuriesClosedCessna 150 · Point Lookout, MOMar 22, 1973 · N1599Q · Substantial damage NTSB LAX73FUA35Accident · No injuriesClosedCessna 150L · Carson, CAMar 22, 1973 · N17004 · Substantial damage NTSB CHI73FEM45Accident · No injuriesClosedCessna 150J · Allegan, MIMar 22, 1973 · N50415 · Substantial damage NTSB NYC73FGM22Accident · No injuriesClosedCessna 150J · Beaver Falls, PAMar 21, 1973 · N60173 · Substantial damage NTSB NYC73FGM20Accident · No injuriesClosedCessna 150J · Belle Vernon, PAMar 20, 1973 · N5582G · Substantial damage NTSB IAD73DIG21Accident · No injuriesClosedCessna 150K · Salisbury, MDMar 17, 1973 · N6093G · Substantial damage NTSB CHI73DEI31Accident · No injuriesClosedCessna 150J · Bowling Grn, OHMar 15, 1973 · N60495 · Substantial damage NTSB LAX73DUM73Accident · No injuriesClosedCessna 150 · Santee, CAMar 14, 1973 · N3331J · Substantial damage NTSB MIA73FKT72Accident · No injuriesClosedCessna 150L · Miami, FLMar 10, 1973 · N16035 · Substantial damage NTSB MKC73DCD50Accident · No injuriesClosedCessna 150K · Mitchellvile, IAMar 7, 1973 · N5913G · Substantial damage NTSB SEA73FYI12Accident · No injuriesClosedCessna 150 · Roseburg, ORMar 6, 1973 · N6561G · Substantial damage NTSB FTW73FPD22Accident · No injuriesClosedCessna 150 · Keller, TXMar 6, 1973 · N5573G · Substantial damage NTSB CHI73DEM54Accident · No injuriesClosedCessna 150 · Charlotte, MIMar 6, 1973 · N6840F · Substantial damage NTSB LAX73DUG42Accident · No injuriesClosedCessna 150 · Bermuda Dns, CAFeb 27, 1973 · N458AE · Substantial damage NTSB NYC73DLJ20Incident · No injuriesClosedCessna 150 · Askewville, NCFeb 25, 1973 · N5755E · Minor damage NTSB NYC73DGM19Accident · No injuriesClosedCessna 150 · West Mifflin, PAFeb 25, 1973 · N60319 · Substantial damage NTSB NYC73DNC60Accident · No injuriesClosedCessna 150 · Eastport, MEFeb 24, 1973 · N8949S · Substantial damage NTSB NYC73DNA40Accident · No injuriesClosedCessna 150 · Hyannis, MAFeb 23, 1973 · N6209G · Substantial damage NTSB MIA73DLA28Accident · No injuriesClosedCessna 150 · High Springs, FLFeb 21, 1973 · N5814G · Substantial damage NTSB LAX73FUQ21Accident · Minor injuriesClosedCessna 150 · Pacoima, CAFeb 20, 1973 · N19084 · Substantial damage NTSB NYC73DHJ16Accident · No injuriesClosedCessna 150 · White Plains, NYFeb 18, 1973 · N7950Z · Substantial damage NTSB LAX73DUM19Accident · Minor injuriesClosedCessna 150L · Brawley, CAFeb 18, 1973 · N19116 · Substantial damage NTSB MKC73DCD51Accident · No injuriesClosedCessna 150 · Waterloo, IAFeb 17, 1973 · N1264Q · Substantial damage NTSB LAX73FUA32Accident · Minor injuriesClosedCessna 150H · Santa Ana, CAFeb 17, 1973 · N50136 · Substantial damage NTSB NYC73FHD26Accident · No injuriesClosedCessna 150L · Williamstown, NJFeb 14, 1973 · N18210 · Substantial damage NTSB FTW73DPD20Accident · No injuriesClosedCessna 150L · Abilene, TXFeb 13, 1973 · N61009 · Substantial damage NTSB NYC73FGM17Accident · No injuriesClosedCessna 150 · West Mifflin, PAFeb 4, 1973 · N61038 · Substantial damage NTSB MIA73FKG58Accident · No injuriesClosedCessna 150F · Alma, GAFeb 4, 1973 · N7017F · Substantial damage NTSB FTW73AF040Accident · No injuriesClosedCessna 150L · Beaumont, TXFeb 3, 1973 · N1268Q · 2 aircraft · Substantial damage NTSB NYC73DHJ14Accident · No injuriesClosedCessna 150G · New York City, NYJan 30, 1973 · N6284S · Destroyed NTSB CHI73FEV21Accident · Minor injuriesClosedCessna 150J · Marion, ILJan 30, 1973 · N61286 · Substantial damage NTSB NYC73DLJ18Accident · No injuriesClosedCessna 150K · Farmville, NCJan 29, 1973 · N6088G · Substantial damage NTSB OAK73DVG43Accident · No injuriesClosedCessna 150 · Pope Valley, CAJan 27, 1973 · N6744G · Substantial damage NTSB MIA73DKT52Accident · No injuriesClosedCessna 150 · Brighton, FLJan 21, 1973 · N8624S · Substantial damage