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_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 ('2074502')
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 ('2074502')
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 CEN20LA256Accident · 1 fatalClass 3 · LimitedFinal reportCessna 320 · Round Rock, TXImproper maintenance that led to a loss of engine power due to a failed left engine magneto, the pilot’s improper application of single engine emergency procedures, and his failure to maintain control of the airplane which resulted in a collision with trees.NTSB CEN10LA567Accident · No injuriesLimited investigationFinal reportCessna 320 · Denton, TXThe failure of the landing gear push-pull rod.NTSB LAX06CA171Accident · No injuriesData collectionFinal reportCessna 320 · Long Beach, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain lateral control of the airplane during takeoff.NTSB ANC03LA053Accident · No injuriesLimited investigationFinal reportCessna 320 · McCarthy, AKThe collapse of the left main landing gear during the landing roll for undetermined reasons.NTSB FTW02LA265Accident · No injuriesLimited investigationFinal reportCessna 320 · Gatesville, TXThe loss of engine power to the left engine for undetermined reasons. A contributing factor was the rough and uneven terrain.NTSB DEN01LA139Accident · Serious injuriesLimited investigationFinal reportCessna 320 · Falcon, COthe pilot's failure to abort the takeoff following a loss of right engine power. A factor was the loss of right engine power for undetermined reasons.NTSB LAX96LA180Accident · No injuriesLimited investigationFinal reportCessna 320 · Mammoth Lakes, CAthe partial failure of the right engine turbocharger wastegate butterfly valve to fully close due to mechanical binding and the low setting of its associated absolute pressure controller. A related factor was the high density altitude which reduced the…NTSB FTW95LA372Accident · Minor injuriesLimited investigationFinal reportCessna 320 · Gunnison, COFuel exhaustion induced power loss due to the pilot's failure to refuel. A factor was his disorientation.NTSB LAX93LA179Accident · No injuriesLimited investigationFinal reportCessna 320 · Mesa, AZthe separation of the steering spring from the steering yoke assembly due to inadequate installation. A factor in the accident was inadequate maintenance on the aircraft.NTSB ATL92LA180Accident · No injuriesLimited investigationFinal reportCessna 320 · Darlington, SCThe improper servicing of the airplane with contaminated fuel by the owner pilot.NTSB FTW90FA171Accident · 1 fatalField investigationFinal reportCessna 320 · Center, TXThe pilot's failure to maintain minimum control speed (VMC) and lack of qualification/training in multi-engine aircraft, which resulted in loss of aircraft control. A factor related to the accident was: failure of the left engine turbocharger, which resulted…NTSB MKC90FA019Accident · 2 fatalField investigationFinal reportCessna 320 · Nebraska City, NEThe pilot's decision to continue the flight into IFR conditions and the failure to maintain adequate alittude. Factors related to the accident were the pilot's over confidence in his ability and the lack of instrument flight experience.NTSB MIA87FA041Accident · Serious injuriesField investigationFinal reportCessna 320 · Panama City, FLWhile executing an ILS approach with aircraft radios that were not operating properly and using a hand held transceiver, the right engine failed due to a broken fuel pressure sensor wire, and the pilot lost control of the aircraft in IMC conditions and…NTSB CHI86FA041Accident · 1 fatalField investigationFinal reportCessna 320 · Ada, OHThe pilot overflew a planned intermediate stop before running low on fuel. He was unable to find the airport he was being vectored to & attempted to land in a plowed field during dark conditions. As the aircraft passed over powerlines the aircraft was…NTSB MKC85LA061Accident · No injuriesLimited investigationFinal reportCessna 320 · Lee'S Summit, MOWhen plt lowered landing gear he did not get a safe indication. Gear appeared to be down and warning horn did not sound when throttles were retarded; however, nose gear collapsed during landing roll. Examination of system did not reveal reason for collapse…NTSB LAX82AA235Accident · 3 fatalFinal reportCessna 320B · San Jose, CAThe C-172M had departed reid-hillview arpt (6 mi east) & improperly entered a right downwind for rwy 30R at San Jose. The C-320B had executed a go-around from rwy 30R due to other traffic & was in a climbing turn also entering downwind for rwy 30R. The C-320B…NTSB SEA78FA057Accident · 6 fatalClosedCessna 320 · Anaconda, MTNTSB MKC78FCG57Accident · No injuriesClosedCessna 320 · Olathe, KSNTSB DEN78FTE81Accident · No injuriesClosedCessna 320 · Montrose, CONTSB CHI78FA071Accident · 2 fatalClosedCessna 320 · Milwaukee, WINTSB LAX77FUQ01Accident · Minor injuriesClosedCessna 320 · Oxnard, CANTSB LAX78FA074Accident · 4 fatalClosedCessna 320 · Santa Barbara, CANTSB LAX76FUQ26Accident · Serious injuriesClosedCessna 320A · Granada Hills, CANTSB MIA76RKT51Accident · Serious injuriesClosedCessna 320 · Stella Maris, Burkina FasoNTSB DEN76FTE14Accident · No injuriesClosedCessna 320 · Steamboat Spgs, CONTSB LAX75FUG38Accident · No injuriesClosedCessna 320 · Corona, CANTSB NYC75FGM22Accident · No injuriesClosedCessna 320 · Washington, PANTSB NYC74FHJ33Accident · No injuriesClosedCessna 320 · Shelter Island, NYNTSB DEN74AD030Accident · 1 fatalClosedCessna 320 · Spanish Fork, UTNTSB DEN73FTE85Accident · No injuriesClosedCessna 320C · Boulder, CONTSB CHI72FEA29Accident · Minor injuriesClosedCessna 320 · Franklin, INNTSB SEA72DTI07Accident · No injuriesClosedCessna 320 · Philipsburg, MTNTSB OAK71DVM33Accident · No injuriesClosedCessna 320 · San Jose, CANTSB MKC71FDM11Accident · No injuriesClosedCessna 320 · Sprg Lake Pk, MNNTSB MIA70FKJ31Accident · No injuriesClosedCessna 320 · Troy, ALNTSB SEA70DWA09Accident · No injuriesClosedCessna 320 · Creswell, ORNTSB DEN70FXT05Accident · No injuriesClosedCessna 320 · Ephraim, UTNTSB FTW70A0013Accident · 2 fatalClosedCessna 320 · Burleson, TXNTSB DEN70F0063Accident · No injuriesClosedCessna 320 · Albuquerque, NMNTSB CHI70D0099Accident · No injuriesClosedCessna 320 · Middleton, WINTSB DEN69F0185Accident · No injuriesClosedCessna 320 · Denver, CONTSB DEN69D0186Accident · No injuriesClosedCessna 320B · Aspen, CONTSB DEN69D0037Accident · No injuriesClosedCessna 320 · Lovington, NMNTSB LAX68D0133Accident · No injuriesClosedCessna 320 · Imperial, CANTSB NYC68A0045Accident · 6 fatalClosedCessna 320 · Bronx, NYNTSB OAK67F0250Accident · No injuriesClosedCessna 320 · Reno, NVNTSB SEA67A0014Accident · 3 fatalClosedCessna 320-1 · Fairview, ORNTSB FTW67F0153Accident · No injuriesClosedCessna 320-1 · Port Aransas, TXNTSB CHI67F0003Accident · No injuriesClosedCessna 320 · Chicago, ILNTSB FTW66D0646Accident · No injuriesClosedCessna 320 · Littlefield, TX
Back to Cessna 320