NTSB investigations, 2012
129 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 | 75 |
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\") = 2012
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") = 2012 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 CEN13LA103Accident · Serious injuriesLimited investigationFinal reportAuman JL T-51 · Dekalb, ILThe improper engine overhaul by the airplane kit manufacturer, which resulted in a catastrophic engine failure.NTSB CEN13LA104Accident · No injuriesLimited investigationFinal reportCessna 172M · Arcola, TXThe loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR13LA063Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-1T · Billings, MTThe pilot’s inability to maintain directional control during the landing roll because of the failure of the tailwheel support bracket.NTSB ERA13LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Canton, GAA partial loss of engine power due to carburetor icing, which the pilot could not correct by applying carburetor heat because the movement of the carburetor heat control arm was restricted.NTSB CEN13LA057Accident · No injuriesLimited investigationFinal reportCessna T182T · San Antonio, TXThe pilot’s misjudgment of the landing speed and the runway distance remaining and his delay in applying the brakes, which resulted in an overrun.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 CEN13CA064Accident · Minor injuriesData collectionFinal reportLawson Ron Rans S-19 · Crowley, LAThe pilot’s improper landing flare, which resulted in the collapse of the nose landing gear and the airplane nosing over.NTSB CEN13LA056Accident · Minor injuriesLimited investigationFinal reportCessna 210L · La Grange, TXThe total loss of engine power due to the loss of oil to the engine. Contributing to the accident was maintenance personnel’s improper installation of the engine oil filter adaptor, which resulted in the loss of oil to the engine.NTSB CEN13LA050Accident · No injuriesLimited investigationFinal reportWaco SRE · Lafayette, LAThe pilot’s inability to maintain directional control of the airplane during the landing roll.NTSB CEN13CA042Accident · Minor injuriesData collectionFinal reportLuscombe 8E · West Bend, WIThe pilot‘s failure to maintain clearance from power lines at the end of the short runway, which resulted in an aborted takeoff and subsequent nose-over of the airplane.NTSB WPR13CA033Accident · Minor injuriesData collectionFinal reportCessna 140 · Watsonville, CAThe pilot’s failure to maintain airplane control during the landing roll.NTSB CEN13CA037Accident · No injuriesData collectionFinal reportBates Starduster SA-300 · Reklaw, TXThe pilot’s improper recovery from a bounced landing, which resulted in a noseover.NTSB WPR13CA019Accident · Serious injuriesData collectionFinal reportQuicksilver Mfg MXL II Sport · Live Oak, CAThe pilot’s failure to compensate for turbulent conditions, which resulted in a loss of altitude.NTSB ERA13LA029Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Edison, GAThe total loss of engine power due to the fatigue failure of the k-pin associated with the No. 1 cylinder.NTSB ERA13CA047Accident · No injuriesData collectionFinal reportDaniels Alan L Kitfox Series 7 · Plymouth, MAThe pilot's improper landing flare and subsequent inadequate recovery from a bounced landing.NTSB CEN13LA011Accident · No injuriesLimited investigationFinal reportMeyers Little Toot · Roanoke, TXThe total loss of engine power due to partially obstructed fuel lines.NTSB ANC12LA113Accident · Minor injuriesLimited investigationFinal reportAviat A-1 · Fairbanks, AKThe pilot’s excessive application of brakes during landing, which resulted in a noseover.NTSB ANC12CA112Accident · No injuriesData collectionFinal reportPiper PA-12 · Fairbanks, AKThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB ERA12LA574Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Corinth, MSThe improper torque application on the crankshaft gear bolt by maintenance personnel during an engine overhaul, which resulted in the fatigue failure of the locking tab washer and gear alignment dowel and subsequent engine stoppage. Contributing to the…NTSB CEN12LA635Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Mecosta, MIThe pilot's improper landing flare, which resulted in a bounced landing and loss of airplane control.NTSB ANC12CA108Accident · No injuriesData collectionFinal reportCessna 172K · Atqasuk, AKThe student pilot's failure to maintain directional control while performing a high-speed taxi in windy conditions.NTSB WPR12LA409Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Monroe, WAA loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR12LA402Accident · Serious injuriesLimited investigationFinal reportHansen HANSEN-VANS RV-6 · Lemolo Lake, ORAn overvoltage event due to the failure of the automotive voltage regulator, which resulted in electrical anomalies and smoke in the cockpit and a subsequent forced off-airport landing.NTSB ERA12CA547Accident · Minor injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Tail Dragger · Elizabethtown, KYThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane during a takeoff in gusty crosswind conditions. Contributing to the accident was the pilot's decision to take off in gusty wind conditions associated with approaching…NTSB WPR12CA401Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Lewiston, IDThe pilot’s inadequate postmaintenance and preflight inspections, which resulted in the separation of the left main wheel after takeoff. Contributing to the accident was the improperly secured left main wheel spindle nut.NTSB CEN12CA608Accident · No injuriesData collectionFinal reportRolladen-Schneider OHG LS3-A · Navasota, TXThe pilot’s inadequate compensation for landing area conditions during an off-airport landing, which resulted in a loss of directional control and a collision with terrain.NTSB WPR12CA388Accident · Minor injuriesData collectionFinal reportPiggott John H Bearhawk · Sequim, WAThe student pilot's failure to maintain directional control on landing.NTSB ANC12CA099Accident · No injuriesData collectionFinal reportCessna 180 · Kenai, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over.NTSB ERA12LA539Accident · No injuriesLimited investigationFinal reportCessna 172M · Canadensis, PAThe pilot’s failure to attain a proper glidepath.NTSB ANC12CA102Accident · No injuriesData collectionFinal reportPiper PA-12 · Aniak, AKThe pilot's excessive use of brakes during the landing roll, which resulted in a nose over.NTSB CEN12LA593Accident · No injuriesLimited investigationFinal reportMudge Ray KIT FOX 5 · Bowling Green, OHThe pilot receiving instruction's excessive braking during the landing roll, which resulted in a loss of control.NTSB CEN12LA589Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Ralls, TXThe total loss of engine power due to a fatigue failure of the rocker arm journal casting of the rocker arm cap.NTSB ANC12CA094Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Delta Junction, AKThe pilot’s failure to identify the appropriate touchdown point, which resulted in a nose over.NTSB CEN12LA580Accident · No injuriesLimited investigationFinal reportCessna 140 · Spearfish, SDThe partial loss of engine power due to debris lodged beneath the throttle body of the carburetor venturi.NTSB ERA12CA533Accident · Minor injuriesData collectionFinal reportStearman M-2 · Robbinsville, NJThe pilot's failure to maintain directional control during the landing roll.NTSB WPR12CA363Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8E · Hillsboro, ORThe pilot’s improper use of the brakes during the landing roll, which resulted in a nose over.NTSB CEN12LA556Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Sidney, NEThe pilot's misuse of the brakes during landing, which resulted in the airplane nosing over.NTSB ERA12CA520Accident · No injuriesData collectionFinal reportFleet Fleet 16B · Bayport, NYThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA12CA517Accident · No injuriesData collectionFinal reportAir Tractor AT-402B · Gum Neck, NCThe pilot's failure to maintain airplane control during the takeoff roll. Contributing to the accident was the rough condition of the runway.NTSB ANC12CA088Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot's loss of control during the landing roll in gusting wind conditions, which resulted in the airplane nosing over.NTSB ANC12CA086Accident · No injuriesData collectionFinal reportPiper PA-18 · Anchorage, AKThe passenger's inadvertent application of the brake pedals during landing, which resulted in a noseover.NTSB CEN12CA537Accident · No injuriesData collectionFinal reportGage Midget Mustang MM-1 · Erie, COThe pilot's inadequate compensation for the crosswind conditions during takeoff, which resulted in a loss of directional control.NTSB ERA12CA502Accident · No injuriesData collectionFinal reportMaule M-4C · Lincoln, METhe pilot's failure to maintain directional control during the landing roll.NTSB CEN12FA520Accident · No injuriesField investigationFinal reportPiper PA-38-112 · Fate, TXA total loss of engine power for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation.NTSB CEN12CA526Accident · Minor injuriesData collectionFinal reportCessna 172R · Leesville, LAThe student pilot's failure to properly re-configure the airplane for a go-around, which resulted in a runway excursion when he decided to land on the remaining runway.NTSB WPR12CA353Accident · No injuriesData collectionFinal reportCessna 182 · Joseph, ORThe pilot’s excessive use of brakes during the landing roll in a gusting crosswind, which resulted in a noseover.NTSB CEN12LA493Accident · No injuriesLimited investigationFinal reportCessna 182G · Montrose, COThe pilot's improper landing flare and inadequate recovery from a bounced landing.NTSB CEN12CA499Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Hutchinson, KSThe pilot’s loss of directional control during the landing roll.NTSB WPR12CA322Accident · No injuriesData collectionFinal reportCubCrafters CC 11-160 · Stanley, IDThe pilot’s excessive use of the brakes during the landing roll.NTSB CEN12LA470Accident · Minor injuriesLimited investigationFinal reportYamokoski William Glastar · Chicago, ILFailure of the automotive engine's reduction gearbox while in cruise flight.