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 SEA74DTI04Accident · No injuriesClosedCessna 172 · Chester, MTJul 12, 1973 · N3809L · Substantial damage NTSB SEA74DTI03Accident · No injuriesClosedCessna 172 · Libby, MTJul 8, 1973 · N8353X · Substantial damage NTSB IAD74AI003Accident · No injuriesClosedLuscombe 8E · Pasadena, MDJul 8, 1973 · N1800K · 2 aircraft · Minor damage NTSB LAX74DUQ01Accident · No injuriesClosedCessna 172 · Goleta, CAJul 5, 1973 · N4190F · Substantial damage NTSB MIA73FKU10Accident · Minor injuriesClosedCessna 172 · Boca Raton, FLJun 29, 1973 · N5141A · Substantial damage NTSB SEA73DYA34Accident · No injuriesClosedCessna 172 · Preston, IDJun 23, 1973 · N2508L · Substantial damage NTSB FTW73FPJ24Accident · Serious injuriesClosedCessna 172A · Canton, OKJun 23, 1973 · N7518T · Substantial damage NTSB OAK73DVM39Incident · No injuriesClosedCessna 150 · Moss Beach, CAJun 19, 1973 · N17147 · 2 aircraft · Minor damage NTSB NYC73FHJ21Accident · Minor injuriesClosedCessna 172 · Edgewater Park, NYJun 8, 1973 · N3813L · Substantial damage NTSB MKC73FTG18Accident · No injuriesClosedCessna 172 · Grand Forks, NDJun 4, 1973 · N5596R · Substantial damage NTSB OAK73DVW21Accident · No injuriesClosedCessna 172 · Overton, NVMay 27, 1973 · N4655L · Substantial damage NTSB MKC73DTG13Accident · No injuriesClosedCessna 172 · Grace City, NDMay 21, 1973 · N7423A · Substantial damage NTSB MIA73FLA38Accident · No injuriesClosedCessna 172 · Defuniak Spng, FLMay 21, 1973 · N7609X · Substantial damage NTSB ANC73DAG93Accident · No injuriesClosedCessna 170B · Glennallen, AKMay 19, 1973 · N4538C · Substantial damage NTSB MIA73DKT99Accident · No injuriesClosedCessna 172G · Belle Glade, FLMay 18, 1973 · N5971R · Substantial damage NTSB CHI73DEP57Accident · No injuriesClosedCessna 172G · Wilmot, WIMay 17, 1973 · N5767R · Substantial damage NTSB DEN73DQA41Accident · No injuriesClosedCessna 170 · Los Alamos, NMMay 16, 1973 · N3947V · Substantial damage NTSB LAX73DUG57Accident · No injuriesClosedCessna 172 · Banning, CAMay 13, 1973 · N8162B · Substantial damage NTSB SEA73DYC28Accident · No injuriesClosedCessna 172G · Madras, ORMay 8, 1973 · N4156L · Substantial damage NTSB IAD73FIG25Accident · No injuriesClosedCessna 172A · Essex, MDMay 6, 1973 · N7706T · Substantial damage NTSB MIA73DLA35Accident · No injuriesClosedCessna 172D · Sunnyside Bch, FLMay 5, 1973 · N2500X · Substantial damage NTSB MKC73FTG12Accident · No injuriesClosedCessna 172 · Fargo, NDMay 3, 1973 · N1892Y · Substantial damage NTSB LAX73FUA41Accident · No injuriesClosedCessna 172 · Santa Ana, CAApr 28, 1973 · N4303L · Substantial damage NTSB MKC73DCD57Accident · No injuriesClosedCessna 172 · Winterset, IAApr 22, 1973 · N1478F · Substantial damage NTSB FTW73DPD33Accident · Minor injuriesClosedCessna 172 · Abilene, TXApr 21, 1973 · N3718F · Substantial damage NTSB IAD73FKM34Accident · No injuriesClosedCessna 172H · Burnsville, NCApr 20, 1973 · N3872R · Substantial damage NTSB MKC73DCG38Accident · No injuriesClosedCessna 172 · Leavenworth, KSApr 19, 1973 · N7733T · Substantial damage NTSB LAX73DUJ79Accident · No injuriesClosedCessna 172 · Maricopa, AZApr 19, 1973 · N5564R · Substantial damage NTSB NYC73FHA24Accident · No injuriesClosedCessna 172 · Basking Ridge, NJApr 17, 1973 · N3636S · Substantial damage NTSB NYC73DGM28Accident · No injuriesClosedCessna 172 · Wattsburg, PAApr 16, 1973 · N5360R · Substantial damage NTSB FTW73DPG44Accident · No injuriesClosedCessna 172A · Ft.Smith, ARApr 12, 1973 · N7480T · Substantial damage NTSB DEN73DQD15Accident · No injuriesClosedCessna 172D · Animas, NMApr 9, 1973 · N2154Y · Substantial damage NTSB CHI73FEI37Accident · Serious injuriesClosedCessna 172F · Swanton, OHApr 7, 1973 · N8472U · Substantial damage NTSB SEA73DYG26Accident · No injuriesClosedCessna 172 · Othello, WAApr 5, 1973 · N7021T · Substantial damage NTSB SEA73DYE30Accident · Serious injuriesClosedCessna 172 · Chehalis, WAApr 3, 1973 · N6718A · Substantial damage NTSB LAX73FUJ66Accident · Serious injuriesClosedCessna 172E · Peoria, AZApr 3, 1973 · N3658R · Substantial damage NTSB MIA73AM097Accident · 1 fatalClosedCessna 172 · Missing AircraftMar 28, 1973 · N7050T · Destroyed NTSB FTW73DPA28Accident · No injuriesClosedCessna 172 · Dallas, TXMar 24, 1973 · N8151L · Substantial damage NTSB DEN73DTM23Accident · Minor injuriesClosedCessna 170B · Bryce Canyon, UTMar 19, 1973 · N8017A · Substantial damage NTSB OAK73DVA47Accident · No injuriesClosedCessna 172D · Patterson, CAMar 16, 1973 · N2693U · Substantial damage NTSB CHI73DEI36Accident · No injuriesClosedCessna 172E · N.Jackson, OHMar 16, 1973 · N5336T · Substantial damage NTSB MIA73DKJ46Accident · No injuriesClosedCessna 172 · Daleville, ALMar 15, 1973 · N8721U · Substantial damage NTSB CHI73FEC24Accident · No injuriesClosedCessna 172G · Romulus, MIMar 15, 1973 · N3793L · Substantial damage NTSB IAD73FI620Accident · No injuriesClosedCessna 172B · Berkely Spgs, WVMar 11, 1973 · N7764X · Substantial damage NTSB FTW73FPA26Accident · No injuriesClosedCessna 172F · Trenton, TXMar 11, 1973 · N1117T · Substantial damage NTSB CHI73AEK17Accident · No injuriesClosedCessna 172 · Lancaster, OHMar 11, 1973 · N4205F · Substantial damage NTSB ANC73FAD05Accident · No injuriesClosedCessna 170B · Wrangell, AKMar 10, 1973 · N2961D · Substantial damage NTSB IAD73AI005Accident · 2 fatalClosedCessna 172F · Mcclellanville, SCMar 9, 1973 · N5310R · Destroyed NTSB MKC73FCA18Accident · Serious injuriesClosedCessna 172 · Cuba, MOFeb 25, 1973 · N5662R · Substantial damage NTSB OAK73DVM23Accident · No injuriesClosedCessna 172 · Salinas, CAFeb 18, 1973 · N7613T · Substantial damage