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 FTW75DPD12Accident · No injuriesClosedCessna 150 · Goldthwaite, TXOct 6, 1974 · N3506L · Substantial damage NTSB IAD75FIA04Accident · No injuriesClosedCessna 150 · Clinton, MDOct 1, 1974 · N6089G · Substantial damage NTSB MIA75FLD22Accident · No injuriesClosedCessna 150L · Clearwater, FLSep 29, 1974 · N18693 · Substantial damage NTSB FTW75FRJ16Accident · Minor injuriesClosedTaylorcraft BC12-D · Longview, TXSep 29, 1974 · N44046 · Substantial damage NTSB OAK75FVG31Accident · No injuriesClosedCessna 150 · Sacramento, CASep 28, 1974 · N6264G · Substantial damage NTSB NYC75DNC10Accident · No injuriesClosedCessna 150 · Old Town, MESep 24, 1974 · N18147 · Substantial damage NTSB OAK75DVG24Accident · No injuriesClosedCessna 150L · Lower Lake, CASep 21, 1974 · N18069 · Substantial damage NTSB MIA74DKG44Accident · No injuriesClosedCessna 150H · Carrollton, GASep 18, 1974 · N22514 · Substantial damage NTSB FTW75DRJ13Accident · No injuriesClosedCessna 150F · Nacogdoches, TXSep 17, 1974 · N3028X · Substantial damage NTSB MIA75DLD16Accident · No injuriesClosedCessna 150 · Avon Park, FLSep 15, 1974 · N22559 · Substantial damage NTSB MIA75DLD15Accident · No injuriesClosedCessna A150K · Brooksville, FLSep 14, 1974 · N8433M · Substantial damage NTSB MIA75DKT13Accident · No injuriesClosedCessna 150 · Ochopee, FLSep 14, 1974 · N5345Q · Substantial damage NTSB CHI75FEP23Accident · Serious injuriesClosedCessna 150E · Milwaukee, WISep 14, 1974 · N4069U · Substantial damage NTSB MIA75DKT08Accident · No injuriesClosedCessna 150 · West Palm Bch, FLSep 13, 1974 · N6123G · Substantial damage NTSB NYC75FFA09Accident · No injuriesClosedCessna 150 · Palenville, NYSep 2, 1974 · N19010 · Substantial damage NTSB MKC74FCA06Accident · No injuriesClosedNavion A · St Charles, MOSep 1, 1974 · N8798H · Substantial damage NTSB OAK75DVD15Accident · No injuriesClosedCessna 150 · Concord, CAAug 31, 1974 · N7228S · Substantial damage NTSB MKC75DCD15Accident · No injuriesClosedCessna 150H · Emmetsville, IAAug 30, 1974 · N6725S · Substantial damage NTSB FTW75DQD11Accident · No injuriesClosedCessna 150 · El Paso, TXAug 30, 1974 · N50472 · Substantial damage NTSB DEN75FTE19Accident · Serious injuriesClosedChampion 7ECA · Englewood, COAug 25, 1974 · N11032 · Substantial damage NTSB MKC75FCD14Accident · Minor injuriesClosedCessna 150 · Runnells, IAAug 24, 1974 · N5753G · Substantial damage NTSB FTW75FPM02Accident · No injuriesClosedCessna 150L · Kiefer, OKAug 24, 1974 · N19030 · Substantial damage NTSB OAK75DVD07Accident · No injuriesClosedCessna 150 · Lodi, CAAug 20, 1974 · N3213J · Substantial damage NTSB CHI75DEG05Accident · No injuriesClosedCessna 150L · Phillipsburg, OHAug 20, 1974 · N1768Q · Substantial damage NTSB LAX75FUJ21Accident · No injuriesClosedCessna A150L · Marana, AZAug 17, 1974 · N5992J · Substantial damage NTSB OAK75DVG14Accident · No injuriesClosedCessna 150 · Chico, CAAug 15, 1974 · N6085G · Substantial damage NTSB NYC75FNE06Accident · No injuriesClosedCessna 150G · Washington, MAAug 14, 1974 · N3427J · Substantial damage NTSB DEN75FQD08Accident · Serious injuriesClosedCessna 150 · Condran Aaf, NMAug 14, 1974 · N22280 · Substantial damage NTSB CHI75FEM04Accident · No injuriesClosedCessna 150 · Muskegon, MIAug 13, 1974 · N4501U · Substantial damage NTSB LAX75FUD02Accident · No injuriesClosedCessna 150 · Compton, CAAug 6, 1974 · N19238 · Substantial damage NTSB MKC75AK008Accident · Minor injuriesClosedCessna 150 · Aurora, NEAug 1, 1974 · N8154F · 2 aircraft · Minor damage NTSB MKC75FER07Accident · No injuriesClosedCessna 150 · Blaine, MNJul 31, 1974 · N5903G · Substantial damage NTSB MKC75DER09Accident · No injuriesClosedCessna 150L · Crystal, MNJul 31, 1974 · N568GS · Substantial damage NTSB MIA75FKG12Accident · No injuriesClosedCessna 150J · Baxley, GAJul 31, 1974 · N60549 · Substantial damage NTSB CHI75DET04Accident · No injuriesClosedCessna 150 · Hobart, INJul 31, 1974 · N6466F · Substantial damage NTSB FTW75FPA05Accident · No injuriesClosedCessna 150 · Addison, TXJul 30, 1974 · N8786S · Substantial damage NTSB OAK74DVA08Accident · No injuriesClosedCessna 150 · Merced, CAJul 29, 1974 · N7211S · Substantial damage NTSB IAD75FHD18Accident · No injuriesClosedCessna 150 · Laurel, DEJul 28, 1974 · N7172F · Substantial damage NTSB CHI75FEE06Accident · No injuriesClosedCessna 150L · Lockport, ILJul 27, 1974 · N18534 · 2 aircraft · Substantial damage NTSB FTW75DPG05Accident · Minor injuriesClosedCessna 150 · Springdale, ARJul 22, 1974 · N5416Q · Substantial damage NTSB FTW75AF002Accident · No injuriesClosedCessna 150L · Alto Loma, TXJul 20, 1974 · N5472Q · 2 aircraft · Substantial damage NTSB OAK75DVM02Accident · No injuriesClosedCessna 150 · Hlf Moon By, CAJul 16, 1974 · N6054G · Substantial damage NTSB NYC75DHA03Accident · No injuriesClosedCessna 150 · Gilbertville, PAJul 14, 1974 · N18146 · Substantial damage NTSB NYC75DNA04Accident · Minor injuriesClosedCessna 150L · Stow, MAJul 13, 1974 · N11386 · Substantial damage NTSB MKC75DCJ05Accident · No injuriesClosedCessna 150 · Potter, NEJul 10, 1974 · N50581 · Destroyed NTSB MIA75FKG03Accident · No injuriesClosedCessna 150L · Monroe, GAJul 10, 1974 · N7303G · Substantial damage NTSB MKC75DCA04Accident · No injuriesClosedCessna 150 · Chesterfield, MOJul 9, 1974 · N11952 · Substantial damage NTSB NYC75DHM01Accident · Serious injuriesClosedCessna 150 · Flanders, NJJul 7, 1974 · N5498Q · Minor damage NTSB LAX75FUJ04Accident · No injuriesClosedCessna 150 · Page, AZJul 7, 1974 · N10940 · Substantial damage NTSB LAX75AL002Accident · No injuriesClosedLuscombe 8E · Compton, CAJul 7, 1974 · N2825K · 2 aircraft · Substantial damage