NTSB investigations, 2008
8 cases where NTSB found Alertness/Fatigue.
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 11 |
| 2010 | 8 |
| 2011 | 13 |
| 2012 | 5 |
| 2013 | 10 |
| 2014 | 1 |
| 2015 | 6 |
| 2016 | 7 |
| 2017 | 6 |
| 2018 | 3 |
| 2019 | 1 |
| 2020 | 5 |
| 2021 | 1 |
| 2022 | 5 |
| 2023 | 4 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 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 year(c.\"eventDate\") = 2008
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '020135'))
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 year(c."eventDate") = 2008 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '020135')) 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 WPR09LA016Accident · 1 fatalLimited investigationFinal reportHeisler Lancair Legacy · Parowan, UTThe pilot failed to secure the canopy prior to takeoff, resulting in his inability to control the aircraft during the takeoff. Contributing to the accident was the pilot’s impairment from prescription medications and possible obstructive sleep apnea.NTSB DEN08FA162Accident · 1 fatalField investigationFinal reportPilatus PC-12/47E · Santa Fe, NMThe pilot's incapacitation due to fatigue resulting in an in-flight collision with terrain.NTSB SEA08TA188Accident · No injuriesFinal reportHughes 369D · Bonners Ferry, IDThe pilot's inadequate preflight planning for the takeoff and the helicopter loading that exceeded the lift performance capability of the helicopter.NTSB DCA08MA085Accident · 8 fatalClass 1 · MajorFinal reportRaytheon Corporate Jets BAE 125-800A · Owatonna, MNThe captain’s decision to attempt a go-around late in the landing roll with insufficient runway remaining. Contributing to the accident were (1) the pilots’ poor crew coordination and lack of cockpit discipline; (2) fatigue, which likely impaired both pilots’…NTSB ANC08LA085Accident · No injuriesLimited investigationFinal reportCessna 185 · McCarthy, AKThe pilot's improper fuel management which resulted in fuel starvation and a loss of engine power during cruise flight. Contributing to the accident was an aerodynamic stall during the emergency landing, the pilot's fatigue, and his unfamiliarity with the…NTSB NYC08FA184Accident · 2 fatalField investigationFinal reportCessna 337A · West Creek, NJThe pilot's departure with insufficient fuel for the planned flight, and his improper in-flight fuel management, which resulted in a total loss of power in both engines due to fuel starvation. Contributing to the accident was the pilot's fatigue, which was…NTSB LAX08FA144Accident · 2 fatalField investigationFinal reportde Havilland DHC-2 MK I · Stehekin, WAThe pilot's failure to retract the landing gear wheels prior to performing a water landing. Contributing to the accident were the pilot's disabling of the landing gear warning/advisory system and possible fatigue due to his work schedule.NTSB SEA08IA080Incident · No injuriesIncident investigationFinal reportBombardier CL-600 · Hilo, HIThe captain and first officer inadvertently falling asleep during the cruise phase of flight. Contributing to the incident were the captain's undiagnosed obstructive sleep apnea and the flight crew’s recent work schedules, which included several consecutive…