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 ANC72DAG26Accident · Minor injuriesClosedCessna 150L · Talkeetna, AKAug 18, 1971 · N6732G · Substantial damage NTSB NYC72FGT02Accident · No injuriesClosedCessna 150J · Dallastown, PAAug 17, 1971 · N5597G · Substantial damage NTSB MIA72IM013Incident · 1 fatalClosedCessna 150G · Foley, ALAug 17, 1971 · N3984J · No damage NTSB SEA72DYE10Accident · No injuriesClosedCessna 150 · Edison, WAAug 16, 1971 · N150PW · Substantial damage NTSB MIA72DKG23Accident · No injuriesClosedCessna 150G · Gray, GAAug 16, 1971 · N3301J · Substantial damage NTSB CHI72FEV13Accident · No injuriesClosedCessna 150 · Manito, ILAug 16, 1971 · N6510S · Substantial damage NTSB NYC72DID04Accident · No injuriesClosedCessna 150 · Portsmouth, VAAug 15, 1971 · N8622S · Substantial damage NTSB CHI72DEP12Accident · Minor injuriesClosedCessna 150 · Gays Mills, WIAug 15, 1971 · N6872F · Substantial damage NTSB OAK72DVM04Accident · No injuriesClosedCessna 150 · San Jose, CAAug 14, 1971 · N60816 · Substantial damage NTSB NYC72AN024Accident · No injuriesClosedCessna 150K · Frederick, MDAug 13, 1971 · N6273G · 2 aircraft · Minor damage NTSB MIA72FKJ15Accident · No injuriesClosedCessna 150 · Gadsden, ALAug 11, 1971 · N22016 · Substantial damage NTSB NYC72DLJ05Accident · Minor injuriesClosedCessna 150K · Ft Bragg, NCAug 9, 1971 · N6064G · Substantial damage NTSB NYC72DFJ09Accident · No injuriesClosedCessna 150 · Geneseo, NYAug 7, 1971 · N5769E · Substantial damage NTSB OAK72DVG11Accident · Minor injuriesClosedCessna 150 · Napa, CAAug 5, 1971 · N5682E · Destroyed NTSB MKC72DCJ12Accident · No injuriesClosedCessna 150C · Omaha, NEAug 2, 1971 · N7898Z · Substantial damage NTSB DEN72DTE12Accident · No injuriesClosedCessna 150 · Englewood, COAug 1, 1971 · N6022G · Substantial damage NTSB MKC72DCD15Accident · No injuriesClosedCessna 150 · Knoxville, IAJul 31, 1971 · N561QL · Substantial damage NTSB MIA72DLT03Accident · No injuriesClosedCessna 150 · Millington, TNJul 31, 1971 · N6806G · Substantial damage NTSB FTW72FRD03Accident · No injuriesClosedCessna 150 · Poplarville, MSJul 31, 1971 · N6654S · Substantial damage NTSB FTW72DPJ07Accident · Minor injuriesClosedCessna 150H · Okene, OKJul 31, 1971 · N6762S · Substantial damage NTSB CHI72DEY06Accident · Minor injuriesClosedCessna 150F · Carbondale, ILJul 31, 1971 · N8028F · Substantial damage NTSB MKC72DCJ10Accident · No injuriesClosedCessna 150 · Papillion, NEJul 30, 1971 · N8106S · Substantial damage NTSB LAX72DUM05Accident · No injuriesClosedCessna 150H · San Diego, CAJul 29, 1971 · N22639 · Substantial damage NTSB CHI72FEM06Accident · No injuriesClosedCessna 150H · Freeland, MIJul 27, 1971 · N23461 · Substantial damage NTSB LAX72DUJ28Accident · No injuriesClosedCessna 150 · Tempe, AZJul 25, 1971 · N2065Z · Substantial damage NTSB MIA72FKG12Accident · No injuriesClosedCessna 150K · Talbotton, GAJul 24, 1971 · N5959G · Destroyed NTSB MKC72DER07Accident · No injuriesClosedCessna 150 · Princeton, MNJul 22, 1971 · N3653J · Substantial damage NTSB CHI72FEI07Accident · No injuriesClosedCessna 150 · Cadiz, OHJul 22, 1971 · N60544 · Substantial damage NTSB OAK72FVG05Accident · No injuriesClosedCessna 150 · Napa, CAJul 15, 1971 · N4161U · Destroyed NTSB IAD72FLJ01Accident · No injuriesClosedCessna 150 · La Grange, NCJul 15, 1971 · N6194G · Substantial damage NTSB MIA72FLD02Accident · No injuriesClosedCessna 150 · St.Petersburg, FLJul 13, 1971 · N3524J · Substantial damage NTSB MKC72DC014Accident · No injuriesClosedCessna 150 · Stafford, KSJul 12, 1971 · N3915U · Substantial damage NTSB CHI72FEG01Accident · Serious injuriesClosedCessna 150J · Hillsboro, OHJul 9, 1971 · N60265 · Destroyed NTSB MKC72DCJ04Accident · No injuriesClosedCessna 150 · Omaha, NEJul 8, 1971 · N6943G · Substantial damage NTSB CHI72FEE04Accident · Minor injuriesClosedCessna 150L · Deerfield, ILJul 7, 1971 · N6926G · Substantial damage NTSB MKC72DCD02Accident · No injuriesClosedCessna 150J · Des Moines, IAJul 6, 1971 · N51183 · Substantial damage NTSB CHI72FEI02Accident · Serious injuriesClosedCessna 150K · Brunswick, OHJul 6, 1971 · N8438M · Substantial damage NTSB LAX72FUQ01Accident · No injuriesClosedCessna 150 · Van Nuys, CAJul 5, 1971 · N7102X · Substantial damage NTSB IAD72DIG03Accident · No injuriesClosedCessna 150 · Finksburg, MDJul 5, 1971 · N4538U · Substantial damage NTSB FTW72DRG02Accident · No injuriesClosedCessna 150F · Port Lavaca, TXJul 5, 1971 · N6827F · Substantial damage NTSB NYC72FNC03Accident · No injuriesClosedCessna 150 · Anson, MEJul 4, 1971 · N22867 · Substantial damage NTSB MIA71DKT01Accident · Minor injuriesClosedCessna 150H · Belle Glade, FLJul 4, 1971 · N7246S · Substantial damage NTSB SEA72FYE01Accident · No injuriesClosedCessna 150 · Lacey, WAJul 3, 1971 · N6693G · Substantial damage NTSB MIA72DKG02Accident · No injuriesClosedCessna 150F · Fort Benning, GAJul 3, 1971 · N6996F · Substantial damage NTSB LAX72DUG03Accident · No injuriesClosedChampion 7ECA · Banning, CAJul 3, 1971 · N2520F · Substantial damage NTSB FTW72DPJ01Accident · Minor injuriesClosedCessna 150L · Yukon, OKJul 3, 1971 · N6938G · Substantial damage NTSB NYC72FFA02Accident · No injuriesClosedCessna 150 · Galway, NYJul 2, 1971 · N8830G · Substantial damage NTSB NYC71FFJ38Accident · No injuriesClosedCessna 150J · Bergholtz, NYJun 30, 1971 · N50832 · Substantial damage NTSB MKC71DCD94Accident · No injuriesClosedCessna 150 · Ankeny, IAJun 30, 1971 · N6999F · Substantial damage NTSB CHI71FEK41Accident · Minor injuriesClosedCessna 150G · Columbus, OHJun 27, 1971 · N3683J · Substantial damage