NTSB investigations, 2016
174 cases where the sequence of events included Nose over/nose down.
Cases, newest first
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\") = 2016
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") = 2016 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 GAA16CA507Accident · No injuriesData collectionFinal reportStropki Paul Outback · Dalton, OHThe pilot's failure to maintain directional control of the airplane during landing in gusting wind conditions, which resulted in a ground loop.NTSB GAA16CA474Accident · No injuriesData collectionFinal reportCessna 180 · Yakutat, AKThe pilot's inadequate inspection of the off-airport landing area, which resulted in an encounter with standing water and a nose over.NTSB GAA16CA468Accident · No injuriesData collectionFinal reportMaule M4 · Talkeetna, AKThe pilot's failure to recognize and compensate for tailwind conditions during the landing roll, which resulted in a runway overrun and nose over.NTSB GAA16CA464Accident · No injuriesData collectionFinal reportNorth American SNJ · Perris, CAThe pilot's inability to compensate for a dust devil during an aborted landing, which resulted in the left wing contacting the ground, a runway excursion, and the airplane coming to rest in a nose-down attitude.NTSB GAA16CA463Accident · No injuriesData collectionFinal reportCessna 182 · Barrow, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, a nose over, and substantial damage to the right wing strut and fuselage. Contributing to the accident was the sun glare which inhibited the…NTSB GAA16CA529Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Delaware, OHThe student pilot’s inadequate compensation for the quartering tailwind on landing, which resulted in a loss of directional control.NTSB GAA16CA459Accident · No injuriesData collectionFinal reportCessna A185 · Gooding, IDThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB GAA16CA456Accident · No injuriesData collectionFinal reportPiper PA18 · Kenai, AKThe pilot's improper soft field landing technique on a soft grass airstrip, which resulted in a nose over.NTSB CEN16CA360Accident · No injuriesData collectionFinal reportCessna 140 · Lebanon, INPC The unseen standing water on the runway that abruptly slowed the tailwheel equipped airplane during landing resulting in a nose-over.NTSB GAA16CA502Accident · No injuriesData collectionFinal reportArion Skys Open Sport Lightning · St. Augustine, FLThe pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA16CA448Accident · No injuriesData collectionFinal reportCessna 152 · Miami, FLThe pilot's improper pitch control during landing, which resulted in a bounced landing, and a nose landing gear collapse.NTSB GAA16CA444Accident · Minor injuriesData collectionFinal reportP Z L -Warszawa-Cnpsl PZL 104 Wilga · Austin, NVThe pilot's failure to maintain an appropriate descent rate during the base to final turn, which resulted in a forced landing, and an intentional aerodynamic stall. Contributing to the accident was the pilot's excessive braking, which resulted in a nose over…NTSB GAA16CA442Accident · No injuriesData collectionFinal reportCessna 172 · Anchorage, AKThe facility's designation of the taxiway for use by maintenance personnel to conduct high thrust tests without appropriate safeguards in place, which led to maintenance personnel conducting high-power, run-up thrust procedures across the active taxiway and…NTSB GAA16CA440Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Palmer, AKThe pilot's excessive brake application during the landing roll resulting in a nose over.NTSB GAA16CA441Accident · No injuriesData collectionFinal reportValloric Carl Stephen Valloric Sport Trnr · Cadiz, OHThe pilot's failure to maintain directional control during landing and the unintentional right brake application, which resulted in a runway excursion and a nose over.NTSB ERA16CA294Accident · No injuriesData collectionFinal reportCessna 152 · Newnan, GAThe student pilot's improper decision to land long and maintain excessive speed during the landing roll. Contributing to the accident was the student pilot's decision to maintain full flaps and aft yoke inputs at a higher speed, reducing his ability to stop…NTSB GAA16CA436Accident · No injuriesData collectionFinal reportPiper PA18 · Anchor Point, AKThe pilot's failure to maintain clearance from obstacles while landing on a coastal beach.NTSB GAA16CA432Accident · No injuriesData collectionFinal reportCessna 150 · North Conway, NHThe pilot's improper fuel management, which resulted in fuel exhaustion, a total loss of engine power, a forced landing, and nose over.NTSB CEN16LA324Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Lino Lakes, MNA partial loss of engine power due to the formation of carburetor ice, which resulted in reduced climb capability and impact with vegetation and terrain during takeoff.NTSB GAA16CA433Accident · No injuriesData collectionFinal reportMaule MXT7 · Quitman, ARThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a nose over. Contributing to the accident was the pilot's limited forward visibility due to sun glare.NTSB GAA16CA425Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · San Diego, CAThe pilot's failure to maintain directional control during landing with a crosswind.NTSB CEN16CA319Accident · No injuriesData collectionFinal reportCessna 172S · Arlington, TXThe student pilot's improper recovery from a bounced landing.NTSB GAA16CA422Accident · No injuriesData collectionFinal reportCessna 195 · Hillsborough, ORThe pilot's failure to attain a proper touchdown point and loss of directional control and her subsequent excessive brake application, which resulted in a nose-over.NTSB GAA16CA424Accident · No injuriesData collectionFinal reportStinson 108 · Sunriver, ORThe pilot's failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in runway excursion and nose-over.NTSB CEN16LA306Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Russellville, OHA partial loss of engine power due to a fatigue crack of the No. 2 cylinder cooling fin, which resulted in failure of the No. 2 cylinder.NTSB GAA16CA423Accident · No injuriesData collectionFinal reportBeech F33 · Bivalve, MDThe pilot's excessive airspeed during landing, which resulted in a runway overrun, and impact with a ditch.NTSB GAA16CA416Accident · No injuriesData collectionFinal reportCessna 172 · Palm Springs, CAThe student pilot's failure to maintain directional control during an aborted landing, which resulted in a runway excursion and a nose over in rough terrain.NTSB GAA16CA414Accident · No injuriesData collectionFinal reportCessna 150 · New Albany, MSThe pilot's failure to maintain an appropriate pitch attitude during landing, which resulted in an initial nose wheel contact, followed by a nose gear collapse, and the airplane came to rest in a nose down position.NTSB GAA16CA406Accident · No injuriesData collectionFinal reportCessna 177 · Kalispell, MTThe airplane's hard landing during an aborted takeoff, following an encounter with a downdraft during takeoff initial climb from a remote mountain airstrip, resulting in an uncontrolled descent, attempt to land on the runway remaining, and subsequent nose…NTSB GAA16CA401Accident · Minor injuriesData collectionFinal reportS C Aerostar S .A. Festival R40S · Frankfort, MIThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion, a nose gear collapse, and impact with terrain.NTSB GAA16CA404Accident · No injuriesData collectionFinal reportCessna 177 · Wickenburg, AZThe pilot's incorrect balked landing procedure, which resulted in an uncontrolled descent, hard landing, a runway excursion, and nose gear collapse.NTSB GAA16CA400Accident · No injuriesData collectionFinal reportCessna 172 · Morristown, NJThe pilot's failure to maintain a safe taxi distance from a large turbine-powered airplane, resulting in an encounter of the turbine-powered airplane's jet blast while taxiing.NTSB GAA16CA397Accident · No injuriesData collectionFinal reportOlmsted Charles A RV · Dwight, ILThe pilot's delayed action to perform an aborted landing, which resulted in a nose over and substantial damage to the firewall, fuselage, and empennage.NTSB GAA16CA398Accident · No injuriesData collectionFinal reportCessna 152 · Denton, TXThe student pilot's improper approach descent rate and landing flare attitude, which resulted in a hard landing and collapse of the nose landing gear.NTSB GAA16CA389Accident · Minor injuriesData collectionFinal reportCirrus Design SR22 · Hyannis, MAThe pilot's failure to maintain an appropriate descent rate during landing, which resulted in a hard landing, followed by a loss of directional control, runway excursion, and an impact with a security fence and vehicles during the subsequent attempt to abort…NTSB GAA16CA395Accident · No injuriesData collectionFinal reportEngineering & Research 415 · Collinsville, OKThe pilot's failure to maintain directional control during takeoff in a high density altitude condition, which resulted in a runway excursion and impact with a tree.NTSB CEN16LA287Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Dodge Center, MNA partial loss of engine power due to carburetor ice.NTSB ERA16LA263Accident · No injuriesLimited investigationFinal reportTecnam P2008 · Warrenton, VAThe pilot’s decision to begin the takeoff roll with helicopter traffic on the runway, which led to a rejected takeoff. Contributing to the accident was the pilot’s improper use of the toe brakes, which he had limited experience using and resulted in a runway…NTSB WPR16LA141Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Minden, NVThe failure of a main landing gear leg during takeoff due to corrosion, which resulted in a nose-over during the subsequent landing on a grassy area.NTSB GAA16CA382Accident · Minor injuriesData collectionFinal reportGonzalez Manuel A RV 7 · Langley, WAThe pilot's decision to land with a tailwind, which resulted in, landing long, a runway overrun, and impact with a berm and nose over.NTSB GAA16CA379Accident · Minor injuriesData collectionFinal reportJesse Saint/Troy Townsend/Etha CH-801 · Beaumont, KSThe pilot's incorrect pitch control during the landing flare in gusty crosswind conditions, which resulted in a hard bounced landing and a nose over.NTSB GAA16CA376Accident · No injuriesData collectionFinal reportCessna 182 · Stevensville, MTThe pilot's failure to maintain adequate clearance from ground equipment during takeoff, which resulted in an impact with irrigation pipes, a loss of directional control, an impact with a fence, and a nose over.NTSB GAA16CA374Accident · Minor injuriesData collectionFinal reportCessna 150 · Cleveland, GAFailure of the left main landing gear attachment during the landing roll, which resulted in a left landing gear collapse, and damage to the left wing and aileron.NTSB CEN16LA263Accident · 1 fatalLimited investigationFinal reportEvolution Trikes Revo · Newark, ILThe student pilot's failure to maintain directional control on landing. Contributing to the accident was the pilot's lack of flight experience.NTSB GAA16CA369Accident · No injuriesData collectionFinal reportStinson 108 · Red Lodge, MTA deer running across the runway and impacting the left side of the airplane, resulting in a loss of directional control, a runway excursion, and a ground loop.NTSB CEN16LA259Accident · No injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe pilot's unstabilized approach and uneven braking due to insufficient runway remaining, which resulted in a loss of directional control during landing. Contributing to the accident was the bound flap jackscrew, which jammed the flaps and led to the pilot’s…NTSB GAA16CA370Accident · No injuriesData collectionFinal reportCessna 180 · New Durham, NHThe pilot's failure to maintain directional control during landing after encountering a boat wake, which resulted in the airplane veering left, impacting the water's surface, and subsequently becoming submerged.NTSB WPR16LA135Accident · No injuriesLimited investigationFinal reportBert N Norris RV-6 · St. Maries, IDA partial loss of engine power due to carburetor icing, which resulted from the pilot’s failure to apply carburetor heat.NTSB GAA16CA355Accident · No injuriesData collectionFinal reportRainbow Sky Reach Bushcat · Cairo, NEThe pilot's decision to fly into deteriorating weather conditions, leading to a precautionary off airport soft field landing which resulted in a nose gear collapse and the airplane to nose over.NTSB CEN16LA250Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Oak Ridge, LAThe pilot's failure to maintain airplane control during the aborted takeoff, which resulted in it becoming airborne momentarily and then over running the runway.