NTSB investigations, 2011
20 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
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\") = 2011
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") = 2011 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 CEN12FA101Accident · 2 fatalField investigationFinal reportPiper PA-28-235D · Chickasha, OKThe non-instrument-rated pilot's decision to continue flight into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control of the airplane. Contributing to the accident was the pilot’s lack of instrument…NTSB CEN12FA090Accident · 2 fatalField investigationFinal reportCessna 182R · Mescalero, NMThe pilot's intentional attempt to fly into adverse weather, which resulted in an in-flight loss of control. Contributing to the accident was the pilot's lack of instrument experience.NTSB CEN12FA080Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Bern, WIThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in a loss of control and subsequent impact with the terrain.NTSB WPR12FA044Accident · 1 fatalField investigationFinal reportMooney M20M · Pomona, CAThe pilot’s failure to maintain sufficient altitude to clear obstructions while maneuvering on the base leg of the traffic pattern for landing.NTSB WPR12MA034Accident · 5 fatalMajor investigationFinal reportEurocopter EC 130 B4 · Pukoo, HIThe pilot's failure to maintain clearance from mountainous terrain while operating in marginal weather conditions, which resulted in the impact of the horizontal stabilizer and lower forward portion of the fenestron with ground and/or vegetation and led to…NTSB CEN12LA053Accident · Minor injuriesLimited investigationFinal reportEurocopter EC 130 B4 · Noblesville, INThe hard landing the pilot performed with a quartering tailwind, leading to the helicopter's rollover. Contributing to the accident was the pilot’s reliance on a weather service that did not provide a primary weather product.NTSB CEN11FA666Accident · 2 fatalField investigationFinal reportRobinson Helicopter R44 · Curren, MIThe non-instrument-rated pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in controlled flight into trees and the ground. Contributing to the accident was the pilot's impairment from multiple drugs.NTSB CEN11FA629Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · West Liberty, OHThe pilot’s improper decision to fly aerobatic maneuvers at low altitude, which resulted in a loss of control and impact with terrain. Contributing to the accident was the pilot’s impairment due to his recent use of multiple impairing drugs.NTSB ERA11FA422Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Berne, NYThe pilot's continued visual flight into instrument meteorological conditions, which resulted in a collision with trees and rising terrain while attempting to reverse course. Contributing to the accident was the pilot's failure to obtain a preflight weather…NTSB ANC11FA069Accident · 2 fatalField investigationFinal reportCessna 182P · Juneau, AKThe pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain. Contributing to the accident was the pilot's self-induced pressure to reach his destination.NTSB CEN11FA468Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Rising Sun, INThe noninstrument-rated pilot's decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in his spatial disorientation and failure to maintain clearance from terrain.NTSB WPR11FA319Accident · 2 fatalField investigationFinal reportPiper PA-22-135 · Verlot, WAThe non-instrument rated pilot’s decision to continue visual flight into clouds and his failure to maintain clearance from terrain while maneuvering in an area of reduced visibility, low clouds, and mountain obscuration.NTSB CEN11FA417Accident · 2 fatalField investigationFinal reportBeech A36 · Charlevoix, MIThe pilot's inadequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to not execute a missed approach in weather conditions below minimums.NTSB CEN11FA401Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Columbus, OHThe pilot's spatial disorientation during the takeoff into instrument meteorological conditions, which resulted in his failure to maintain control of the airplane.NTSB WPR11FA221Accident · 1 fatalField investigationFinal reportAir Tractor AT-802A · Miles City, MTThe pilot's continued visual flight rules flight into deteriorating weather conditions in an airplane not equipped for instrument flight, which resulted in a collision with terrain.NTSB ERA11FA258Accident · 1 fatalField investigationFinal reportCessna 210D · Altavista, VAThe pilot’s loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s lack of experience in actual night instrument conditions.NTSB ERA11FA232Accident · 3 fatalField investigationFinal reportCessna 310R · McComb, MSThe pilot's impairment due to alcohol ingestion and his failure to maintain airplane control during an approach at night in instrument meteorological conditions.NTSB WPR11FA182Accident · 1 fatalField investigationFinal reportPiper PA-28RT · Cherry Valley, CAThe pilot’s continued flight in an area of low ceiling and visibility, which resulted in a collision with mountainous/hilly terrain.NTSB ERA11FA218Accident · 2 fatalField investigationFinal reportCessna 310R · Pikeville, KYThe pilot's flight below the published minimum descent altitude in instrument meteorological conditions, which resulted in a collision with trees and the ground. Contributing to the accident was the pilot's use of nighttime cold medication at doses above…NTSB ERA11FA107Accident · 1 fatalField investigationFinal reportBeech 58P · Birmingham, ALThe pilot's failure to maintain control of the airplane during an instrument approach due to spatial disorientation.