NTSB investigations, UT
59 cases where the first occurrence was “In flight collision with object”.
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\" = 220)
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" = 220) 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 DEN84LA156Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Bountiful, UTThe aircraft was on short final during instructional landing practice. A truck loaded with a backhoe was crossing the end of the runway from left to right on a public access road which displayed no caution or warning signs regarding aircraft operations.…NTSB DEN84FU003Accident · Serious injuriesFinal reportAmerican Falcon · Salt Lake City, UTReportedly, the plt made an apch to rwy 18, then initiated a go-around due to traffic on the rwy. He reported that traffic to the left necessitated a right pattern. There were power lines located aprx 500 ft west of the grass strip, about 40 to 50 ft AGL.…NTSB DEN84LA092Accident · No injuriesLimited investigationFinal reportCessna T-210 · Duchesne, UTThe acft departed the side of the rwy during the landing roll. The plt stated that he could no determine where the center of the rwy was due to about 2 inches of fresh snow. The rt landing gear collapsed & the nose gear failed.NTSB DEN83LA163Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Hooper, UTThe spraying operation was being conducted over a large mosquito abatement district. The district was mapped out into several small areas to be sprayed. Due to the many areas to be sprayed, the plt did not inspect each section for obstacles prior to the flt.…NTSB DEN83FTM05Accident · Serious injuriesFinal reportBensen B-8M · Wendover, UTThe gyrocopter collided with a powerline at 29 ft AGL. The pilot took off from a road and in proceeding along the road collided with the wires. The pilot was seriously injured. His student pilot certificate had expired in dec. 1979. Due tohis injuries no…NTSB DEN83FTM04Accident · Minor injuriesFinal reportPiper PA-25-235 · Delta, UTThe acft collided with two power lines on a clean up swath run. The acft rolled inverted and struck the ground. The field being sprayed was bordered on the north by highly visible wires. The wires that ran along the east side were not so visible. There was…NTSB DEN83LA042Accident · No injuriesLimited investigationFinal reportBeech V35B · Kamis, UTThe plt stated he noticed a drop in oil pressure & a prop surge & decided to make a precautionary landing on a road. During the landing the acft struck several sign posts. Post accident tests showed no evidence of oil starvation or drop in oil pressure.NTSB DEN83FTM03Accident · 3 fatalFinal reportCessna T210M · Tremonton, UTThe acft was observed flying over the interstate highway approximately 100 ft AGL prior to colliding with two high voltage power transmission lines.NTSB DEN82FA193Accident · 1 fatalField investigationFinal reportCessna R172K · Vernal, UTThe aircraft collided with trees while low flying on a local flight. Two aircraft piloted by students from a nearby college had been seen flying low and close to each other around the local mountainous terrain. The students were enrolled in the college…