NTSB investigations, 2009
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\") = 2009
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") = 2009 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 WPR10CA071Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Stockton, CAThe pilot’s inadequate compensation for a crosswind condition.NTSB WPR10CA043Accident · Minor injuriesData collectionFinal reportCessna 120 · Mineral Canyon, UTThe pilot's incorrect use of brakes, which resulted in the airplane nosing over.NTSB CEN10LA032Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Walsh, COA partial loss of engine power due to failure of the No. 2 cylinder as a result of the failure of the repair facility to properly torque the lower four nuts on the cylinder.NTSB ANC09CA099Accident · No injuriesData collectionFinal reportPiper PA-18 · Chickaloon, AKThe pilot's decision to land on unsuitable terrain, which resulted in a nose-over on landing.NTSB ANC09TA092Accident · No injuriesFinal reportAviat A-1B · Gulkana, AKThe pilot's excessive use of brakes during an off-airport landing, resulting in the airplane nosing over.NTSB ANC09TA090Accident · No injuriesFinal reportPiper PA-18-150 · Bethel, AKThe pilot's excessive use of brakes while landing at an off-airport site.NTSB ANC09CA087Accident · No injuriesData collectionFinal reportPiper PA-12 · Dillingham, AKThe pilot's decision to land on unsuitable soft, wet terrain, which resulted in a nose-over on landing.NTSB ERA09CA463Accident · No injuriesData collectionFinal reportAmerican Legend AL3C · Warrenton, VAThe pilot's improper application of brakes during the landing rollout.NTSB ANC09CA059Accident · No injuriesData collectionFinal reportCessna 170A · Kasigluk, AKThe student pilot's failure to maintain directional control during the landing roll in a crosswind.NTSB WPR09CA295Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Dixie, IDThe pilot's excessive braking during the landing roll.NTSB ERA09CA334Accident · No injuriesData collectionFinal reportPiper J3C-65 · Alamana, FLThe pilot's selection of unsuitable terrain for landing.NTSB CEN09CA326Accident · Minor injuriesData collectionFinal reportAeropro CZ Eurofox · Bloomfield, INThe pilot's selection of an unsuitable landing area.NTSB WPR09CA260Accident · No injuriesData collectionFinal reportStinson SR-8B · Tacoma, WAThe application of unintended braking input due to the pilot's failure to keep his feet correctly positioned on the rudder pedals during the landing roll.NTSB ANC09CA037Accident · No injuriesData collectionFinal reportCessna 140 · Haines, AKThe pilot's decision to practice takeoff and landings on unsuitable terrain, which resulted in a nose-over on takeoff.NTSB ERA09CA254Accident · Minor injuriesData collectionFinal reportAmerican Longevity Searey · Littleton, NCThe pilot's failure to ensure the landing gear was properly configured for the water landing.NTSB WPR09CA199Accident · No injuriesData collectionFinal reportCessna A185F · Bisbee, AZThe flight instructor's inadequate supervision of the flight and inadequate recovery from a bounced landing.NTSB ERA09LA244Accident · No injuriesLimited investigationFinal reportDe Havilland DHC2 · Plattsburgh, NYThe pilot's improper application of brakes during the landing rollout.NTSB CEN09LA231Accident · No injuriesLimited investigationFinal reportCessna R172K · Hazen, NDThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB WPR09CA078Accident · Minor injuriesData collectionFinal reportCessna 150L · Pescadero, CAThe pilot's inadequate preflight fuel planning and preparation. Contributing to the accident was the lack of a suitable area for a forced landing.