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 FTW76DPJ35Accident · No injuriesClosedCessna 150 · Clinton, OKMay 28, 1976 · N8054F · Substantial damage NTSB MKC76DCD44Accident · No injuriesClosedCessna 150J · Muscatine, IAMay 27, 1976 · N51183 · Substantial damage NTSB OAK76FVA66Accident · No injuriesClosedCessna 150L · Fresno, CAMay 22, 1976 · N1421Q · Substantial damage NTSB MKC76DCJ33Accident · No injuriesClosedCessna 150 · Omaha, NEMay 22, 1976 · N6092T · Substantial damage NTSB FTW76DRD49Accident · No injuriesClosedCessna 150 · Lake Charles, LAMay 21, 1976 · N11265 · Substantial damage NTSB FTW76FRJ26Accident · No injuriesClosedCessna 150M · Texarkana, ARMay 19, 1976 · N45547 · Substantial damage NTSB CHI76FEV39Accident · No injuriesClosedCessna 150M · Springfield, ILMay 19, 1976 · N66380 · Substantial damage NTSB FTW76DQG77Accident · No injuriesClosedCessna 150 · Levelland, TXMay 18, 1976 · N7926U · Substantial damage NTSB FTW76DPG54Accident · No injuriesClosedCessna 150 · Bay, ARMay 18, 1976 · N6049G · Substantial damage NTSB CHI76DEM41Accident · No injuriesClosedCessna 150 · Lansing, MIMay 18, 1976 · N7679U · Substantial damage NTSB MIA76DKA06Accident · No injuriesClosedCessna 150L · Moca, PRMay 16, 1976 · N1707Q · Substantial damage NTSB SEA76DYC47Accident · No injuriesClosedCessna 150 · Clackamas, ORMay 15, 1976 · N61263 · Substantial damage NTSB CHI76FEM40Accident · No injuriesClosedCessna 150 · Lamont, MIMay 10, 1976 · N4545U · Substantial damage NTSB MIA76DLD55Accident · Minor injuriesClosedCessna 150 · Plymouth, FLMay 8, 1976 · N1202Q · Destroyed NTSB FTW76DQG66Accident · No injuriesClosedCessna 150 · Shallowater, TXMay 8, 1976 · N6433K · Substantial damage NTSB NYC76FHJ19Accident · No injuriesClosedCessna 150 · Ronkonkoma, NYMay 2, 1976 · N63214 · Substantial damage NTSB CHI76FEV37Accident · No injuriesClosedCessna 150D · Pickneyville, ILMay 1, 1976 · N4164U · Substantial damage NTSB MIA76DKJ60Accident · No injuriesClosedCessna 150 · Lanett, ALApr 28, 1976 · N7830Z · Substantial damage NTSB CHI76FEA30Accident · No injuriesClosedCessna 150L · Bloomington, INApr 27, 1976 · N19318 · Substantial damage NTSB MIA76DKT69Accident · No injuriesClosedCessna 150 · Pembrook Pines, FLApr 25, 1976 · N11294 · Substantial damage NTSB OAK76DXQ41Accident · No injuriesClosedMustang Midget · Lovelock, NVApr 23, 1976 · N7178 · Substantial damage NTSB CHI76FEE55Accident · Serious injuriesClosedCessna 150J · Plainfield, ILApr 22, 1976 · N61237 · Destroyed NTSB NYC76DNA35Accident · No injuriesClosedCessna 150 · Norfolk, MAApr 20, 1976 · N63439 · Substantial damage NTSB MIA76FKG55Accident · No injuriesClosedCessna 150K · Fayetteville, GAApr 19, 1976 · N6489G · Substantial damage NTSB NYC76DFA33Accident · No injuriesClosedCessna 150 · Scotia, NYApr 18, 1976 · N11438 · Substantial damage NTSB CHI76FEK15Accident · No injuriesClosedCessna 150 · Blacklick, OHApr 12, 1976 · N51043 · Substantial damage NTSB MKC76FCA20Accident · No injuriesClosedCessna 150M · Rolla, MOApr 11, 1976 · N6479K · Substantial damage NTSB LAX76FUG45Accident · No injuriesClosedCessna 150 · Chino, CAApr 11, 1976 · N63471 · Substantial damage NTSB IAD76FLT08Accident · No injuriesClosedCessna 150 · Covington, TNApr 11, 1976 · N3400V · Substantial damage NTSB IAD76DID24Accident · No injuriesClosedCessna 150J · Farmville, VAApr 11, 1976 · N50936 · Substantial damage NTSB ANC76DAH05Accident · No injuriesClosedCessna 150 · Anchorage, AKApr 11, 1976 · N63243 · Substantial damage NTSB SEA76DYE35Accident · No injuriesClosedCessna 150F · Ashford, WAApr 10, 1976 · N8160F · Substantial damage NTSB LAX76FUM24Accident · No injuriesClosedCessna 150J · Fallbrook, CAApr 9, 1976 · N50643 · Substantial damage NTSB NYC76DNC38Accident · No injuriesClosedCessna 150 · Lincoln, MEApr 6, 1976 · N3254J · Substantial damage NTSB OAK76FVM32Accident · No injuriesClosedCessna 150 · San Carlos, CAApr 5, 1976 · N3189V · Substantial damage NTSB MKC76DCG68Accident · No injuriesClosedCessna 150 · Garnett, KSApr 3, 1976 · N3658J · Substantial damage NTSB FTW76AF082Accident · 1 fatalClosedCessna 177 · New Iberia, LAApr 3, 1976 · N2894X · 2 aircraft · Destroyed NTSB CHI76FEK12Accident · No injuriesClosedCessna 150F · Van Wert, OHApr 3, 1976 · N7779F · Substantial damage NTSB FTW76DRD37Accident · No injuriesClosedCessna 150 · Hathaway, LAApr 2, 1976 · N6616G · Substantial damage NTSB OAK76FVA52Accident · No injuriesClosedCessna 150L · Fresno, CAApr 1, 1976 · N6800G · Substantial damage NTSB OAK76DVG62Accident · No injuriesClosedCessna 150 · Marysville, CAMar 27, 1976 · N10954 · Substantial damage NTSB NYC76FNE19Accident · No injuriesClosedCessna 150 · Worcester, MAMar 25, 1976 · N8353J · Substantial damage NTSB ANC76DAH04Accident · No injuriesClosedCessna 150 · Dillingham, AKMar 22, 1976 · N6106T · Substantial damage NTSB OAK76DVG57Accident · No injuriesClosedCessna 150 · Napa, CAMar 21, 1976 · N19578 · Substantial damage NTSB FTW76DPA20Accident · No injuriesClosedCessna 150 · Sherman, TXMar 21, 1976 · N18533 · Substantial damage NTSB NYC76DFA29Accident · No injuriesClosedCessna 150 · Kingston, NYMar 20, 1976 · N19490 · Substantial damage NTSB MKC76FCJ30Accident · No injuriesClosedCessna 150J · Tecumseh, NEMar 18, 1976 · N50467 · Substantial damage NTSB MKC76DCG57Accident · No injuriesClosedCessna 150L · Lawrence, KSMar 16, 1976 · N6095J · Substantial damage NTSB FTW76FPG45Accident · No injuriesClosedCessna 150D · Stuttgart, ARMar 14, 1976 · N4271U · Substantial damage NTSB MKC76FER56Accident · Serious injuriesClosedCessna 150J · Rochester, MNMar 10, 1976 · N60038 · Substantial damage