NTSB investigations, AL
25 cases where the sequence of events included Nose over/nose down.
Cases per year
| 2008 | 2 |
|---|---|
| 2011 | 2 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 3 |
| 2015 | 3 |
| 2017 | 3 |
| 2018 | 1 |
| 2019 | 3 |
| 2020 | 2 |
| 2022 | 1 |
| 2025 | 2 |
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 c.\"eventStateOrRegion\" = 'AL' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'AL' AND c."eventCountry" = 'USA' 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 ERA25LA251Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Elberta, ALPilot’s decision to take off from a wet and unmaintained field that was unsuitable for airplane operations, resulting in a loss of control and subsequent nose over. Contributing was the pilot’s self-induced pressure to complete the flight.NTSB ERA25LA182Accident · Minor injuriesClass 4 · LimitedFinal reportRobb Aventura II · Elmore, ALThe pilot’s failure to configure the airplane for a water landing.NTSB ERA22LA423Accident · Serious injuriesClass 4 · LimitedFinal reportKumhyr David B Vans RV-8A · Elberta, ALThe pilot’s failure to maintain an appropriate descent rate during the landing approach, which resulted in a loss of control and subsequent nose over during landing.NTSB ERA20CA293Accident · Minor injuriesClass 4 · Data collectionFinal reportWag Aero Cubby · Pell City, ALThe flight instructor’s inadequate remedial action following the student pilot’s loss of directional control during landing, which resulted in a runway excursion and subsequent nose over.NTSB ERA20CA187Accident · No injuriesClass 4 · Data collectionFinal reportAviat A1B · Guntersville, ALThe pilot's failure to retract the amphibious airplane's landing gear wheels prior to a water landing, which resulted in a nose over.NTSB GAA20CA095Accident · No injuriesData collectionFinal reportCessna 120 · Marion, ALThe student pilot's overapplication of the brakes during landing to avoid a deer on the runway, which resulted in a nose-over.NTSB GAA19CA539Accident · No injuriesData collectionFinal reportPiper J3C · Winfield, ALThe pilot's failure to maintain proper wind correction input during taxi in a gusting tailwind, which resulted in a nose over.NTSB GAA19CA224Accident · No injuriesData collectionFinal reportLuscombe 8 · Bremen, ALThe pilot's delayed decision to abort the takeoff, which resulted in a runway overrun, impact with a fence, and a nose-over.NTSB CEN18LA151Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Cullman, ALThe pilot’s inadvertent engine shutdown due to excessive leaning of the engine and his subsequent inability to restart the engine.NTSB GAA17CA561Accident · No injuriesData collectionFinal reportAmerican Legend AL18 · Bessemer, ALThe student pilot’s incorrect application of the brakes and subsequent failure to maintain directional control during the landing roll. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB GAA17CA537Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Foley, ALThe ground crew’s incorrect hook up of the banner, which resulted in a nose-over.NTSB GAA17CA220Accident · No injuriesData collectionFinal reportShilt Jerry C F-1 Rocket · Bessimer, ALThe pilot’s failure to maintain directional control during the landing rollout in gusting crosswind conditions.NTSB GAA16CA068Accident · No injuriesData collectionFinal reportAviat A-1C · Hurtsboro, ALThe pilot's incorrect use of brake pressure during the landing roll, which resulted in a nose over.NTSB GAA16CA057Accident · No injuriesData collectionFinal reportChampion 7ECA · Eufaula, ALThe student pilot's decision to land with a quartering tailwind, resulting in a loss off directional control, excessive brake application, and a nose over.NTSB GAA15CA146Accident · No injuriesData collectionFinal reportCessna 150L · Huntsville, ALThe pilot's failure to maintain pitch control during the landing touchdown, resulting in a porpoise, and firewall damage.NTSB ERA14CA431Accident · No injuriesData collectionFinal reportPiper PA-18A-150 · Gunthersville, ALThe pilot's failure to retract the landing gear wheels prior to a water landing, resulting in a nose over upon touchdown.NTSB ERA14CA206Accident · No injuriesData collectionFinal reportCessna 172I · Huntsville, ALThe pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA14CA177Accident · No injuriesData collectionFinal reportAviat A 1B · Dadeville, ALThe pilot's failure to obtain the proper touchdown point while landing on a lake with a tailwind.NTSB ERA14LA094Accident · No injuriesLimited investigationFinal reportCessna 150H · Livingston, ALThe pilot's inadequate soft-field technique during the precautionary landing, which resulted in a nose-over. Contributing to the accident was the pilot's inadequate preflight inspection, which resulted in departure with an open fuel port and the subsequent…NTSB ERA13LA052Accident · No injuriesLimited investigationFinal reportWaller Charles R Rans S12-XL · Gordon, ALA fatigue failure of the elevator pitch trim cable, which resulted in aerodynamic flutter of the elevator in flight and the airplane’s subsequent nose-over during the resultant precautionary landing.NTSB ERA12CA339Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Gulf Shores, ALThe pilot's inadvertent application of the wheel brakes immediately after landing, which resulted in the airplane nosing over.NTSB ERA11LA388Accident · No injuriesLimited investigationFinal reportCessna 172N · Orange Beach, ALThe operation of the airplane using unapproved fuels, which resulted in abnormal combustion and subsequent damage to the No. 3 cylinder. Contributing to the accident was the inadequate 100-hour inspection because the mechanic failed to note the lack of…NTSB ERA11LA242Accident · No injuriesLimited investigationFinal reportWsk-Mielec AN-2 · Loxley, ALA loss of engine power due to internal failure.NTSB NYC08CA328Accident · No injuriesData collectionFinal reportHood Junior Ace · Ashville, ALThe pilot's improper flare while landing. Contributing to the accident was the airplane's lack of yaw control as reported by the pilot.NTSB NYC08CA321Accident · No injuriesData collectionFinal reportGrimes Barry R Chinook Plus TWO · Magnolia Springs, ALThe total loss of engine power during initial climb due to the failure of the fuel pump.