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 DEN72DTE43Accident · No injuriesClosedCessna 150G · Broomfield, CONov 13, 1971 · N3484J · Substantial damage NTSB CHI72FLQ19Accident · No injuriesClosedCessna 150 · Hawesville, KYNov 10, 1971 · N1014M · Substantial damage NTSB MIA72DLD22Accident · No injuriesClosedCessna 150H · Odessa, FLNov 7, 1971 · N6647S · Substantial damage NTSB FTW72FPG54Accident · No injuriesClosedCessna 150 · Jacksonville, ARNov 7, 1971 · N6182T · Substantial damage NTSB OAK72DVM10Accident · No injuriesClosedCessna 150 · Morgan Hill, CAOct 31, 1971 · N2829S · Substantial damage NTSB MIA72DLA18Accident · Minor injuriesClosedCessna 150G · Micanopy, FLOct 28, 1971 · N3281J · Substantial damage NTSB SEA72FYA16Accident · No injuriesClosedCessna 150 · Garden City, IDOct 26, 1971 · N50775 · Substantial damage NTSB LAX72FUQ40Accident · No injuriesClosedCessna 150H · Van Nuys, CAOct 26, 1971 · N23076 · Substantial damage NTSB OAK72FVD22Accident · No injuriesClosedCessna 150G · Lodi, CAOct 25, 1971 · N3405J · 2 aircraft · Substantial damage NTSB FTW72FPD16Accident · No injuriesClosedCessna 150 · Wichita Falls, TXOct 21, 1971 · N4337U · 2 aircraft · Substantial damage NTSB NYC72FFA22Accident · Minor injuriesClosedCessna 150H · Frankfort, NYOct 20, 1971 · N7072S · Substantial damage NTSB DEN72FTE34Accident · No injuriesClosedCessna 150 · Aurora, COOct 20, 1971 · N3731J · Substantial damage NTSB CHI72FEE41Accident · No injuriesClosedCessna 150 · Seneca, ILOct 20, 1971 · N5696G · Substantial damage NTSB NYC72DFA20Accident · No injuriesClosedCessna 150 · Round Lake, NYOct 18, 1971 · N4268U · Substantial damage NTSB CHI72DEE38Accident · No injuriesClosedCessna 150 · Sandwich, ILOct 18, 1971 · N5944G · Substantial damage NTSB NYC72DKM09Accident · No injuriesClosedCessna 150 · Indian Trail, NCOct 17, 1971 · N6801G · Substantial damage NTSB NYC72DNC11Accident · No injuriesClosedCessna 150 · Derry, NHOct 16, 1971 · N7118X · Substantial damage NTSB MIA72FLA15Accident · No injuriesClosedCessna 150 · Pensacola, FLOct 16, 1971 · N5873G · Substantial damage NTSB FTW72FRG32Accident · Minor injuriesClosedCessna 150G · San Antonio, TXOct 11, 1971 · N2464J · Substantial damage NTSB OAK72FXQ15Accident · No injuriesClosedLuscombe 8A · Reno, NVOct 10, 1971 · N28629 · Substantial damage NTSB NYC72DHA19Accident · No injuriesClosedCessna 150 · Manville, NJOct 9, 1971 · N6426G · Substantial damage NTSB LAX72FUG24Accident · No injuriesClosedCessna 150 · Mentone, CAOct 9, 1971 · N50098 · Substantial damage NTSB LAX72DUG26Accident · No injuriesClosedCessna 150 · Blythe, CAOct 3, 1971 · N3549L · Substantial damage NTSB LAX72FUQ31Accident · Minor injuriesClosedCessna 150 · Newhall, CAOct 1, 1971 · N8910S · Destroyed NTSB CHI72FEM35Accident · No injuriesClosedCessna 150K · Bath, MISep 30, 1971 · N6069G · Substantial damage NTSB FTW72FRA10Accident · No injuriesClosedCessna 150E · Pearland, TXSep 27, 1971 · N6211R · Substantial damage NTSB MIA72DKJ24Accident · No injuriesClosedCessna 150 · Arab, ALSep 25, 1971 · N6063G · Substantial damage NTSB LAX72DUG16Accident · No injuriesClosedCessna 150H · Elsinore, CASep 25, 1971 · N6617S · Substantial damage NTSB MKC72DCJ28Accident · No injuriesClosedCessna 150 · Papillion, NESep 17, 1971 · N22915 · Substantial damage NTSB NYC72DFA15Accident · No injuriesClosedCessna 150 · Selkirk, NYSep 16, 1971 · N2413J · Substantial damage NTSB CHI72FEM29Accident · No injuriesClosedCessna 150 · Traverse Cty, MISep 15, 1971 · N8893S · Substantial damage NTSB ANC72DAG38Accident · Minor injuriesClosedCessna 150K · Anchorage, AKSep 14, 1971 · N6210G · Substantial damage NTSB LAX72DVA23Accident · No injuriesClosedCessna 150J · Arvin, CASep 12, 1971 · N5607G · Substantial damage NTSB CHI72FLQ10Accident · Serious injuriesClosedCessna 150H · Hazard, KYSep 10, 1971 · N7023S · Destroyed NTSB NYC72AN052Accident · No injuriesClosedPiper PA-32 · Fitchburg, MASep 9, 1971 · N294HA · 2 aircraft · Minor damage NTSB NYC72DGM15Accident · No injuriesClosedCessna 150 · Eighty Four, PASep 5, 1971 · N61038 · Substantial damage NTSB NYC72FIJ29Accident · Serious injuriesClosedCessna 150 · Abingdon, VASep 4, 1971 · N5994G · Destroyed NTSB NYC72DHD06Accident · No injuriesClosedCessna 150 · Wildwood, NJAug 31, 1971 · N50741 · Substantial damage NTSB FTW72FRA05Accident · Serious injuriesClosedCessna 150 · Houston, TXAug 31, 1971 · N60441 · Substantial damage NTSB DEN72DTE26Accident · No injuriesClosedCessna 150 · Hillrose, COAug 31, 1971 · N6859G · Substantial damage NTSB MKC72DCQ23Accident · No injuriesClosedCessna 150 · Med Lodge, KSAug 30, 1971 · N3915U · Substantial damage NTSB MIA72FKQ13Accident · No injuriesClosedCessna 150J · Brookhaven, MSAug 28, 1971 · N60677 · Substantial damage NTSB DEN72DTE29Accident · No injuriesClosedCessna 150H · Aurora, COAug 28, 1971 · N23175 · Substantial damage NTSB MKC72DCD30Accident · No injuriesClosedCessna 150G · Knoxville, IAAug 25, 1971 · N3012S · Substantial damage NTSB MIA72DKT08Accident · No injuriesClosedCessna 150F · Opa Locka, FLAug 24, 1971 · N8568G · Substantial damage NTSB ANC72AA013Accident · 2 fatalClosedPiper PA-18 · Kenai, AKAug 24, 1971 · N3393B · 2 aircraft · Destroyed NTSB SEA72DYA12Accident · No injuriesClosedCessna 150 · Rexburg, IDAug 23, 1971 · N22281 · Substantial damage NTSB OAK72DVG20Accident · No injuriesClosedCessna 150H · Davis, CAAug 21, 1971 · N22663 · Substantial damage NTSB MKC72DCD27Accident · No injuriesClosedCessna 150G · Calamus, IAAug 21, 1971 · N4738X · Substantial damage NTSB FTW72DRG18Accident · No injuriesClosedCessna 150 · Raymondville, TXAug 20, 1971 · N60532 · Substantial damage