NTSB investigations, 2010
138 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\") = 2010
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") = 2010 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 ERA11LA105Accident · No injuriesLimited investigationFinal reportCessna 172 · Dublin, NCThe pilot’s improper touchdown speed which resulted in a runway overrun. Contributing to the accident was the undetermined malfunction of the airspeed indicator.NTSB ERA11CA170Accident · No injuriesData collectionFinal reportCessna 195 · Williamson, GAThe pilot's inadvertent application of the brakes during a bounced landing resulting in a nose over.NTSB ERA11CA097Accident · No injuriesData collectionFinal reportCessna 140 · Winnsboro, SCThe excessive brake inputs by both pilots during the landing roll resulting in the airplane nosing over.NTSB CEN11CA127Accident · No injuriesData collectionFinal reportCessna 182P · Clifton, TXThe pilot's inadequate compensation for the crosswind and inadequate flare, which resulted in a hard landing.NTSB CEN11LA109Accident · Minor injuriesLimited investigationFinal reportCessna T182T · Moline, ILThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and noseover.NTSB WPR11LA070Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Corona, CAThe total loss of engine power due to oil exhaustion as a result of a broken oil line.NTSB WPR11CA065Accident · No injuriesData collectionFinal reportAviat A-1B · North Bend, WAThe pilot's failure to predetermine the depth of the snow on the runway.NTSB WPR11LA062Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Suisun City, CAA total loss of engine power for undetermined reasons.NTSB WPR11CA057Accident · Minor injuriesData collectionFinal reportFlight Design Ctsw · Fullerton, CAThe pilot's improper flare during landing.NTSB WPR11FA054Accident · 3 fatalField investigationFinal reportBeech 19A · Newport Beach, CAThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN11LA069Accident · No injuriesLimited investigationFinal reportCessna 172R · Farmersburg, INA total loss of engine power for undetermined reasons.NTSB CEN11CA060Accident · Minor injuriesData collectionFinal reportPiper PA-22-160 · Watertown, SDThe pilot's inadvertent and premature use of the brakes during the landing roll, which resulted in a nose-over.NTSB ERA11CA053Accident · No injuriesData collectionFinal reportLuscombe 8A · Hot Springs, VAThe pilot's inadequate compensation for the crosswind during landing.NTSB CEN11CA056Accident · Minor injuriesData collectionFinal reportCessna 150H · Kenmare, NDThe pilot's inadequate landing flare and recovery from a bounced landing.NTSB WPR11CA034Accident · No injuriesData collectionFinal reportCessna U206B · Cascade, IDThe pilot's failure to maintain clearance from terrain during a turn onto the final approach leg of the traffic pattern.NTSB WPR11CA030Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Pahrump, NVThe pilot's inadvertent activation of brakes upon touchdown, resulting in a loss of directional control.NTSB ERA11CA034Accident · Minor injuriesData collectionFinal reportBoeing A75 · Douglas, GAA nose-over due to excessive brake application.NTSB CEN11CA038Accident · No injuriesData collectionFinal reportCessna 182L · Mancelona, MIA loss of engine power in flight due to the failure of the engine's No. 5 piston.NTSB CEN11CA031Accident · No injuriesData collectionFinal reportBeech A36 · Pagosa Springs, COThe pilot's improper flare, which resulted in a hard landing.NTSB ERA11LA015Accident · No injuriesLimited investigationFinal reportCessna 172SP · Boynton Beach, FLThe loss of engine power for undetermined reasons.NTSB WPR11CA007Accident · No injuriesData collectionFinal reportPiper PA-12 · Valley, WAThe pilot's excessive brake application during the landing roll after overshooting the intended touchdown point, resulting in a nose over.NTSB ANC11CA002Accident · No injuriesData collectionFinal reportCessna 170B · Minto Flats, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in a loss of control.NTSB ANC10LA101Accident · No injuriesLimited investigationFinal reportCessna 150F · North Pole, AKThe overstress separation of the left nose wheel steering linkage rod end during the takeoff roll, which resulted in a loss of control.NTSB ANC10CA099Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Kenai, AKThe student pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power during cruise flight.NTSB ANC10CA098Accident · No injuriesData collectionFinal reportCessna 180C · Anchorage, AKThe pilot's failure to compensate for the gusting wind during takeoff, which resulted in a loss of control and impact with water.NTSB CEN10LA551Accident · Minor injuriesLimited investigationFinal reportMccauley Gene E RV-6A · Kokomo, INCollapse of the nose landing gear during landing rollout on an unpaved runway due to a loss of ground clearance with the landing gear fork, causing the airplane to nose over.NTSB ANC10CA095Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Coal Creek, AKThe pilot's improper recovery from a bounced landing.NTSB ANC10CA092Accident · Minor injuriesData collectionFinal reportPiper J5A · Chickaloon, AKThe pilot's excessive use of brakes during a rejected takeoff, resulting in a nose over.NTSB ANC10CA088Accident · No injuriesData collectionFinal reportPiper PA-18-160 · Arctic Village, AKThe pilot's failure to maintain control of the airplane during an off-airport landing.NTSB ERA10LA466Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Virginia Beach, VAA total loss of power due to water contamination in the fuel. Contributing to the accident was the pilot's inadequate preflight inspection.NTSB WPR10LA445Accident · Serious injuriesLimited investigationFinal reportMorehead KR-2 · Rancho Murieta, CAThe pilot’s improper flare and recovery from a bounced landing.NTSB CEN10CA517Accident · Minor injuriesData collectionFinal reportBeech D35 · Guymon, OKThe loss of engine power for undetermined reasons.NTSB ANC10TA080Accident · No injuriesFinal reportAviat A-1B · Bettles Field, AKThe pilot's selection of an unsuitable off-airport landing site for a precautionary landing.NTSB CEN10CA504Accident · Minor injuriesData collectionFinal reportRauch RV-3 · Newark, OHThe pilot’s failure to attain the proper touchdown point, resulting in an undershoot.NTSB ERA10LA504Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Mocksville, NCThe pilot’s failure to attain the proper touchdown point, following a loss of engine power due to carburetor icing.NTSB ERA10CA448Accident · No injuriesData collectionFinal reportCessna 182E · Edenton, NCThe pilot's inadequate compensation for crosswind conditions while landing, which resulted in a loss of directional control.NTSB ANC10CA077Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Wasilla, AKThe pilot's failure to maintain directional control during landing, resulting in a runway excursion and nose over.NTSB WPR10LA426Accident · No injuriesLimited investigationFinal reportGrob-Werke G 120A · Buckeye, AZThe student pilot's improper flare, which resulted in a hard landing.NTSB WPR10LA421Accident · No injuriesLimited investigationFinal reportCessna U206 · Grangeville, IDThe pilot’s decision to fly with a known defective nosewheel assembly, which resulted in a loss of directional control and nose-over on landing after the assembly shifted out of alignment during the flight.NTSB ERA10LA439Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tunkhannock, PAA total loss of engine power during the initial climb due to the pilots' inadequate in-flight fuel management.NTSB ERA10LA434Accident · No injuriesLimited investigationFinal reportCessna 152 · Hollywood, FLA loss of engine power for undetermined reasons.NTSB WPR10LA412Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Manson, WAA loss of engine power due to fuel exhaustion, and the pilot’s failure to ensure that a sufficient quantity of fuel was on board to complete the flight.NTSB WPR10CA414Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Buena, WAThe pilot’s excessive brake application, resulting in a nose over.NTSB ANC10LA074Accident · No injuriesLimited investigationFinal reportCessna U206G · Homer, AKThe loss of engine power for an undetermined reason, resulting in an off-airport emergency landing and subsequent nose over.NTSB WPR10LA407Accident · 1 fatalLimited investigationFinal reportClark RV-6A · Nampa, IDThe pilot's failure to maintain aircraft control, which resulted in a collision with terrain during a rejected inadvertent takeoff.NTSB CEN10CA481Accident · Serious injuriesData collectionFinal reportOliver A Bruce RV6-A · Trenton, MOThe canopy opening shortly after takeoff due to an inadequate repair and subsequent failure of the canopy latch, resulting in a emergency landing. Contributing to the accident was the lack of available runway remaining for the forced landing.NTSB WPR10CA405Accident · No injuriesData collectionFinal reportCessna T182T · McCall, IDThe pilot's delay in making the decision to abort the takeoff. Contributing to the accident was the condition of the takeoff surface, and the high density altitude.NTSB WPR10CA404Accident · Minor injuriesData collectionFinal reportCarr Bryan Vans RV-6A · Grass Valley, CAThe pilot’s failure to attain a proper touchdown point that resulted in an overrun of the runway and nose over.NTSB WPR10CA403Accident · Minor injuriesData collectionFinal reportAir Creation Clipper 582S · Petaluma, CAThe pilot’s improper flare, resulting in a hard landing and nose over.NTSB WPR10CA400Accident · Minor injuriesData collectionFinal reportBeech C23 · Wenden, AZThe pilot’s inadequate bounced landing recovery and failure to maintain directional control during landing.