NTSB investigations: Continental 0-300 series, 1973
87 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.
Cases, newest first
Query with SQL
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 year(c.\"eventDate\") = 1973
AND 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 year(c."eventDate") = 1973
AND 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" DESCRun 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 MKC73DCD57Accident · No injuriesClosedCessna 172 · Winterset, IANTSB FTW73DPD33Accident · Minor injuriesClosedCessna 172 · Abilene, TXNTSB IAD73FKM34Accident · No injuriesClosedCessna 172H · Burnsville, NCNTSB MKC73DCG38Accident · No injuriesClosedCessna 172 · Leavenworth, KSNTSB LAX73DUJ79Accident · No injuriesClosedCessna 172 · Maricopa, AZNTSB NYC73FHA24Accident · No injuriesClosedCessna 172 · Basking Ridge, NJNTSB NYC73DGM28Accident · No injuriesClosedCessna 172 · Wattsburg, PANTSB FTW73DPG44Accident · No injuriesClosedCessna 172A · Ft.Smith, ARNTSB DEN73DQD15Accident · No injuriesClosedCessna 172D · Animas, NMNTSB CHI73FEI37Accident · Serious injuriesClosedCessna 172F · Swanton, OHNTSB SEA73DYG26Accident · No injuriesClosedCessna 172 · Othello, WANTSB SEA73DYE30Accident · Serious injuriesClosedCessna 172 · Chehalis, WANTSB LAX73FUJ66Accident · Serious injuriesClosedCessna 172E · Peoria, AZNTSB MIA73AM097Accident · 1 fatalClosedCessna 172 · Missing AircraftNTSB FTW73DPA28Accident · No injuriesClosedCessna 172 · Dallas, TXNTSB DEN73DTM23Accident · Minor injuriesClosedCessna 170B · Bryce Canyon, UTNTSB OAK73DVA47Accident · No injuriesClosedCessna 172D · Patterson, CANTSB CHI73DEI36Accident · No injuriesClosedCessna 172E · N.Jackson, OHNTSB MIA73DKJ46Accident · No injuriesClosedCessna 172 · Daleville, ALNTSB CHI73FEC24Accident · No injuriesClosedCessna 172G · Romulus, MINTSB IAD73FI620Accident · No injuriesClosedCessna 172B · Berkely Spgs, WVNTSB FTW73FPA26Accident · No injuriesClosedCessna 172F · Trenton, TXNTSB CHI73AEK17Accident · No injuriesClosedCessna 172 · Lancaster, OHNTSB ANC73FAD05Accident · No injuriesClosedCessna 170B · Wrangell, AKNTSB IAD73AI005Accident · 2 fatalClosedCessna 172F · Mcclellanville, SCNTSB MKC73FCA18Accident · Serious injuriesClosedCessna 172 · Cuba, MONTSB OAK73DVM23Accident · No injuriesClosedCessna 172 · Salinas, CANTSB SEA73FYE26Accident · Serious injuriesClosedCessna 172G · Bellevue, WANTSB DEN73FQA27Accident · No injuriesClosedCessna 172G · Moriarty, NMNTSB CHI73DEI28Accident · No injuriesClosedCessna 172 · Elyria, OHNTSB MIA73DKT62Accident · No injuriesClosedCessna 172 · Ft.Lauderdale, FLNTSB DEN73DTM19Accident · No injuriesClosedCessna 172 · Vernal, UTNTSB OAK73FXQ22Accident · No injuriesClosedCessna 172 · Yerington, NVNTSB CHI73FEM43Accident · Serious injuriesClosedCessna 172H · Mcbain, MINTSB FTW73DRG44Accident · No injuriesClosedCessna 172 · Eagle Pass, TXNTSB DEN73DQA24Accident · No injuriesClosedCessna 172 · Tanner, NMNTSB CHI73DEM36Accident · Minor injuriesClosedCessna 172B · Gwinn, MI