NTSB investigations, 2010
24 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\") = 2010
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") = 2010 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 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 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 WPR11CA065Accident · No injuriesData collectionFinal reportAviat A-1B · North Bend, WAThe pilot's failure to predetermine the depth of the snow on the runway.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 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 ERA11CA034Accident · Minor injuriesData collectionFinal reportBoeing A75 · Douglas, GAA nose-over due to excessive brake application.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 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 ANC10CA092Accident · Minor injuriesData collectionFinal reportPiper J5A · Chickaloon, AKThe pilot's excessive use of brakes during a rejected takeoff, resulting in a nose over.NTSB WPR10CA414Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Buena, WAThe pilot’s excessive brake application, resulting in a nose over.NTSB WPR10CA428Accident · No injuriesData collectionFinal reportHolmgreen John B RV8A · Carlsbad, CAThe pilot’s inadequate pretakeoff checks and failure to maintain control during the takeoff roll. Contributing to the accident was the pilot’s diverted attention due to the open canopy.NTSB CEN10CA439Accident · No injuriesData collectionFinal reportBeers Tailwind 10 · Delta, COA loss of control on the ground due to a malfunction of the right brake caliper.NTSB ANC10CA059Accident · No injuriesData collectionFinal reportCessna 180J · Kakhonak, AKThe pilot's decision to take off in unfavorable wind conditions.NTSB ERA10CA334Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8A · Gordonsville, VAThe student pilot’s failure to maintain directional control, and his excessive braking during the landing rollout.NTSB CEN10CA327Accident · Minor injuriesData collectionFinal reportRose-Rhinehart A4-C · Longmont, COA loss of engine power due to fuel starvation as a result of the pilot's failure to open the fuel valve, resulting a loss of engine power after takeoff. Contributing to the accident was the pilot's overall lack of experience in the airplane make/model.NTSB ERA10CA313Accident · Serious injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Mayfield, KYThe pilot's improper recovery from a bounced landing, resulting in a nose-over.NTSB DCA10FA066Accident · No injuriesField investigationFinal reportBoeing B75N1 · Arlington, VAThe pilot’s inadvertent use of the wheel brakes at high speed during the touchdown phase of the landing. Contributing to the accident was the pilot’s lack of familiarity with the feel and effectiveness of the airplane’s wheel brakes.NTSB ERA10CA271Accident · Serious injuriesData collectionFinal reportChampion 7BCM · Kingston, TNThe pilot's selection of an unsuitable landing site, which resulted in a nose-over.NTSB CEN10CA244Accident · No injuriesData collectionFinal reportPiper J3L · Kyle, SDThe pilot's improper touchdown on a soft landing area, resulting in a nose over.NTSB WPR10CA201Accident · Minor injuriesData collectionFinal reportCessna 150D · Galena, IDThe pilot's encounter with soft, snow-covered terrain while executing a precautionary landing.NTSB WPR10CA101Accident · Minor injuriesData collectionFinal reportCessna 195B · Palm Springs, CAThe pilot's improper use of brakes during landing.NTSB WPR10CA099Accident · No injuriesData collectionFinal reportCessna 182J · Metaline Falls, WAThe pilot's decision to land on a closed, snow-covered runway.NTSB WPR10CA098Accident · Minor injuriesData collectionFinal reportCessna 172R · Ramona, CAThe pilot's failure to maintain directional control during a touch-and-go landing.