NTSB investigations, 2008
14 cases where the sequence of events included Loss of visual reference.
Cases per year
| 2008 | 14 |
|---|---|
| 2009 | 13 |
| 2010 | 8 |
| 2011 | 13 |
| 2012 | 15 |
| 2013 | 11 |
| 2014 | 10 |
| 2015 | 25 |
| 2016 | 9 |
| 2017 | 27 |
| 2018 | 18 |
| 2019 | 16 |
| 2020 | 6 |
| 2021 | 14 |
| 2022 | 6 |
| 2023 | 18 |
| 2024 | 6 |
| 2025 | 7 |
| 2026 | 6 |
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\") = 2008
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '402' 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") = 2008 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '402' 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 ERA09FA036Accident · 1 fatalField investigationFinal reportRobinson R-44 · Gallatin, TNThe pilot's inadvertent descent into water as a result of the dark night and limited outside visual references.NTSB NYC08LA310Accident · 1 fatalLimited investigationFinal reportDufault Mark V Pitts S-1D · Ridgely, MDThe pilot's inadequate preflight weather evaluation which resulted in an attempted landing in fog and subsequent impact with terrain.NTSB DFW08FA212Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Yuma, COThe pilot's failure to maintain control of the airplane after an encounter with instrument meteorological conditions.NTSB ANC08FA133Accident · 2 fatalField investigationFinal reportCessna 182 · Juneau, AKThe pilot's decision to continue visual flight into an area of instrument meteorological conditions, which resulted in the pilot experiencing a loss of visual reference and subsequent controlled flight into terrain. Contributing to the accident was the…NTSB LAX08FA246Accident · 3 fatalField investigationFinal reportCessna 172N · McMurray, WAThe pilot's improper decision to continue VFR flight into instrument meteorological weather conditions. Contributing to the accident were low ceilings, reduced visibility, and mountainous terrain.NTSB LAX08LA198Accident · Serious injuriesLimited investigationFinal reportEurocopter AS 350 B3 · Ash Fork, AZThe pilot's spatial disorientation resulting in his failure to detect and compensate for an unintentional descent during a go-around. Contributing to the accident were the pilot's inadequate choice of landing approach, reduced visibility from brownout…NTSB NYC08LA223Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Rockland, METhe non-instrument rated pilot becoming spatially disorientated after inadvertently entering instrument flight conditions.NTSB DEN08FA101Accident · 4 fatalField investigationFinal reportBell 407 · Huntsville, TXThe pilot's failure to identify and arrest the helicopter's descent, which resulted in its impact with terrain. Contributing to the accident was the limited outside visual reference due to the dark night conditions.NTSB MIA08FA115Accident · 3 fatalField investigationFinal reportCessna T206H · Cedar Key, FLThe pilot’s failure to maintain clearance from the water during a dark night approach to a coastal airport.NTSB DEN08FA100Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau EA 300/L · Gothenburg, NEThe pilot's failure to maintain aircraft control after encountering instrument meteorological conditions. Contributing to the accident were the pilot's recent usage of Marihuana, his impaired judgement and decision making, and the low visibility weather…NTSB NYC08FA155Accident · 1 fatalField investigationFinal reportSIAI-Marchetti SF-260 · Belfast, METhe pilot's failure to maintain control of the airplane due to spatial disorientation during an aerobatic maneuver.NTSB ANC08LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Koliganek, AKThe pilot's VFR flight into adverse weather conditions that resulted in a collision with snow-covered terrain during a turn to reverse direction. Factors contributing to the accident were low ceilings, flat lighting conditions, and the snow-covered terrain.NTSB ANC08LA042Accident · Minor injuriesLimited investigationFinal reportCessna 180 · White Mountain, AKThe pilot’s inadvertent flight into flat light/whiteout conditions over snow-covered terrain.NTSB DFW08FA057Accident · 1 fatalField investigationFinal reportPiper PA46-500TP · San Antonio, TXThe pilot's failure to execute an instrument approach. Contributing to the accident was the pilot's impairment due to recent use of over-the-counter medication.