Fatal NTSB investigations, 2013
5 cases where the sequence of events included Preflight or dispatch event.
Cases per year
| 2008 | 10 |
|---|---|
| 2009 | 7 |
| 2010 | 5 |
| 2011 | 8 |
| 2012 | 5 |
| 2013 | 5 |
| 2014 | 8 |
| 2015 | 5 |
| 2016 | 10 |
| 2017 | 7 |
| 2018 | 8 |
| 2019 | 3 |
| 2020 | 2 |
| 2021 | 3 |
| 2023 | 3 |
| 2024 | 1 |
| 2025 | 2 |
| 2026 | 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 year(c.\"eventDate\") = 2013
AND c.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '030' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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") = 2013 AND c."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '030' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA13FA402Accident · 2 fatalField investigationFinal reportCessna T-50 · Lenox Twp., PAThe pilot's intentional visual flight into night instrument meteorological conditions and thunderstorms and his improper decision to takeoff without getting updated weather information after a briefer cautioned him during a previous flight that visual flight…NTSB ERA13FA372Accident · 2 fatalField investigationFinal reportAeronca 7AC · Taunton, MAThe pilot/owner’s inadequate preflight inspection and inadequate pretakeoff check of the flight controls, which resulted in a takeoff with the rudder gust lock installed. Contributing to the accident was the pilot-rated passenger’s failure to detect that the…NTSB DCA13MA121Accident · 10 fatalMajor investigationFinal reportDehavilland DHC-3 · Soldotna, AKThe operator's failure to determine the actual cargo weight, leading to the loading and operation of the airplane outside of the weight and center of gravity limits contained in the airplane flight manual, which resulted in an aerodynamic stall. Contributing…NTSB ERA13FA259Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Linden, NJThe flight instructor's inadequate preflight planning and his decision to take off with the airplane at a high gross weight in high temperature conditions that degraded the engine’s available power and his subsequent failure to maintain airspeed while…NTSB CEN13FA214Accident · 1 fatalField investigationFinal reportCessna 152 · Hawley, MNThe noninstrument-rated pilot’s improper decision to conduct a flight into known instrument meteorological conditions, which resulted in a loss of control.