NTSB investigations, 2012
15 cases where NTSB found Runway/land/takeoff/taxi surface, general.
Cases per year
| 2008 | 68 |
|---|---|
| 2009 | 19 |
| 2010 | 14 |
| 2011 | 21 |
| 2012 | 15 |
| 2013 | 12 |
| 2014 | 9 |
| 2015 | 8 |
| 2016 | 13 |
| 2017 | 18 |
| 2018 | 8 |
| 2019 | 5 |
| 2020 | 8 |
| 2021 | 11 |
| 2022 | 8 |
| 2023 | 5 |
| 2024 | 5 |
| 2025 | 5 |
| 2026 | 1 |
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\") = 2012
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03023000'))
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") = 2012 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03023000')) 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 WPR13TA081Accident · No injuriesFinal reportBell Helicopter Textron Canada 407 · Renton, WAThe pilot's failure to maintain helicopter control during takeoff from an unstable landing platform. Contributing to the accident was the operator's inadequate chocking procedures for the wheeled landing platform, which included chocking only two of the…NTSB WPR13CA027Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Hanapepe, HIThe pilot's selection of an unsuitable landing area. Contributing to the pilot’s decision to land in an unsuitable landing area was his lack of helicopter experience, which led him to misidentify the precursor event.NTSB CEN13CA033Accident · Serious injuriesData collectionFinal reportPorter James Grant Superior CUB · Beechgrove, INThe pilot’s failure to maintain clearance from trees during takeoff from a short field.NTSB ANC12CA099Accident · No injuriesData collectionFinal reportCessna 180 · Kenai, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over.NTSB ANC12CA109Accident · No injuriesData collectionFinal reportPiper PA-18 · Healy, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in an aborted takeoff and collision with terrain.NTSB ANC12CA089Accident · No injuriesData collectionFinal reportMaule M-5-210C · Coldfoot, AKThe pilot's delayed decision to turn around while flying through a narrow mountain pass, which resulted in a forced landing and impact with terrain.NTSB CEN12LA507Accident · No injuriesLimited investigationFinal reportCessna 150M · Cottage Grove, WIThe pilot's decision to land on a runway with significant overgrown vegetation along the edges and his landing, which was left of the centerline.NTSB WPR12CA319Accident · No injuriesData collectionFinal reportDornier DO 27 B5 · Jackson Hole, WYThe pilot's selection of unsuitable terrain for landing, resulting in the collapse of the main landing gear.NTSB ANC12CA077Accident · No injuriesData collectionFinal reportBell 206L-3 · Circle, AKThe pilot's selection of unsuitable terrain for landing.NTSB ANC12CA069Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Skwentna, AKThe pilot's selection of an unsuitable off-airport landing site, which resulted in a loss of control during the landing roll.NTSB ANC12LA061Accident · No injuriesLimited investigationFinal reportDehavilland Beaver DHC-2 MK.1 · Bettles, AKThe pilot’s failure to properly judge the airplane’s distance and altitude from the landing location during the final approach, which resulted in an undershoot and a nose over.NTSB ANC12LA056Accident · Serious injuriesLimited investigationFinal reportHelio H-295-1400 · Deadhorse, AKThe pilot's failure to extend the airplane’s wing flaps before takeoff and her selection of an unsuitable takeoff area, which resulted in a collision with a concrete loading ramp during the aborted takeoff.NTSB WPR12CA270Accident · No injuriesData collectionFinal reportFisher Harold R 320 · Adelanto, CAThe pilot's failure to maintain clearance from a fence during takeoff initial climb. Contributing to the accident was the pilot's decision to not use all of the runway distance available for takeoff and the high density altitude.NTSB ANC12CA049Accident · No injuriesData collectionFinal reportCessna U206G · Homer, AKThe pilot's selection of unsuitable terrain for landing.NTSB ERA12LA343Accident · No injuriesLimited investigationFinal reportCessna 195A · Tipton, PAA fatigue failure of a copper oil line, which resulted in a partial loss of engine power due to oil starvation.