Skip to content

NTSB investigations: Continental 0-300 series

3,125 cases on aircraft whose registry engine model is Continental 0-300 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 ('17022')) 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 ('17022'))
  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 ('17022'))
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 FTW74FQG55Accident · No injuriesClosedCessna 170B · Slaton, TXMay 18, 1974 · N2958D · Substantial damage NTSB CHI74DEC43Accident · No injuriesClosedCessna 172 · Goodells, MIMay 5, 1974 · N8584V · Substantial damage NTSB MKC74DCG34Accident · No injuriesClosedCessna 172 · Horton, KSMay 4, 1974 · N1638F · Substantial damage NTSB NYC75FHJ27Incident · No injuriesClosedCessna 172 · Ronkonkoma, NYApr 24, 1974 · N503E · Minor damage NTSB CHI74DEK22Accident · No injuriesClosedCessna 172C · Columbus, OHApr 14, 1974 · N1675Y · Substantial damage NTSB ANC74DAG98Accident · No injuriesClosedCessna 170A · Mt.Village, AKApr 12, 1974 · N5724C · Substantial damage NTSB OAK74DVD27Accident · No injuriesClosedCessna 170B · Novato, CAApr 8, 1974 · N3497D · Substantial damage NTSB DEN74FTE62Accident · No injuriesClosedMaule M4220C · Brighton, COApr 1, 1974 · N40694 · Substantial damage NTSB SEA74FTI20Accident · No injuriesClosedCessna 172B · Livingston, MTMar 30, 1974 · N7972X · Substantial damage NTSB NYC74DFA24Accident · No injuriesClosedCessna 172 · Ellenville, NYMar 27, 1974 · N3771R · Substantial damage NTSB SEA74DYE40Accident · No injuriesClosedCessna 172 · Olympia, WAMar 9, 1974 · N4681L · Substantial damage NTSB CHI74DEE57Accident · No injuriesClosedCessna 172H · Aurora, ILFeb 28, 1974 · N2413L · Substantial damage NTSB IAD74DLJ31Accident · No injuriesClosedCessna 172 · Farmville, NCFeb 21, 1974 · N1100F · Substantial damage NTSB NYC74FHM16Accident · No injuriesClosedCessna 172H · Newburgh, NYFeb 19, 1974 · N2863L · Substantial damage NTSB FTW74AF062Accident · 1 fatalClosedCessna 172A · Hot Springs, ARFeb 17, 1974 · N6839X · Destroyed NTSB DEN74FTC25Accident · No injuriesClosedCessna 172 · Pt.Of Rocks, WYFeb 16, 1974 · N8638U · Substantial damage NTSB OAK74AXQ22Accident · Minor injuriesClosedCessna 170B · Eureka, NVFeb 13, 1974 · N2731D · Substantial damage NTSB FTW74DPG44Accident · No injuriesClosedCessna 172E · Springdale, ARJan 26, 1974 · N7712U · Substantial damage NTSB NYC74DNA32Accident · No injuriesClosedCessna 172 · Marlboro, MAJan 25, 1974 · N4261L · Substantial damage NTSB IAD74DKM37Accident · No injuriesClosedCessna 172 · Maiden, NCJan 22, 1974 · N8282B · Substantial damage NTSB IAD74DLJ30Accident · No injuriesClosedCessna 172G · Hamilton, NCJan 18, 1974 · N4642L · Substantial damage NTSB NYC74FGT15Accident · No injuriesClosedCessna 172 · Carlisle, PAJan 15, 1974 · N8198L · Substantial damage NTSB SEA74DVE35Accident · Minor injuriesClosedCessna 172 · Bellingham, WAJan 2, 1974 · N1300T · Substantial damage NTSB MKC74DCG17Accident · No injuriesClosedCessna 172 · Leawood, KSDec 26, 1973 · N8713B · Substantial damage NTSB DEN74FTM09Accident · No injuriesClosedCessna 172D · West Jordan, UTDec 19, 1973 · N2651U · Substantial damage NTSB MIA74DKT50Accident · No injuriesClosedCessna 172 · Miami, FLDec 13, 1973 · N8443U · Substantial damage NTSB MKC74FCJ17Accident · No injuriesClosedCessna 172 · Beatrice, NEDec 2, 1973 · N2594L · Destroyed NTSB MIA74DKG44Accident · No injuriesClosedCessna 172 · Covington, GANov 24, 1973 · N6910X · Substantial damage NTSB IAD74AI027Accident · 2 fatalClosedCessna 170 · Glasgow, KYNov 18, 1973 · N3556C · Destroyed NTSB OAK74DVG17Accident · No injuriesClosedCessna 172 · Sutter Crk, CAOct 11, 1973 · N7707U · Substantial damage NTSB FTW74FPG29Accident · Serious injuriesClosedCessna 172H · Carlisle, AROct 8, 1973 · N3790F · Destroyed NTSB IAD74DKM21Accident · No injuriesClosedCessna 172 · Asheville, NCOct 7, 1973 · N5970A · Substantial damage NTSB CHI74FEK06Accident · Serious injuriesClosedCessna 172 · Caledonia, OHOct 6, 1973 · N7121T · Substantial damage NTSB SEA74DTA09Accident · No injuriesClosedCessna 170B · Glasgow, MTSep 24, 1973 · N3469C · Substantial damage NTSB CHI74DET10Accident · Minor injuriesClosedCessna 172 · Peru, INSep 23, 1973 · N1617F · Substantial damage NTSB NYC74AN028Accident · No injuriesClosedCessna 172 · Ronkonkoma, NYSep 21, 1973 · N6115E · Substantial damage NTSB NYC74AN022Accident · 1 fatalClosedCessna 172H · Wheeling, ILSep 13, 1973 · N2665L · 2 aircraft · Minor damage NTSB MKC74DCQ14Accident · No injuriesClosedCessna 172 · Inman, KSSep 10, 1973 · N3734F · Substantial damage NTSB FTW74DRA13Accident · No injuriesClosedCessna 150K · Houston, TXSep 2, 1973 · N6173G · Substantial damage NTSB MIA74FKG21Accident · No injuriesClosedCessna 172F · Jasper, GASep 1, 1973 · N7870U · Substantial damage NTSB IAD74FID12Accident · No injuriesClosedCessna 172B · Ashland, VASep 1, 1973 · N7505X · Substantial damage NTSB ANC74DAG24Accident · No injuriesClosedCessna 172 · Anchorage, AKAug 27, 1973 · N5758R · Substantial damage NTSB LAX74FUA04Accident · No injuriesClosedCessna 172C · Huntngtn Bh, CAAug 26, 1973 · N8248X · Substantial damage NTSB DEN74DTM07Accident · No injuriesClosedCessna 172 · Green River, UTAug 25, 1973 · N5934A · Substantial damage NTSB MKC74DTK03Accident · No injuriesClosedCessna 172G · Monroe, SDAug 18, 1973 · N4444L · Substantial damage NTSB CHI74FEC08Accident · No injuriesClosedMaule M-4 · Otisville, MIAug 18, 1973 · N4736T · Substantial damage NTSB CHI74FEP10Accident · Serious injuriesClosedCessna 172 · Cadott, WIAug 10, 1973 · N8595U · Destroyed NTSB NYC74DHD07Accident · No injuriesClosedCessna 172H · Vineland, NJAug 6, 1973 · N2468L · Substantial damage NTSB FTW74FPD03Accident · No injuriesClosedCessna 172 · Iowa Park, TXJul 25, 1973 · N7117T · Substantial damage NTSB MKC74DCD03Accident · Minor injuriesClosedCessna 172 · Bedford, IAJul 18, 1973 · N5741R · Substantial damage