NTSB investigations, 2009
136 cases where the sequence of events included Nose over/nose down.
Cases per year
| 2008 | 120 |
|---|---|
| 2009 | 136 |
| 2010 | 138 |
| 2011 | 133 |
| 2012 | 129 |
| 2013 | 124 |
| 2014 | 122 |
| 2015 | 127 |
| 2016 | 174 |
| 2017 | 166 |
| 2018 | 141 |
| 2019 | 138 |
| 2020 | 97 |
| 2021 | 93 |
| 2022 | 74 |
| 2023 | 116 |
| 2024 | 100 |
| 2025 | 86 |
| 2026 | 76 |
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '096' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '096' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 WPR10CA096Accident · No injuriesData collectionFinal reportStinson SR-8B · Auburn, WAThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN10CA077Accident · No injuriesData collectionFinal reportCessna 172P · Ames, IAThe pilot's failure to maintain directional control while attempting a takeoff on an ice-covered runway.NTSB WPR10CA073Accident · No injuriesData collectionFinal reportCessna 172M · Diamond Point, WAThe pilot's inadequate compensation for the variable and unfavorable wind conditions.NTSB CEN10CA067Accident · No injuriesData collectionFinal reportCessna 182 · Carmi, ILA total loss of engine power due to fuel starvation as a result of the pilot's failure to assure that the fuel tank filler cap was secured prior to flight.NTSB WPR10CA071Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Stockton, CAThe pilot’s inadequate compensation for a crosswind condition.NTSB WPR10CA062Accident · No injuriesData collectionFinal reportCessna 172 · Yucca Valley, CAThe pilot's inadequate compensation for the crosswind gusts and failure to maintain directional control of the airplane.NTSB ERA10CA067Accident · No injuriesData collectionFinal reportRobert Wood Thorp T18 · Newburgh, NYThe pilot's failure to maintain directional control during the landing rollout.NTSB ERA10LA063Accident · Minor injuriesLimited investigationFinal reportCurtiss Wright Travel AIR · Fort Myers, FLThe pilot's improper recovery from a bounced landing and failure to maintain directional control, which resulted in a ground loop. Contributing to the accident was the pilot's minimal experience in the airplane make and model.NTSB ANC10CA008Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's decision to land and attempt to takeoff from an unsuitable off-airport site.NTSB ERA10CA049Accident · Minor injuriesData collectionFinal reportErcoupe 415 · Germantown, NYThe pilot's decision to continue operation of the airplane with a known mechanical deficiency.NTSB WPR10CA043Accident · Minor injuriesData collectionFinal reportCessna 120 · Mineral Canyon, UTThe pilot's incorrect use of brakes, which resulted in the airplane nosing over.NTSB ANC10CA009Accident · No injuriesData collectionFinal reportCessna 182C · Kotzebue, AKThe pilot's failure to maintain directional control and his selection of unsuitable terrain for takeoff.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 WPR10CA084Accident · No injuriesData collectionFinal reportGolden Circle Tierra I · Jensen, UTA loss of engine power, as reported by the pilot, for undetermined reasons.NTSB WPR10CA031Accident · No injuriesData collectionFinal reportPiper J4 · El Cajon, CAThe left-seat pilot's failure to maintain directional control during the landing roll.NTSB ANC09CA107Accident · No injuriesData collectionFinal reportPiper PA-20 · Fairbanks, AKThe student pilot's decision to attempt an off-airport landing and his failure to maintain directional control during the landing roll.NTSB ANC09CA108Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Fairbanks, AKThe pilot's failure to maintain control of the airplane during the landing roll at an off-airport site.NTSB ANC09CA105Accident · No injuriesData collectionFinal reportPiper PA-22 · Seward, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in a loss of control and a nose over during the takeoff roll.NTSB WPR09LA454Accident · Minor injuriesLimited investigationFinal reportLewis Jennings Nieuport 11 · Pahrump, NVA total loss of engine power during cruise flight due to a failure of the engine's sole magneto.NTSB WPR09CA456Accident · No injuriesData collectionFinal reportAviat A-1C · McArthur, CAThe pilot's failure to maintain aircraft control during landing due to animals unexpectedly running onto the runway.NTSB CEN09CA592Accident · No injuriesData collectionFinal reportBordelon Kitfox IV · Dodge Center, MNThe pilot's improper glide path during landing.NTSB ANC09CA101Accident · No injuriesData collectionFinal reportPiper PA-18-180 · Tok, AKThe pilot's selection of an unsuitable landing/takeoff area, resulting in a runway excursion and a nose over during takeoff.NTSB ANC09LA102Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Lime Village, AKThe passenger's inadvertent interference with, and application of the right brake pedal during takeoff.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 ERA09LA517Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hillsville, VAThe total loss of engine power for an undetermined reason.NTSB WPR09LA446Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. AA-1B · Creswell, ORA partial loss of engine power due to the malfunction of the engine's right magneto.NTSB ANC09CA097Accident · No injuriesData collectionFinal reportCessna 180J · Juneau, AKThe pilot's misjudged flare and loss of control during a glassy water landing.NTSB CEN09LA567Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Marshall, MIThe failure of the main landing gear attach point.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 CEN09CA552Accident · No injuriesData collectionFinal reportCessna 150F · Abilene, KSThe pilot's inadequate crosswind landing technique, resulting in an excessive side load on the left landing gear that led to an overload failure of its axle.NTSB WPR09LA423Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Ballard, WAThe pilot's precautionary water landing with partially extended landing gear. Contributing to the accident was the unidentified anomaly with the airplane's electrical system, which rendered the gear position indicator system inoperative.NTSB WPR09CA424Accident · Minor injuriesData collectionFinal reportSilvaire Luscombe 8A · Sandy, ORThe pilot's decision to continue the landing rather than execute a go-around. Contributing to the accident was the pilot's failure to maintain proper airspeed and altitude during the approach.NTSB CEN09CA545Accident · Minor injuriesData collectionFinal reportDekkinga Vans RV-7A · Jenison, MIThe pilot's failure to maintain aircraft control during the landing.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 WPR09CA415Accident · No injuriesData collectionFinal reportPaul B. Johnson Avid Mark IV · Nampa, IDThe airplane's encounter with tall vegetation that ensnared the landing gear during an off-field precautionary landing.NTSB ERA09LA473Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctsw · Okeechobee, FLA total loss of engine power during initial climb for undetermined reasons.NTSB ANC09CA085Accident · No injuriesData collectionFinal reportCessna 140 · Fairbanks, AKThe pilot's failure to achieve a proper touchdown point, resulting in an overrun and a nose over.NTSB CEN09CA530Accident · No injuriesData collectionFinal reportCessna 172 · Centennial, COThe pilot's failure to maintain directional control of the airplane during the landing flare in crosswind conditions.NTSB ANC09LA083Accident · No injuriesLimited investigationFinal reportCessna 185 · McCarthy, AKThe separation of the right main landing gear wheel from the airplane during landing for undetermined reasons, which resulted in an inability to control the airplane.NTSB ERA09CA463Accident · No injuriesData collectionFinal reportAmerican Legend AL3C · Warrenton, VAThe pilot's improper application of brakes during the landing rollout.NTSB WPR09LA396Accident · Minor injuriesLimited investigationFinal reportBeech A60 · Minidoka, IDA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB ERA09CA462Accident · No injuriesData collectionFinal reportUnknown Sabre-Trike · Crandall, GAA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel management.NTSB CEN09CA516Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Harlan, IAThe pilot's failure to perform accurate weight and balance calculations which resulted in exceeding the maximum takeoff weight and the airplane's climb capability.NTSB WPR09CA394Accident · Minor injuriesData collectionFinal reportPiper PA-12 · Sisters, ORThe pilot's failure to maintain directional control during the landing roll.NTSB ERA09LA457Accident · Serious injuriesLimited investigationFinal reportTidd Wesley Mini-Max · Hodgdon, METhe pilot's mismanagement of the fuel supply, which resulted in fuel starvation.NTSB CEN09LA501Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Oklahoma City, OKA total loss of engine power due to fuel exhaustion as a result of the pilot’s improper fuel planning.NTSB CEN09LA490Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Whitney, TXA partial loss of engine power for undetermined reasons.NTSB CEN09CA489Accident · Minor injuriesData collectionFinal reportCessna 182P · Gateway, COThe pilot's inability to maintain directional control due to soft runway conditions.NTSB ANC09CA076Accident · No injuriesData collectionFinal reportPiper PA-18 · Skwentna, AKThe pilot’s misjudged landing on a downsloping, short landing strip, resulting in a nose over.