NTSB investigations, 2023
31 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\") = 2023
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") = 2023 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 WPR24LA043Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Modesto, CAThe failure of the pilot to maintain directional control of the airplane during landing, which resulted in a nose over.NTSB ANC24LA006Accident · No injuriesClass 4 · LimitedFinal reportCharles J Kase Kase KUB · Big Lake, AKThe pilot’s selection of an unsuitable landing site that was covered in deep snow.NTSB ANC24LA002Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Wasilla, AKThe instructor pilot’s delayed action and over application of brakes which resulted in a nose-over.NTSB ERA24LA019Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Atlanta, GAThe flight instructor’s inadequate remedial action and the student pilot’s failure to relinquish the flight controls as directed by the flight instructor, resulting in a loss of control and nose over.NTSB ERA24LA017Accident · No injuriesClass 4 · LimitedFinal reportAviat A1 · Tellico Plains, TNThe pilot's overapplication of brakes after landing long on a constrained runway and with a tailwind, which resulted in a nose-over.NTSB WPR24LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Bandera, WAThe pilot’s decision to land at a closed water-soaked grass runway, which resulted in a runway excursion.NTSB CEN24LA007Accident · Minor injuriesClass 4 · LimitedFinal reportFairchild 24 G · Peyton, COThe pilot’s excessive brake application during landing rollout led to the airplane nosing over.NTSB ANC24LA001Accident · No injuriesClass 4 · LimitedFinal reportNathan A Rehak CAW-12 · Beluga, AKThe pilot’s loss of control after failing to determine wind direction during landing in variable, gusting wind conditions.NTSB WPR23LA361Accident · Minor injuriesClass 4 · LimitedFinal reportGleim James M MG-1 · Madera, CAAn emergency landing on uneven terrain that resulted in the loss of directional control during landing.NTSB ANC23LA087Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Beluga, AKThe pilot’s excessive application of brakes during landing that resulted in a nose over.NTSB ANC23LA084Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Bethel, AKThe pilot’s excessive use of brakes during landing roll, which resulted in a nose-over.NTSB GAA23WA263Accident · No injuriesClass 5 · ForeignFairchild 24 G · Trier-Föhren, GermanyNTSB ANC23LA075Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Healy, AKThe pilot’s selection of an unsuitable landing site, resulting in a nose over.NTSB ANC23LA068Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · McCarthy, AKThe pilot’s excessive application of brakes during landing that resulted in a nose over.NTSB WPR23LA326Accident · No injuriesClass 4 · LimitedFinal reportHenry Steven J JA 30 Superstol · Leavenworth, WAThe pilot's failure to maintain airplane control during taxi, which resulted in a nose over.NTSB ERA23LA390Accident · Minor injuriesClass 4 · LimitedFinal reportIrwin Jeffrey C Buccaneer Biib · Sopchoppy, FLThe pilot’s improper recovery from a bounced landing.NTSB ANC23LA059Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Iliamna, AKThe passenger’s inadvertent application of brakes during landing that resulted in a nose over.NTSB ANC23LA055Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18 · Palmer, AKThe student pilot’s inadvertent application of the brakes, which resulted in the airplane nosing over.NTSB ANC23LA047Accident · No injuriesClass 4 · LimitedFinal reportMaule M-5-210C · Kusatan, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a bounced landing and an encounter with soft terrain, and a nose over.NTSB WPR23LA250Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18 · McCall, IDThe pilot’s application of wheel brakes during landing roll out, resulting in a nose over.NTSB CEN23LA277Accident · Minor injuriesClass 4 · LimitedFinal reportPiper J3C-50 · Elbert, COThe pilot's loss of directional control during takeoff and subsequent excessive use of brakes which resulted in a nose-over. Contributing to the accident was his decision to takeoff downwind.NTSB CEN23LA242Accident · Minor injuriesClass 4 · LimitedFinal reportTipton Kitfox Kitfox IV · Odessa, MOThe pilot’s failure to attain the proper touchdown speed, which resulted in a runway excursion and subsequent nose over.NTSB WPR23LA224Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Agness, ORThe pilot’s failure to maintain sufficient airspeed and decision to touch down on the surface of the water, resulting in a nose over.NTSB WPR23LA228Accident · No injuriesClass 4 · LimitedFinal reportBenoit Leclair Rans S-7S · Bryce Canyon, UTThe pilot's failure to maintain control of the airplane during the landing roll and subsequent impact with terrain during go-around.NTSB ANC23LA040Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's excessive braking during landing on a sand bar, which resulted in a nose over.NTSB WPR23LA180Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Ariel, WAThe pilot’s failure to maintain aircraft control during the landing roll, resulting in a nose over.NTSB ANC23LA030Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Soldotna, AKThe pilot’s selection of an unsuitable landing site, which resulted in the main landing gear wheels breaking through the snow and the airplane nosing over.NTSB WPR23LA151Accident · No injuriesClass 4 · LimitedFinal reportLowe Bruce Skystr Ktfx IV-1200 · Susanville, CAThe pilot’s braking technique during an off airport precautionary landing on unforeseen soft terrain, which resulted in a nose over.NTSB ANC23LA028Accident · No injuriesClass 4 · LimitedFinal reportMaule M-5-235C · Palmer, AKThe pilot's delayed decision to execute a go-around maneuver while landing with excess airspeed into a short strip, which resulted in a runway overrun and subsequent loss of control.NTSB CEN23LA132Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-235B · Hotchkiss, COThe pilot’s loss of control during landing rollout on a snow-covered, turf airstrip.NTSB WPR23LA139Accident · No injuriesClass 4 · LimitedFinal reportFiedler Mark R PA-18 Replica · Sandy Valley, NVThe pilot’s failure to maintain airplane control during an off airport precautionary landing on soft soil, which resulted in a nose over.