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 FTW75DPA07Accident · No injuriesClosedCessna 150L · Addison, TXJul 7, 1974 · N6870G · Substantial damage NTSB NYC75FHD01Accident · No injuriesClosedCessna 150 · Philadelphia, PAJul 6, 1974 · N6953F · Substantial damage NTSB OAK74DVA02Accident · No injuriesClosedCessna 150L · Firebaugh, CAJul 5, 1974 · N8080L · Substantial damage NTSB MKC75FCA05Accident · Serious injuriesClosedCessna 150L · Cuba, MOJul 3, 1974 · N10781 · Substantial damage NTSB LAX75FUQ01Accident · No injuriesClosedCessna 150 · Van Nuys, CAJul 2, 1974 · N5427Q · Substantial damage NTSB IAD74FID42Accident · No injuriesClosedCessna 150L · Ashland, VAJun 30, 1974 · N10574 · Substantial damage NTSB IAD74AI071Accident · 2 fatalClosedCessna 150L · Fayetteville, NCJun 29, 1974 · N19266 · Substantial damage NTSB OAK74FVW24Accident · Minor injuriesClosedCessna 150F · Henderson, NVJun 22, 1974 · N7119F · Substantial damage NTSB ANC74FAA39Accident · No injuriesClosedCessna 150 · Fairbanks, AKJun 20, 1974 · N16036 · Substantial damage NTSB OAK74FVA75Accident · No injuriesClosedCessna 150J · Madera, CAJun 17, 1974 · N60802 · Substantial damage NTSB MIA74FKG86Accident · Minor injuriesClosedCessna 150G · Williamson, GAJun 16, 1974 · N8588J · Destroyed NTSB MIA74DLD98Accident · No injuriesClosedCessna 150K · Merritt Isl, FLJun 13, 1974 · N5814G · Substantial damage NTSB NYC74DHA32Accident · No injuriesClosedCessna 150 · Pattenburg, NJJun 10, 1974 · N11258 · Substantial damage NTSB MIA75DLD96Accident · No injuriesClosedCessna 150 · Rockledge, FLJun 10, 1974 · N19144 · Substantial damage NTSB OAK74DVA74Accident · No injuriesClosedCessna 150L · Groveland, CAJun 9, 1974 · N8080L · Substantial damage NTSB CHI74FEI44Accident · No injuriesClosedCessna 150K · Louisville, OHJun 9, 1974 · N5899G · Substantial damage NTSB IAD74FLJ47Accident · Serious injuriesClosedCessna 150 · Raeford, NCJun 8, 1974 · N60276 · Destroyed NTSB FTW74DQG66Accident · No injuriesClosedCessna 150F · Snyder, TXJun 6, 1974 · N8208S · Substantial damage NTSB NYC74DFA34Accident · No injuriesClosedCessna 150 · Wurtsboro, NYJun 2, 1974 · N6143G · Substantial damage NTSB MKC74DER51Accident · No injuriesClosedCessna 150J · Esko, MNJun 1, 1974 · N50793 · Substantial damage NTSB LAX74DUJ65Accident · No injuriesClosedCessna 150J · Tucson, AZMay 30, 1974 · N60640 · Substantial damage NTSB IAD74DLQ41Accident · No injuriesClosedCessna 150 · Richmond, KYMay 30, 1974 · N51218 · Substantial damage NTSB CHI74DEE79Accident · No injuriesClosedCessna 150 · Frankfort, ILMay 27, 1974 · N6820G · Substantial damage NTSB NYC74FGM33Accident · No injuriesClosedCessna 150K · Ohiopyle, PAMay 26, 1974 · N5714G · Destroyed NTSB MIA74DKG80Accident · No injuriesClosedCessna 150 · Cedartown, GAMay 24, 1974 · N18027 · Substantial damage NTSB LAX74DUM36Accident · No injuriesClosedCessna 150 · Oceanside, CAMay 24, 1974 · N8861S · Substantial damage NTSB OAK74DVG60Accident · No injuriesClosedCessna 150 · Franklin, CAMay 23, 1974 · N17215 · Substantial damage NTSB ANC74DAH10Accident · No injuriesClosedCessna 150 · Palmer, AKMay 21, 1974 · N22135 · Substantial damage NTSB NYC74DHA31Accident · Minor injuriesClosedCessna 150 · Somerville, NJMay 20, 1974 · N1596Q · Substantial damage NTSB MIA74DLD88Accident · No injuriesClosedCessna 150 · Brandon, FLMay 19, 1974 · N60921 · Substantial damage NTSB CHI74DEI41Accident · No injuriesClosedCessna 150K · Elyria, OHMay 19, 1974 · N5939G · Substantial damage NTSB OAK74DVA66Accident · No injuriesClosedCessna 150 · Modesto, CAMay 18, 1974 · N7505G · Substantial damage NTSB NYC74FGM32Accident · No injuriesClosedCessna 150 · Belle Vernon, PAMay 18, 1974 · N4565U · Substantial damage NTSB NYC74DNA44Accident · No injuriesClosedCessna 150H · Slocum, RIMay 18, 1974 · N50439 · Substantial damage NTSB IAD74DIG26Accident · No injuriesClosedCessna 150 · Rhodesdale, MDMay 17, 1974 · N6364G · Substantial damage NTSB LAX74DUJ62Accident · No injuriesClosedCessna 150 · Tucson, AZMay 15, 1974 · N21928 · Substantial damage NTSB OAK74DVM27Accident · No injuriesClosedCessna 150 · Palo Alto, CAMay 14, 1974 · N11290 · Substantial damage NTSB CHI74DEC45Accident · No injuriesClosedCessna 150E · Lincoln, MIMay 12, 1974 · N3049J · Substantial damage NTSB FTW74DRJ33Accident · No injuriesClosedCessna 150 · Leesville, LAMay 9, 1974 · N6157G · Substantial damage NTSB FTW74FRA40Accident · No injuriesClosedCessna 150J · La Porte, TXMay 8, 1974 · N5599G · Substantial damage NTSB FTW74FPA22Accident · No injuriesClosedCessna 150J · Dallas, TXMay 8, 1974 · N5544G · Substantial damage NTSB MIA74FKJ55Accident · No injuriesClosedCessna 150 · Brewton, ALMay 7, 1974 · N5612G · Substantial damage NTSB OAK74FVM26Accident · Minor injuriesClosedCessna 150J · Gonzales, CAMay 5, 1974 · N61057 · Destroyed NTSB MIA74DKT75Accident · No injuriesClosedCessna 206 · Miami, FLMay 4, 1974 · N50184 · Substantial damage NTSB FTW74FPA23Accident · No injuriesClosedCessna 140A · Sherman, TXMay 4, 1974 · N5350C · Destroyed NTSB OAK74FVA62Accident · No injuriesClosedCessna 150L · Fresno, CAMay 2, 1974 · N10531 · Substantial damage NTSB FTW74DPG59Accident · No injuriesClosedCessna 150 · Fayetteville, ARMay 2, 1974 · N50041 · Substantial damage NTSB MIA74DKQ19Accident · No injuriesClosedCessna 150G · Bolton, MSMay 1, 1974 · N3623J · Substantial damage NTSB IAD74FIG25Accident · Minor injuriesClosedCessna 150 · White Marsh, MDApr 26, 1974 · N6755G · Substantial damage NTSB NYC74AN090Accident · 1 fatalClosedCessna 150 · Boothbay Harbr, MEApr 22, 1974 · N50819 · Substantial damage