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 OAK75FVG42Accident · No injuriesClosedCessna 150 · Chico, CADec 25, 1974 · N3315J · Destroyed NTSB CHI75DEE35Accident · No injuriesClosedCessna 150 · Richton Park, ILDec 23, 1974 · N7137F · Substantial damage NTSB IAD75FLT06Accident · No injuriesClosedCessna 150 · Brunswick, TNDec 19, 1974 · N2908V · Substantial damage NTSB FTW75DRJ21Accident · No injuriesClosedCessna 150 · Nacogdoches, TXDec 18, 1974 · N18607 · Substantial damage NTSB OAK75DVD25Accident · No injuriesClosedCessna 150 · Danville, CADec 16, 1974 · N50596 · Substantial damage NTSB MIA75FKT39Accident · Minor injuriesClosedCessna 150 · Opa Locka, FLDec 14, 1974 · N66094 · Destroyed NTSB CHI75FEI32Accident · Minor injuriesClosedCessna 150L · Alliance, OHDec 14, 1974 · N10646 · Substantial damage NTSB MKC75FCA17Accident · No injuriesClosedCessna 150F · Morley, MODec 13, 1974 · N8621G · Substantial damage NTSB CHI75FEK18Accident · No injuriesClosedCessna 150L · Zanesville, OHDec 11, 1974 · N11503 · Substantial damage NTSB OAK75FVM15Accident · No injuriesClosedCessna 150 · Woodside, CADec 7, 1974 · N6048J · Substantial damage NTSB CHI75DEG09Accident · No injuriesClosedCessna 150H · Moraine, OHDec 7, 1974 · N50250 · Substantial damage NTSB FTW75DPM11Accident · No injuriesClosedCessna 150 · Stilwell, OKDec 2, 1974 · N51408 · Substantial damage NTSB OAK75DVG39Accident · No injuriesClosedCessna 150 · Alleghany, CANov 30, 1974 · N17215 · Substantial damage NTSB OAK75DVG37Accident · No injuriesClosedCessna 150 · Pope Valley, CANov 29, 1974 · N8956S · Substantial damage NTSB IAD75FIA09Accident · No injuriesClosedCessna 150E · Clinton, MDNov 29, 1974 · N3518J · Substantial damage NTSB OAK75DVG36Accident · No injuriesClosedCessna 150 · Yuba City, CANov 24, 1974 · N66548 · Substantial damage NTSB MKC75DCG20Accident · No injuriesClosedCessna 150 · Olathe, KSNov 24, 1974 · N6420F · Substantial damage NTSB DEN75DTE39Accident · No injuriesClosedCessna 150 · Ellicott, CONov 24, 1974 · N11420 · Substantial damage NTSB FTW75DRA14Accident · Minor injuriesClosedCessna 150L · Orange, TXNov 23, 1974 · N11265 · Substantial damage NTSB IAD75FLJ13Accident · No injuriesClosedCessna 150L · New River, NCNov 22, 1974 · N1256Q · Substantial damage NTSB CHI75DEV13Accident · No injuriesClosedCessna 150M · Mattoon, ILNov 20, 1974 · N66072 · Substantial damage NTSB LAX75DUM10Accident · No injuriesClosedCessna 150 · Banner, CANov 19, 1974 · N10568 · Substantial damage NTSB CHI75FEI29Accident · No injuriesClosedCessna 150L · Strongsville, OHNov 18, 1974 · N6835G · Substantial damage NTSB MKC75FER30Accident · No injuriesClosedCessna 150L · Green Isle, MNNov 17, 1974 · N569GS · Substantial damage NTSB MIA75FKG31Accident · No injuriesClosedCessna 150 · Marietta, GANov 13, 1974 · N8511J · Substantial damage NTSB OAK75FVM12Accident · No injuriesClosedN.American F-51D · Hf Moon Bay, CANov 10, 1974 · N11T · 2 aircraft · Substantial damage NTSB NYC75FNC18Accident · No injuriesClosedCessna 150L · Nashua, NHNov 9, 1974 · N11392 · Substantial damage NTSB MIA75DKT26Accident · No injuriesClosedCessna 188 · Indiantown, FLNov 8, 1974 · N5751G · Substantial damage NTSB MKC75FTG15Accident · No injuriesClosedCessna 150 · Devils Lake, NDNov 7, 1974 · N4706X · Substantial damage NTSB FTW75FPD15Accident · Minor injuriesClosedCessna 150 · Burleson, TXNov 5, 1974 · N60281 · Substantial damage NTSB NYC75DHA21Accident · No injuriesClosedCessna 150 · Readington, NJNov 2, 1974 · N5459Q · Substantial damage NTSB CHI75DEI27Accident · No injuriesClosedCessna 150 · S Russell, OHNov 1, 1974 · N11358 · Substantial damage NTSB DEN75FTE33Accident · Serious injuriesClosedCessna 150F · Durango, COOct 28, 1974 · N6435F · Destroyed NTSB CHI75DEM19Accident · No injuriesClosedCessna 150 · Boyne City, MIOct 28, 1974 · N22919 · Substantial damage NTSB MIA75DLD37Accident · No injuriesClosedCessna 150 · Rockledge, FLOct 27, 1974 · N19144 · Substantial damage NTSB CHI75DEE29Accident · No injuriesClosedCessna 150 · Frankfort, ILOct 27, 1974 · N18522 · Substantial damage NTSB MIA75DLG16Accident · No injuriesClosedCessna 150 · Anderson, SCOct 26, 1974 · N8668G · Substantial damage NTSB LAX74FUA11Accident · No injuriesClosedCessna 150 · Laguna Bch, CAOct 25, 1974 · N9911G · Substantial damage NTSB FTW75DQG27Accident · No injuriesClosedCessna 150 · Texico, NMOct 23, 1974 · N1586Q · Substantial damage NTSB FTW75FRG29Accident · Minor injuriesClosedCessna 150F · Mathis, TXOct 20, 1974 · N8898S · Substantial damage NTSB SEA75DYC20Accident · No injuriesClosedCessna 150 · St Paul, OROct 19, 1974 · N23015 · Substantial damage NTSB OAK75DVA28Accident · No injuriesClosedCessna 150 · Visalia, CAOct 18, 1974 · N5521G · Substantial damage NTSB LAX75FUQ15Accident · No injuriesClosedCessna 140 · Van Nuys, CAOct 18, 1974 · N142EZ · Substantial damage NTSB FTW75FPD14Accident · No injuriesClosedCessna 150 · Denton, TXOct 18, 1974 · N7219S · Substantial damage NTSB MKC75DCJ34Accident · No injuriesClosedCessna 150L · Plattsmouth, NEOct 16, 1974 · N10893 · Substantial damage NTSB NYC75DNE16Accident · No injuriesClosedCessna 150 · Westboro, MAOct 15, 1974 · N7063S · Substantial damage NTSB MKC75FCD19Accident · Minor injuriesClosedCessna 150 · Runnells, IAOct 15, 1974 · N1126Y · Substantial damage NTSB DEN75ATE22Accident · No injuriesClosedCessna 150 · Greeley, COOct 14, 1974 · N19040 · Substantial damage NTSB ANC75AA036Accident · No injuriesClosedCessna 180 · Portage Crk, AKOct 12, 1974 · N46103 · Substantial damage NTSB CHI75FEK14Accident · No injuriesClosedCessna A150K · Marion, OHOct 8, 1974 · N8383M · Substantial damage