NTSB investigations, UT
21 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 1997 | 1 |
| 1999 | 2 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 1 |
Where
Open the mapLatest cases
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\" = 310)
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" = 310) 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 SEA06CA180Accident · No injuriesData collectionFinal reportBeech B36TC · Cedar City, UTInadvertent collision with a deer during takeoff. A contributing factor was night conditions.NTSB SEA06CA009Accident · No injuriesData collectionFinal reportCessna A185F · Lake Powell, UTThe pilot's failure to maintain clearance from terrain during an aborted water takeoff run which resulted in the airplane colliding with a canyon wall. A contributing factor was the submerged object that the airplane struck during the takeoff run.NTSB DEN05IA098Incident · No injuriesIncident investigationFinal reportBoeing 737-524 · Salt Lake City, UTthe left wing walker's failure to maintain an adequate visual lookout. Contributing factors were his inadequate initial training, and the failure of other ground personnel to follow company procedures/directives.NTSB DEN04CA111Accident · Minor injuriesData collectionFinal reportBell 206 L-1 · Escalante, UTthe pilot's failure to maintain aircraft control. Factors contributing to the accident were the high winds, the gusts, and the refueling truck.NTSB DEN03LA075Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-60 · Salt Lake City, UTthe pilot improperly aligning the airplane on the runway for takeoff. Contributing factors were the reduced visibility due to rain, and the dark night.NTSB DEN03IA054Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120ER · Cedar City, UTthe captain's failure to maintain directional control during takeoff. Factors contributing to the accident were the crew's diverted attention, the snow and slush-covered runway, the fog, and the runway marker.NTSB DEN99LA161Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Heber City, UTThe pilot's failure to maintain aircraft control during takeoff roll. Factors were the gusting crosswind conditions, and the airport sign.NTSB DEN99LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Provo, UTThe pilot exercising poor judgment by ignoring proper procedures/directives, his intentional selection of the wrong runway for takeoff, and his failure to maintain an adequate visual lookout. Factors were his ostentatious display, the other airplane moving on…NTSB SEA97LA114Accident · No injuriesLimited investigationFinal reportCessna T207A · Monument Valley, UTA horse entering the runway after the aircraft touched down. Factors included no fence installed around part of the airstrip, and remedial action not possible.NTSB SEA95LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Panguitch, UTthe pilot's misjudgment of the distance from the sign post.NTSB SEA94LA195Accident · No injuriesLimited investigationFinal reportPitts S-2B · Salt Lake City, UTThe inadequate visual lookout by the instructor and dual student. Factors include sunglare and the tug left on the taxiway.NTSB SEA94LA078Accident · No injuriesLimited investigationFinal reportSchweizer 2-33A · Heber City, UTThe flight instructor's delayed/inadequate remedial action. Factors include the student pilot's failure to maintain directional control, and unfavorable/variable, gusty winds during the takeoff roll.NTSB SEA93LA136Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Provo, UTThe wild animals on the runway. A factor relating to the accident was the dark night light conditions.NTSB SEA93LA005Accident · No injuriesLimited investigationFinal reportSchweizer SSG 2-33A · Heber City, UTThe proper alignment was not maintained by the pilot. A factor relating to the accident was the sign located beside the runway.NTSB SEA91IA159Incident · No injuriesIncident investigationFinal reportGalaxy GLX-7 · Provo, UTThe pilot's diverted attention. Facotrs include on ground contact with a fence.NTSB DEN90LA110Accident · No injuriesLimited investigationFinal reportCessna 205 · Bluff, UTFailure of the pilot to properly select and survey his landing site.NTSB DEN89LA193Accident · Serious injuriesLimited investigationFinal reportAerofab Lake LA-250 · Bullfrog, UTA submerged object in the landing area.NTSB DEN89FA070Accident · No injuriesField investigationFinal reportSwearingen SA-227-AC · Salt Lake City, UTThe failure of captain of N169SW to maintain a visual lookout while taxiing his aircraft allowing his aircraf to creep into the stationary aircraft in front of him.NTSB DEN87LA022Accident · No injuriesLimited investigationFinal reportCessna 150 · St. George, UTDuring a touch and go landing, the acft's left landing gear tangled in loose wire. The acft swerved to the the left, struck a used tire barrier then nosed over. The landing was made on a closed rwy.NTSB DEN85LA087Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Lapoint, UTThe acft collided with a snowbank while taking off from a road near Lapoint, Utah. The acft was being used to count elk on an indian reservation. The plt landed to relieve himself. On the subsequent takeoff the acft hit a chuckhole in the road which caused it…NTSB DEN84LA126Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Ogden, UTThe plt got out of the acft to check the starter solenoid by turning the propeller. He left the mags on and the brakes off. When the prop was turned the acft started and collided with a parked acft.