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 NYC74DFA27Accident · Minor injuriesClosedCessna 150G · Oneonta, NYApr 21, 1974 · N3455J · Substantial damage NTSB IAD74DKW34Accident · No injuriesClosedCessna 150G · Surgoinsvile, TNApr 21, 1974 · N3176X · Substantial damage NTSB NYC74DHA27Accident · No injuriesClosedCessna 150G · Pittstown, NJApr 20, 1974 · N2899S · Substantial damage NTSB DEN74DQG59Accident · No injuriesClosedCessna 150 · Tumcumcari, NMApr 20, 1974 · N1586Q · Substantial damage NTSB CHI74DEC38Accident · No injuriesClosedCessna 150 · Mason, MIApr 20, 1974 · N6561G · Substantial damage NTSB IAD74DIJ14Accident · Serious injuriesClosedStits SA3B · Rainelle, WVApr 19, 1974 · N5145 · Substantial damage NTSB CHI74DEM54Accident · No injuriesClosedCessna 150 · Lansing, MIApr 17, 1974 · N156KA · Substantial damage NTSB MKC74DCD26Accident · No injuriesClosedCessna 150 · Laporte City, IAApr 16, 1974 · N16166 · Substantial damage NTSB MKC74DCJ36Accident · No injuriesClosedCessna 150L · North Platte, NEApr 14, 1974 · N6943G · Substantial damage NTSB NYC74DHA26Accident · No injuriesClosedCessna 150J · Stillwater, NJApr 13, 1974 · N61208 · Substantial damage NTSB SEA74FYC45Accident · No injuriesClosedCessna 150 · Grand Ronde, ORApr 12, 1974 · N5809E · Substantial damage NTSB CHI74DEG21Accident · No injuriesClosedCessna 150 · Dayton, OHApr 11, 1974 · N7193S · Substantial damage NTSB FTW74FPD41Accident · No injuriesClosedCessna 150 · Fort Worth, TXApr 9, 1974 · N51023 · 2 aircraft · Destroyed NTSB OAK74FVG37Accident · No injuriesClosedCessna 150 · Foresthill, CAApr 7, 1974 · N6526T · Substantial damage NTSB LAX74DYI11Accident · No injuriesClosedCessna 150 · Medford, ORApr 7, 1974 · N2800S · 2 aircraft · Substantial damage NTSB SEA74DYC42Accident · No injuriesClosedCessna 150J · Molalla, ORApr 6, 1974 · N61365 · Destroyed NTSB FTW74FPA21Accident · No injuriesClosedCessna 150E · Sherman, TXApr 6, 1974 · N6105T · Substantial damage NTSB MIA74FLD78Accident · No injuriesClosedCessna 150 · Kissimmee, FLApr 3, 1974 · N1562Q · Substantial damage NTSB IAD74DLJ36Accident · No injuriesClosedCessna 150 · Whiteville, NCApr 3, 1974 · N19595 · Substantial damage NTSB NYC74FHM23Accident · No injuriesClosedCessna 150 · Teterboro, NJMar 31, 1974 · N10070 · Substantial damage NTSB MIA74FLD79Accident · Serious injuriesClosedCessna 150 · Forest Lake, FLMar 28, 1974 · N3503J · Destroyed NTSB MIA74FKG65Accident · Serious injuriesClosedCessna 150L · Perry, GAMar 27, 1974 · N6603G · Substantial damage NTSB OAK74DVM22Accident · No injuriesClosedCessna 150F · Salinas, CAMar 26, 1974 · N8604G · Substantial damage NTSB CHI74DEM47Accident · No injuriesClosedCessna 150 · Mt Pleasant, MIMar 25, 1974 · N5506G · Substantial damage NTSB SEA74FYE41Accident · No injuriesClosedCessna 150 · Redmond, WAMar 20, 1974 · N5469Q · Substantial damage NTSB CHI74DEG19Accident · No injuriesClosedCessna 150 · Springfield, OHMar 17, 1974 · N18202 · Substantial damage NTSB CHI74DEE63Accident · No injuriesClosedCessna 150 · Rochelle, ILMar 16, 1974 · N10488 · Substantial damage NTSB OAK74DVW14Accident · No injuriesClosedCessna 150L · Lone Pine, CAMar 14, 1974 · N21999 · Substantial damage NTSB MKC74DCD24Accident · No injuriesClosedCessna 150 · Matthews, MOMar 8, 1974 · N3133X · Substantial damage NTSB IAD74DKM43Accident · No injuriesClosedCessna 150 · Gastonia, NCMar 3, 1974 · N17045 · Substantial damage NTSB CHI74DEA31Accident · Serious injuriesClosedCessna 150 · Bloomington, INMar 2, 1974 · N5747G · No damage NTSB CHI74FEG17Accident · No injuriesClosedCessna 150D · Harrison, OHMar 1, 1974 · N436FK · Substantial damage NTSB NYC74DGT17Accident · No injuriesClosedCessna 150 · University Pk, PAFeb 26, 1974 · N1931Z · Substantial damage NTSB SEA74DYE38Accident · No injuriesClosedCessna 172 · Bellingham, WAFeb 24, 1974 · N4112L · Substantial damage NTSB IAD74FL027Accident · No injuriesClosedCessna 150 · Frankfort, KYFeb 18, 1974 · N6045G · Substantial damage NTSB FTW74DPD35Accident · No injuriesClosedCessna 150J · Fort Worth, TXFeb 17, 1974 · N60926 · Substantial damage NTSB MIA74DLD65Accident · Minor injuriesClosedCessna 150 · Zephyrhills, FLFeb 16, 1974 · N10688 · Substantial damage NTSB FTW74DRG62Accident · No injuriesClosedCessna 150 · New Braunfels, TXFeb 16, 1974 · N6460G · Substantial damage NTSB FTW74FRA30Accident · No injuriesClosedCessna 150L · Houston, TXFeb 14, 1974 · N17027 · Substantial damage NTSB CHI74FEI29Accident · No injuriesClosedCessna 150L · Carrollton, OHFeb 14, 1974 · N11148 · Substantial damage NTSB CHI74FEG16Accident · No injuriesClosedCessna 150 · Gallipolis, OHFeb 11, 1974 · N8636G · Substantial damage NTSB CHI74DEI28Accident · No injuriesClosedCessna 150L · Chagrin Fall, OHFeb 9, 1974 · N11358 · Substantial damage NTSB OAK74DVA45Accident · No injuriesClosedCessna 150 · Modesto, CAFeb 7, 1974 · N61253 · Substantial damage NTSB MIA74FLD63Accident · No injuriesClosedCessna 150 · Candler, FLFeb 5, 1974 · N8532J · Substantial damage NTSB FTW74FRA25Accident · No injuriesClosedCessna 150L · Wharton, TXFeb 4, 1974 · N6023J · Substantial damage NTSB FTW74FRG58Accident · No injuriesClosedCessna 150H · Robstown, TXFeb 2, 1974 · N7014S · Substantial damage NTSB FTW74DRA26Accident · No injuriesClosedCessna 150E · Gilchrist, TXFeb 2, 1974 · N3971U · Substantial damage NTSB MKC74DER38Accident · No injuriesClosedChampion 7ECA · Austin, MNJan 30, 1974 · N11065 · Substantial damage NTSB DEN74DTE48Accident · No injuriesClosedCessna 172 · Ft Collins, COJan 30, 1974 · N7959F · Substantial damage NTSB MKC74FCA22Accident · No injuriesClosedCessna 150L · St Charles, MOJan 29, 1974 · N10681 · Substantial damage