NTSB investigations, UT
10 cases where NTSB found Light condition.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2012 | 1 |
| 2017 | 2 |
| 2022 | 3 |
| 2023 | 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '030360'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '030360')) 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 WPR24FA002Accident · 4 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Moab, UTThe pilot’s loss of visual reference to the horizon while departing during dark night, which resulted in the pilot experiencing spatial disorientation and subsequent controlled flight into terrain.NTSB WPR23LA053Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-180 · Morgan, UTThe pilot’s failure to maintain clearance from snow covered terrain while maneuvering at low attitude. Contributing to the accident was the pilot’s loss of visual reference due to snow and flat light conditions.NTSB WPR23LA032Accident · No injuriesClass 4 · LimitedFinal reportHonda HA-420 · Salt Lake City, UTThe pilot’s inadvertent attempt to takeoff on a left side of runway, rather than the centerline of runway, which resulted in a collision with runway edge lights during the night time takeoff.NTSB WPR22LA358Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28RT-201 · South Jordan, UTThe pilot’s inability to see and avoid a bird while landing in dark night conditions.NTSB GAA17CA235Accident · No injuriesData collectionFinal reportRaytheon B200 · Richfield, UTThe pilot’s failure to maintain separation from a fence post during taxi at night.NTSB WPR17FA065Accident · 3 fatalField investigationFinal reportCessna 172 · Panguitch, UTThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's inadequate preflight weather planning and his poor decision-making.NTSB WPR12FA230Accident · 4 fatalField investigationFinal reportCessna 172S · St. George, UTThe pilot's failure to maintain adequate airspeed during an aggressive pitch-up maneuver, which resulted in a low-altitude aerodynamic stall shortly after takeoff. Contributing to the accident was the pilot's impairment from alcohol consumption and an…NTSB WPR09IA123Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120ER · Salt Lake City, UTThe flight crew's failure to maintain clearance from the stationary vehicle while taxiing.NTSB WPR09FA076Accident · Serious injuriesField investigationFinal reportRobinson Helicopter R44 II · West Valley City, UTThe pilot’s inadvertent VFR flight into IMC conditions, which resulted in his spatial disorientation and loss of control of the helicopter. Also causal was the flight instructor’s delay in taking remedial action.NTSB WPR09CA006Accident · No injuriesData collectionFinal reportCessna 210-5(205) · Payson, UTThe total loss of engine power during cruise flight for undetermined reasons. Contributing to the accident were a dark night and a cherry orchard at the location where the pilot executed the forced landing.