NTSB investigations, UT
55 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
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 c.\"eventStateOrRegion\" = 'UT' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130)
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."eventStateOrRegion" = 'UT' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130) 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 DEN83LA145Accident · No injuriesLimited investigationFinal reportCessna 195A · St. George, UTThe prop blade separated causing the acft to veer sharply to the left out of control. The acft came to rest about 30 ft from the rwy with the right main landing gear broken off. A metallurgical exam revealed that the blade failed from fatigue. The fatigue…NTSB DEN83LU001Accident · 1 fatalFinal reportIntl Ultralight Banshee · St. George, UTReportedly, the ultralight vehicle was assembled at an abandoned arpt, then was test flown by an international ultralight company salesman. The non-rated plt, who was planning to buy the ultralight, then flew the vehicle to familiarize himself with its flt…NTSB DEN83FTM01Accident · 1 fatalFinal reportBowers Flybaby 1A · Ephriam, UTApproximately 4 ft of the inboard section of the left wing separated in flight during an aerobatic maneuver. Witnesses stated that the acft had been performing little loops & then it went straight up & rolled off to the left upside down. It then spiralled…NTSB DEN82DA160Accident · No injuriesFinal reportCessna 421C · Bountiful, UTThe pilot reported that the approach and landing to touchdown were normal. At touchdown, the aircraft shuttered and pulled to the right, but was kept on the runway through the use of left brake and nosewheel steering. After continuing down the runway for…NTSB DEN82DA073Accident · Minor injuriesFinal reportHughes 369D (500D) · Coalville, UTThe helicopter made a hard landing after the pilot experienced a power train failure while flying low and slow. The weather was VMC and a VFR flight plan was filed. The crew was searching for lost mining equipment in a low slow search pattern. The pilot heard…