NTSB investigations, 2013
30 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\") = 2013
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") = 2013 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 CEN14CA078Accident · No injuriesData collectionFinal reportCessna 152 · Columbia Station, OHThe pilot's inadequate flight planning and decision to land on the soft grass/turf runway which resulted in a nose over.NTSB CEN14LA076Accident · No injuriesLimited investigationFinal reportCessna T210L · Lake Providence, LAThe pilot's mismanagement of available fuel and incorrect use of the fuel boost pump which resulted in a total loss of engine power at a low altitude.NTSB CEN14CA061Accident · No injuriesData collectionFinal reportAviat A 1B · Cypress, TXThe pilot's failure to maintain control during landing which resulted in an impact with the runway surface.NTSB ANC14CA005Accident · No injuriesData collectionFinal reportCessna 172 · Juneau, AKThe pilot's decision to land on an unsuitable surface, which resulted in a nose over.NTSB WPR14CA017Accident · No injuriesData collectionFinal reportBeller Quicksilver Mxlii · Orland, CAThe pilot's failure to maintain aircraft control during taxi with a strong gusting wind condition which resulted in the airplane nosing over.NTSB ANC14CA004Accident · No injuriesData collectionFinal reportPiper J3C 65 · Talkeetna, AKThe pilot's decision to make contact with an unsuitable landing surface, resulting in a nose over.NTSB ERA13FA432Accident · 1 fatalField investigationFinal reportLowerre Bruce T S 12-E · Pahokee, FLUndetermined because the wreckage was not recovered.NTSB ANC13CA101Accident · No injuriesData collectionFinal reportCessna 170B · Iliamna, AKThe pilot's inadvertent encounter with a mound while landing on a remote airstrip.NTSB CEN13CA545Accident · No injuriesData collectionFinal reportSwedener Rans S-6ES · Mullen, NEThe gopher holes and soft terrain the airplane encountered, which resulted in the airplane nosing over.NTSB ERA13CA413Accident · No injuriesData collectionFinal reportLake LA-4 · Monticello, KYAn encounter with a large wave during water taxi, which resulted in the airplane nosing over.NTSB WPR13LA392Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-105 Special · Rancho Palos Verdes, CAA loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA13CA416Accident · No injuriesData collectionFinal reportCessna U206F · Rumney, NHThe pilot's failure to ensure that the amphibious airplane's landing gear was properly configured for a landing on water and his failure to properly configure the airplane during the attempted go-around.NTSB CEN13CA522Accident · No injuriesData collectionFinal reportGreat Lakes 2T-1A-2 · Iowa City, IAThe pilot failed to maintain directional control of the airplane while landing.NTSB ANC13CA069Accident · No injuriesData collectionFinal reportCessna A185E · Kotzebue, AKThe pilot's lack of situational awareness and failure to maintain adequate clearance from terrain during takeoff. Factors contributing to the accident was the check airmen’s inadequate supervision.NTSB ERA13LA329Accident · Serious injuriesLimited investigationFinal reportKrips Jack E JR Kolb MK III · Fowler, NYThe pilot’s improper landing flare, which resulted in a nose-down collision with water.NTSB CEN13CA400Accident · No injuriesData collectionFinal reportCessna 120 · Lakeville, MNThe student pilot's excessive application of the brakes during the landing roll and the flight instructor's delayed remedial action, which resulted in a nose-over.NTSB WPR13CA279Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Cashmere, WAThe pilot’s improper application of the brakes during the landing ground roll, which resulted in a nose over.NTSB ERA13CA298Accident · No injuriesData collectionFinal reportBellanca 7KCAB · East Aurora, NYThe pilot's failure to maintain aircraft control during a rejected takeoff on a soft turf runway with a gusty wind, resulting in the airplane nosing over.NTSB ERA13CA244Accident · No injuriesData collectionFinal reportCessna 170B · Roxboro, NCThe pilot’s excessive use of wheel brakes while turning off the runway after landing resulting in a noseover.NTSB WPR13CA225Accident · No injuriesData collectionFinal reportCessna 172N · Newcastle, WYThe student pilot's failure to attain the proper touchdown point, which resulted in an undershoot of the runway.NTSB CEN13CA266Accident · No injuriesData collectionFinal reportCessna 140 · Glenwood Springs, COThe pilot's failure to maintain airplane control during the landing roll and his excessive use of right brake, which resulted in a noseover.NTSB CEN13CA251Accident · No injuriesData collectionFinal reportAlexander Duane A RV-8 · Cortland, OHThe pilot’s failure to maintain control of the airplane after encountering an unexpected soft spot in the runway during landing.NTSB ANC13CA039Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Seward, AKThe pilot’s decision to land on an unsuitable landing surface, which resulted in a nose over.NTSB WPR13CA207Accident · No injuriesData collectionFinal reportWaco YKS-7 · Rialto, CAThe pilot’s failure to maintain directional control and his improper brake usage during the landing roll in a crosswind condition.NTSB CEN13LA239Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Bowling Green, MOThe failure of the engine supercharger's rear bearing, which resulted in the loss of engine power.NTSB WPR13CA192Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Moose Creek Ranger Station, IDThe pilot's use of excessive braking after landing with a tailwind and after an extended touchdown to avoid deer on the runway.NTSB ANC13CA034Accident · No injuriesData collectionFinal reportPiper PA-16 · Big Lake, AKThe pilot's decision to land on unsuitable terrain.NTSB ERA13LA151Accident · No injuriesLimited investigationFinal reportCessna 150 · Naples, METhe student pilot’s improper decision to land on a frozen lake.NTSB WPR13CA097Accident · No injuriesData collectionFinal reportCessna 140 · Tucson, AZThe pilot’s failure to maintain directional control during the landing roll and his excessive application of brakes, which resulted in a noseover.NTSB WPR13CA088Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Rialto, CAThe pilot's failure to maintain airplane control while taxiing in gusting wind conditions.