Skip to content

NTSB investigations · 16

Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('2074506') 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('2074506')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('2074506')
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 FTW97LA020Accident · No injuriesLimited investigationFinal reportCessna 320A · Longmont, COThe partial failure of the fuel control servo, causing an excessive flow/output of fuel to, and flooding of, the right engine.Oct 18, 1996 · N430N · Substantial damage NTSB SEA96FA094Accident · 2 fatalField investigationFinal reportCessna 320A · Provo, UTA fuel leak most probably ignited by hot exhaust gases from the leaking right engine manifold exhaust system, the decision by the pilots to operate the aircraft with knowledge of the fuel leak, and the pilot-in-command's failure to maintain adequate clearance…May 15, 1996 · N600JR · Destroyed NTSB LAX92LA344Accident · No injuriesLimited investigationFinal reportCessna 320A · Novato, CAThe locked left brake assembly due to the missing brake retaining clips.Aug 9, 1992 · N3014R · Substantial damage NTSB ATL82DA111Accident · No injuriesFinal reportCessna 320A · Paintsville, KYThe pilot reported encountering wind shear at about 300 ft from the approach end of runway 31. He stated that the aircraft crabbed to the left and right rudder was applied. Also, he reported that the plane stalled about six to ten feet above the runway and…Apr 21, 1982 · N600JR · Substantial damage NTSB NYC81FA041Accident · 2 fatalClosedCessna 320 · West Mifflin, PAApr 20, 1981 · N5500E · Destroyed NTSB OAK79FA036Accident · 2 fatalClosedCessna 320A · Monterey, CAJul 26, 1979 · N3005R · Destroyed NTSB DEN76O0001Accident · 4 fatalClosedCessna 320 · Puerta Valrto, MexicoOct 18, 1975 · N3043R · Destroyed NTSB OAK74FXQ23Accident · No injuriesClosedCessna 320A · Fallon, NVFeb 24, 1974 · N3033R · Substantial damage NTSB CHI74FEE26Accident · 1 fatalClosedCessna 320 · Northbrook, ILOct 14, 1973 · N861W · Destroyed NTSB OAK73IP016Incident · No injuriesClosedCessna 320A · Redding, CADec 12, 1972 · N3044R · Minor damage NTSB DEN68A0028Accident · 1 fatalClosedCessna 320A · Kanosh, UTDec 30, 1967 · N3047R · Destroyed NTSB DEN68F0034Accident · Serious injuriesClosedCessna 320A · Alamosa, COJul 23, 1967 · N3017R · Destroyed NTSB OAK67A0080Accident · No injuriesClosedCessna 320A · Montello, NVMay 18, 1967 · N3014R · Substantial damage NTSB CHI66F0579Accident · No injuriesClosedCessna 320 · Saginaw, MIFeb 17, 1966 · N5500E · Substantial damage NTSB UNK65X1408Accident · No injuriesClosedCessna 320 · Rancho Mirage, CAFeb 8, 1965 · N3012R · Substantial damage NTSB UNK65X0590Accident · No injuriesClosedCessna 320 · Norfolk, NENov 7, 1964 · N3047R · Substantial damage

Back to Cessna 320A