NTSB investigations, 2015
7 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\") = 2015
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") = 2015 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 GAA16CA066Accident · No injuriesData collectionFinal reportGrumman American Avn. AA 5 · West Point, VAThe pilot's decision to fly a traffic pattern following an aborted instrument landing in night instrument metrological conditions, which resulted in a loss of visual reference to the runway, an inadvertent aerodynamic stall, and a collision with terrain.NTSB ERA15FA361Accident · 1 fatalField investigationFinal reportCessna U206 · Spring Hill, FLThe pilot's failure to maintain a stabilized instrument approach, which resulted in a loss of control.NTSB ERA15FA326Accident · 1 fatalField investigationFinal reportPiper PA44 · Houlton, METhe pilot's descent below the published minimum descent altitude in night instrument meteorological conditions without visual contact with the runway environment, which resulted in a collision with trees and terrain short of the runway. Contributing to the…NTSB ERA15FA254Accident · 3 fatalField investigationFinal reportBeech A36 · Plainville, MAThe total loss of engine power due to the failure of the alternator drive coupling. Contributing to the accident was the pilot's inability to locate and navigate to a suitable forced landing site due to low cloud ceilings.NTSB CEN15FA174Accident · 1 fatalField investigationFinal reportCessna 182Q · El Paso, TXThe pilot's decision to continue a visual flight rules flight into known instrument flight rules conditions, which resulted in controlled flight into terrain.NTSB ERA15FA144Accident · 3 fatalField investigationFinal reportMooney M20F · Norfolk, VAThe pilot's failure to properly execute the instrument approach procedure. Contributing to the accident were the pilot's improper preflight planning and his decision to conduct the flight in instrument meteorological conditions at night into forecast moderate…NTSB WPR15FA072Accident · 2 fatalField investigationFinal reportBell 206 · Benson, AZThe pilot’s continued visual flight into instrument meteorological conditions which resulted in an inflight collision with terrain. Contributing to the accident was the pilot’s inadequate preflight planning, during which he failed to identify forecasted…