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 CHI74DER03Accident · No injuriesClosedCessna 150L · Durand, WIOct 14, 1973 · N17295 · Substantial damage NTSB NYC74FFJ14Accident · Minor injuriesClosedCessna 150H · Warsaw, NYOct 12, 1973 · N22655 · Substantial damage NTSB CHI74FEM23Accident · No injuriesClosedCessna 150 · Freeland, MIOct 6, 1973 · N5883G · Substantial damage NTSB MKC74DTG09Accident · No injuriesClosedCessna 150H · Angus, MNOct 5, 1973 · N50989 · Substantial damage NTSB MIA74DLA18Accident · No injuriesClosedCessna 150 · Gainesville, FLOct 3, 1973 · N19342 · Substantial damage NTSB FTW74FPG28Accident · No injuriesClosedCessna 150L · Joiner, AROct 2, 1973 · N18155 · 2 aircraft · Substantial damage NTSB NYC74DMM08Accident · No injuriesClosedCessna 150 · Spring Valley, NYSep 27, 1973 · N5997G · Substantial damage NTSB CHI74FEK05Accident · No injuriesClosedCessna 150 · Newark, OHSep 19, 1973 · N18086 · Substantial damage NTSB MIA74FKG29Accident · Serious injuriesClosedCessna 150G · Jonesboro, GASep 17, 1973 · N2218J · Substantial damage NTSB NYC74DNE06Accident · No injuriesClosedCessna 150 · Orange, MASep 16, 1973 · N18637 · Substantial damage NTSB FTW74DPD18Accident · No injuriesClosedCessna 150J · Mineral Wells, TXSep 16, 1973 · N60687 · Substantial damage NTSB FTW74DPD11Accident · No injuriesClosedCessna 150L · Stephenville, TXSep 16, 1973 · N1609Q · Substantial damage NTSB CHI74DEM21Accident · No injuriesClosedCessna 150 · Muskegon, MISep 16, 1973 · N51094 · Substantial damage NTSB FTW74FRD12Accident · No injuriesClosedCessna 150 · Loreauville, ARSep 13, 1973 · N8983S · Substantial damage NTSB FTW74FQG15Accident · Serious injuriesClosedCessna 150F · Muleshoe, TXSep 12, 1973 · N8878G · Destroyed NTSB MIA74DKT16Accident · No injuriesClosedCessna 150 · Opa Locka, FLSep 9, 1973 · N6674G · Substantial damage NTSB MIA74DLA13Accident · No injuriesClosedCessna 150 · Marianna, FLAug 31, 1973 · N2944J · Substantial damage NTSB FTW74FRG19Accident · No injuriesClosedCessna 150 · Portland, TXAug 31, 1973 · N5863E · Substantial damage NTSB CHI74FEM07Accident · 1 fatalClosedBreezy RLU-1 · Hale, MIAug 31, 1973 · N4029 · Substantial damage NTSB NYC74DHM04Accident · No injuriesClosedCessna 150 · Bloomingburg, NYAug 26, 1973 · N2978S · Substantial damage NTSB MIA74AM021Accident · 3 fatalClosedCessna 150 · Missing AcftAug 26, 1973 · N50143 · Destroyed NTSB FTW74DRJ07Accident · No injuriesClosedCessna 150H · Ruston, LAAug 23, 1973 · N23392 · Substantial damage NTSB SEA74DYE14Accident · No injuriesClosedCessna 150 · Federal Way, WAAug 21, 1973 · N7296S · Substantial damage NTSB MIA74FKT09Accident · No injuriesClosedCessna 150 · Miami, FLAug 16, 1973 · N16195 · Substantial damage NTSB CHI74DEI06Accident · No injuriesClosedCessna 150F · Strongsville, OHAug 16, 1973 · N8625S · Substantial damage NTSB OAK74DVD06Accident · No injuriesClosedCessna 150 · Livermore, CAAug 15, 1973 · N18606 · Substantial damage NTSB OAK74DVD02Accident · No injuriesClosedCessna 150 · Healdsburg, CAAug 14, 1973 · N6198T · Substantial damage NTSB NYC74FNE02Accident · No injuriesClosedCessna 150F · Wendell, MAAug 13, 1973 · N8860G · Substantial damage NTSB FTW74FPD05Accident · No injuriesClosedCessna 150 · Grand Prairie, TXAug 11, 1973 · N5628E · Substantial damage NTSB MKC74DTG04Accident · No injuriesClosedCessna 150 · Mayville, NDAug 10, 1973 · N5956J · Substantial damage NTSB DEN74DQA11Accident · No injuriesClosedCessna 150L · Moriarity, NMAug 9, 1973 · N1796Q · Substantial damage NTSB SEA74FYC08Accident · Minor injuriesClosedCessna 150 · Vancouver, WAAug 7, 1973 · N7962F · Substantial damage NTSB CHI74FEP06Accident · Minor injuriesClosedBeech C23 · Milwaukee, WIAug 7, 1973 · N2102W · 2 aircraft · Substantial damage NTSB FTW74DRG09Accident · No injuriesClosedCessna 150J · San Marcos, TXAug 6, 1973 · N60655 · Substantial damage NTSB CHI74DEI22Accident · No injuriesClosedCessna 150 · Clyde, OHAug 5, 1973 · N6995G · Substantial damage NTSB FTW74FQG04Accident · No injuriesClosedCessna 150 · San Angelo, TXAug 4, 1973 · N23304 · Substantial damage NTSB FTW74DPM04Accident · No injuriesClosedCessna 150E · Warner, OKAug 4, 1973 · N6251T · Substantial damage NTSB MIA74DKJ09Accident · No injuriesClosedCessna 150C · Arley, ALAug 3, 1973 · N6246T · Substantial damage NTSB MKC74DCJ05Accident · No injuriesClosedCessna 150J · North Platte, NEAug 2, 1973 · N50576 · Substantial damage NTSB CHI74DEI08Accident · No injuriesClosedCessna 150 · Brunswick, OHAug 2, 1973 · N6835G · Substantial damage NTSB MKC74DCQ02Accident · No injuriesClosedCessna 150 · Ashland, KSAug 1, 1973 · N60051 · Substantial damage NTSB MKC74AK004Accident · 2 fatalClosedCessna 150H · Hampton, IAJul 31, 1973 · N7217S · Destroyed NTSB SEA74DYG05Accident · No injuriesClosedCessna 150 · Pullman, WAJul 27, 1973 · N16058 · Substantial damage NTSB CHI74FEV06Accident · No injuriesClosedCessna 150H · Paris, ILJul 25, 1973 · N6478S · Substantial damage NTSB NYC74DHJ06Accident · No injuriesClosedCessna 150 · Islip, NYJul 24, 1973 · N5236Q · Substantial damage NTSB CHI74FEM11Accident · No injuriesClosedCessna 150L · Grand Rapids, MIJul 24, 1973 · N19345 · Substantial damage NTSB MIA74AM006Accident · 3 fatalClosedCessna 150E · Andrews, SCJul 19, 1973 · N2549J · Destroyed NTSB CHI74FEI02Accident · No injuriesClosedCessna 150 · Doylestown, OHJul 18, 1973 · N5585G · Substantial damage NTSB NYC74FHA02Accident · No injuriesClosedCessna 150 · Sussex, NJJul 16, 1973 · N17065 · Substantial damage NTSB ANC74AA007Accident · 2 fatalClosedTaylorcraft BC12-D · Fairbanks, AKJul 16, 1973 · N43383 · Substantial damage