NTSB investigations, 2012
19 cases where the defining event was Nose over/nose down.
Cases per year
| 2008 | 19 |
|---|---|
| 2009 | 19 |
| 2010 | 24 |
| 2011 | 48 |
| 2012 | 19 |
| 2013 | 30 |
| 2014 | 25 |
| 2015 | 24 |
| 2016 | 18 |
| 2017 | 16 |
| 2018 | 20 |
| 2019 | 35 |
| 2020 | 21 |
| 2021 | 26 |
| 2022 | 22 |
| 2023 | 31 |
| 2024 | 15 |
| 2025 | 25 |
| 2026 | 33 |
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\") = 2012
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '096')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '096') 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 CEN13CA042Accident · Minor injuriesData collectionFinal reportLuscombe 8E · West Bend, WIThe pilot‘s failure to maintain clearance from power lines at the end of the short runway, which resulted in an aborted takeoff and subsequent nose-over of the airplane.NTSB CEN13CA037Accident · No injuriesData collectionFinal reportBates Starduster SA-300 · Reklaw, TXThe pilot’s improper recovery from a bounced landing, which resulted in a noseover.NTSB ANC12CA099Accident · No injuriesData collectionFinal reportCessna 180 · Kenai, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over.NTSB ANC12CA094Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Delta Junction, AKThe pilot’s failure to identify the appropriate touchdown point, which resulted in a nose over.NTSB WPR12CA363Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8E · Hillsboro, ORThe pilot’s improper use of the brakes during the landing roll, which resulted in a nose over.NTSB CEN12LA556Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Sidney, NEThe pilot's misuse of the brakes during landing, which resulted in the airplane nosing over.NTSB WPR12CA353Accident · No injuriesData collectionFinal reportCessna 182 · Joseph, ORThe pilot’s excessive use of brakes during the landing roll in a gusting crosswind, which resulted in a noseover.NTSB ANC12CA078Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Talkeetna, AKThe flight instructor's and student pilot's excessive application of brakes during an aborted takeoff, which resulted in a noseover.NTSB ANC12CA071Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Fairbanks, AKThe pilot's excessive use of brakes during landing, which resulted in a noseover.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 CEN12CA394Accident · Minor injuriesData collectionFinal reportBoeing B75N1 · Fredricksburg, TXThe pilot's excessive brake application, leading to a noseover during the landing. Contributing to the accident was the pilot’s delay in lowering the tail after landing.NTSB ANC12CA044Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8F · Tok, AKThe pilot's inadvertent and excessive application of brake pressure during landing, which resulted in a nose over.NTSB ERA12CA339Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Gulf Shores, ALThe pilot's inadvertent application of the wheel brakes immediately after landing, which resulted in the airplane nosing over.NTSB ERA12CA278Accident · Minor injuriesData collectionFinal reportPiper PA-18A · West Palm Beach, FLThe inadequate assembly of the brakes, which caused them to lock during the landing roll when the airplane transitioned from asphalt to turf, resulting in the airplane nosing over.NTSB CEN12LA209Accident · 1 fatalLimited investigationFinal reportWalling Vans RV-3 · Larchwood, IAThe pilot's failure to maintain directional control of the airplane after landing.NTSB CEN12CA207Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Crowley, LAThe student pilot's improper landing flare, which resulted in a nose-over.NTSB WPR12CA148Accident · No injuriesData collectionFinal reportStinson 108-1 · Coolin, IDThe pilot’s decision to land on a snow-covered runway.NTSB ANC12CA023Accident · No injuriesData collectionFinal reportCessna 182A · Anchorage, AKThe pilot's inadvertent landing on a frozen lake in dark night conditions.NTSB ANC12CA020Accident · No injuriesData collectionFinal reportHelio H-295 · Old Minto, AKThe pilot's decision to land on unsuitable terrain, which resulted in the airplane nosing over.