NTSB investigations, 2010
21 cases where NTSB found Low ceiling.
Cases per year
| 2008 | 17 |
|---|---|
| 2009 | 20 |
| 2010 | 21 |
| 2011 | 20 |
| 2012 | 13 |
| 2013 | 15 |
| 2014 | 12 |
| 2015 | 7 |
| 2016 | 6 |
| 2017 | 5 |
| 2018 | 7 |
| 2019 | 14 |
| 2020 | 6 |
| 2021 | 6 |
| 2022 | 10 |
| 2023 | 3 |
| 2024 | 6 |
| 2025 | 2 |
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\") = 2010
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03035010'))
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") = 2010 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03035010')) 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 CEN11FA079Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Norfolk, NEThe pilot’s decision to continue the flight into instrumental meteorological conditions which resulted in a collision with a tree.NTSB ERA11LA048Accident · 2 fatalLimited investigationFinal reportBean R E/R B Weld Glasair III · Winchester, TNThe pilot's inadvertent climb and entry into instrument meteorological conditions during a course reversal, which resulted in spatial disorientation and a loss of control.NTSB WPR11FA027Accident · 2 fatalField investigationFinal reportReed Glasair III SH-3R · Lake Mathews, CAThe pilot’s failure to maintain clearance from terrain while maneuvering at low altitude beneath a cloud layer.NTSB ERA10FA503Accident · 1 fatalField investigationFinal reportCessna 150F · Sweetwater, TNThe pilot's inadequate preflight weather planning and improper decision to continue a visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB ERA10FA471Accident · 1 fatalField investigationFinal reportCessna 182T · Helena, GAThe pilot’s continuance of the GPS approach below the minimum descent altitude while landing in instrument meteorological conditions.NTSB WPR10FA438Accident · 1 fatalField investigationFinal reportCessna 182C · Belgrade, MTThe non-instrument rated pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in a loss of airplane control.NTSB ERA10CA436Accident · No injuriesData collectionFinal reportCessna 414 · Bedford, PAThe pilot's failure to establish a proper climb gradient during a departure in instrument meteorological conditions, which resulted in a collision with trees.NTSB ERA10FA403Accident · 2 fatalField investigationFinal reportRobinson Helicopter R44 II · Blairsville, GAThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB CEN10CA452Accident · No injuriesData collectionFinal reportMaule MX-7-180A · Pittsfield, ILThe pilot's loss of directional control during a precautionary off-field landing that he performed after encountering deteriorating weather conditions.NTSB WPR10CA348Accident · No injuriesData collectionFinal reportPiper PA-28-236 · Moreno Valley, CAA total loss of engine power due to fuel exhaustion.NTSB CEN10FA320Accident · 2 fatalField investigationFinal reportBeech A36 · Lidderdale, IAThe pilot's decision to initiate the flight in marginal weather conditions and his loss of aircraft control.NTSB CEN10FA316Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Umpire, ARThe pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation.NTSB WPR10FA273Accident · 2 fatalField investigationFinal reportPiper PA-34-220T · Lincoln, MTThe pilot’s decision to continue flight into an area of low ceilings and low visibility and his failure to maintain sufficient clearance from mountainous terrain.NTSB WPR10FA234Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Livermore, CAThe pilot's continued visual flight into instrument meteorological conditions, which resulted in a collision with obstacles and terrain.NTSB WPR10LA180Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Terry, MTThe pilot's failure to maintain directional control during the landing roll in gusting winds. Contributing to the accident was a loss of engine power on final approach due to fuel exhaustion as a result of the pilot having to divert due to deteriorating…NTSB WPR10FA120Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Phoenix, AZThe student pilot’s decision to take off in marginal visual flight rules conditions, which resulted in an encounter with low clouds, and the pilot's failure to maintain clearance from wires while maneuvering in the traffic pattern for landing.NTSB CEN10FA108Accident · 2 fatalField investigationFinal reportSmith Aerostar 601P · Sugar Grove, ILThe pilot's spatial disorientation and subsequent failure to maintain airplane control.NTSB WPR10LA115Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Joshua Tree, CAThe certified flight instructor's decision to continue visual flight into deteriorating weather, which resulted in his inadvertent encounter with instrument meteorological conditions and subsequent failure to maintain clearance with terrain.NTSB CEN10LA103Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Cedar Rapids, IAThe pilot's failure to maintain aircraft control while flying an instrument approach. Contributing to the accident was the pilot's lack of experience in actual instrument conditions.NTSB CEN10FA101Accident · 2 fatalField investigationFinal reportCessna 172 · Holland, MIThe pilot's decision to take off in known instrument meteorological conditions without instrument currency or recent instrument experience, which led to spatial disorientation resulting in an inadvertent spin. Contributing to the accident was the pilot's lack…NTSB WPR10LA103Accident · 2 fatalLimited investigationFinal reportLarson RV8 · Sequim, WAThe pilot's failure to maintain adequate airspeed while maneuvering in the traffic pattern, which resulted in an aerodynamic stall.