Fatal NTSB investigations
6 cases where NTSB found Bright light.
Cases per year
| 2010 | 1 |
|---|---|
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2019 | 1 |
| 2021 | 1 |
Where
Latest 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03036010'))
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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03036010')) 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 WPR22FA011Accident · 1 fatalClass 3 · FieldFinal reportCessna 175 · Reserve, NMThe pilot’s failure to maintain clearance from terrain while maneuvering at a low altitude. Contributing to the accident was the pilot’s reduced forward visibility due to the sun.NTSB WPR19FA095Accident · 1 fatalClass 3 · FieldFinal reportNorth American T28 · Compton, CAThe failure of the T-28 pilot to see and avoid the Cessna while landing with reduced visibility due to sun glare, which resulted in a collision on the runway. Contributing to the accident was his failure to use the airport's common traffic advisory frequency…NTSB WPR16FA148Accident · 1 fatalField investigationFinal reportAir Tractor AT 502B · Zamora, CAThe failure of both pilots to maintain an adequate visual lookout, which resulted in a midair collision. Also causal was the other pilot's use of two sedating antihistamines and two impairing medication and the effect of sun glare on his visual lookout, which…NTSB CEN15FA030Accident · 1 fatalField investigationFinal reportMooney M20 · Boulder, COThe loss of airplane control for reasons that could not be determined by the postaccident examination, which was limited due to impact damage and postcrash fire.NTSB WPR13FA119Accident · 3 fatalField investigationFinal reportBell 206B · Acton, CAThe pilot's decision to conduct a flight in dark night conditions with an illuminated cockpit light that degraded his visibility and his ability to identify and arrest the helicopter's descent while maneuvering, which resulted in controlled flight into…NTSB CEN10FA299Accident · 1 fatalField investigationFinal reportBeech G35 · Marble, COThe pilot’s miscalculation of the airplane's turn radius and climb capabilities at high altitude, resulting in controlled flight into terrain. Contributing to the accident was the pilot's lack of mountain flying experience and restricted visibility due to the…