NTSB investigations
470 cases where the defining event was 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 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 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 CEN11CA203Accident · No injuriesData collectionFinal reportCessna 195A · Hannibal, MOThe pilot's inability to maintain control during landing due to seized main landing gear wheels, which caused the airplane to nose over.NTSB ANC11CA013Accident · No injuriesData collectionFinal reportPiper PA-18 · Sterling, AKThe airplane owner improper fabrication of a fuel line, and subsequent inadequate inspection by an aviation mechanic, resulting in a loss of engine power.NTSB WPR11CA132Accident · Minor injuriesData collectionFinal reportCessna 170A · Baker Lake, WAThe pilot's encounter with soft terrain during an attempted takeoff from a dry lake bed.NTSB WPR11CA128Accident · No injuriesData collectionFinal reportSchweizer G-164B · Buttonwillow, CAThe pilot's failure to maintain clearance from an irrigation vent pipe.NTSB WPR11CA110Accident · No injuriesData collectionFinal reportWalker Louie H Super 18 Cuby · Toutle, WAThe pilot's excessive braking during the landing roll, which resulted in the airplane nosing over onto its back. Contributing to the accident was the pilot's decision to land on a sandbar that he had not adequately inspected and his improper airspeed while on…NTSB WPR11FA103Accident · 1 fatalField investigationFinal reportCessna T206H · Stanwood, WAThe pilot did not confirm retraction of the landing gear before landing on water as a result of distraction. Contributing to the accident was the pilot coping with the death of a close family member in the days before the accident, which resulted in a…NTSB WPR11CA098Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Austin, NVThe pilot’s failure to maintain directional control during the takeoff roll.NTSB WPR11CA088Accident · No injuriesData collectionFinal reportFerkin Kitfox IV · Homedale, IDThe pilot's inadequate compensation for the snow-covered terrain during the takeoff ground roll, which resulted in a nose-over.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.NTSB WPR10CA071Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Stockton, CAThe pilot’s inadequate compensation for a crosswind condition.NTSB WPR10CA043Accident · Minor injuriesData collectionFinal reportCessna 120 · Mineral Canyon, UTThe pilot's incorrect use of brakes, which resulted in the airplane nosing over.NTSB CEN10LA032Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Walsh, COA partial loss of engine power due to failure of the No. 2 cylinder as a result of the failure of the repair facility to properly torque the lower four nuts on the cylinder.NTSB ANC09CA099Accident · No injuriesData collectionFinal reportPiper PA-18 · Chickaloon, AKThe pilot's decision to land on unsuitable terrain, which resulted in a nose-over on landing.NTSB ANC09TA092Accident · No injuriesFinal reportAviat A-1B · Gulkana, AKThe pilot's excessive use of brakes during an off-airport landing, resulting in the airplane nosing over.NTSB ANC09TA090Accident · No injuriesFinal reportPiper PA-18-150 · Bethel, AKThe pilot's excessive use of brakes while landing at an off-airport site.NTSB ANC09CA087Accident · No injuriesData collectionFinal reportPiper PA-12 · Dillingham, AKThe pilot's decision to land on unsuitable soft, wet terrain, which resulted in a nose-over on landing.NTSB ERA09CA463Accident · No injuriesData collectionFinal reportAmerican Legend AL3C · Warrenton, VAThe pilot's improper application of brakes during the landing rollout.NTSB ANC09CA059Accident · No injuriesData collectionFinal reportCessna 170A · Kasigluk, AKThe student pilot's failure to maintain directional control during the landing roll in a crosswind.NTSB WPR09CA295Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Dixie, IDThe pilot's excessive braking during the landing roll.NTSB ERA09CA334Accident · No injuriesData collectionFinal reportPiper J3C-65 · Alamana, FLThe pilot's selection of unsuitable terrain for landing.NTSB CEN09CA326Accident · Minor injuriesData collectionFinal reportAeropro CZ Eurofox · Bloomfield, INThe pilot's selection of an unsuitable landing area.NTSB WPR09CA260Accident · No injuriesData collectionFinal reportStinson SR-8B · Tacoma, WAThe application of unintended braking input due to the pilot's failure to keep his feet correctly positioned on the rudder pedals during the landing roll.NTSB ANC09CA037Accident · No injuriesData collectionFinal reportCessna 140 · Haines, AKThe pilot's decision to practice takeoff and landings on unsuitable terrain, which resulted in a nose-over on takeoff.NTSB ERA09CA254Accident · Minor injuriesData collectionFinal reportAmerican Longevity Searey · Littleton, NCThe pilot's failure to ensure the landing gear was properly configured for the water landing.NTSB WPR09CA199Accident · No injuriesData collectionFinal reportCessna A185F · Bisbee, AZThe flight instructor's inadequate supervision of the flight and inadequate recovery from a bounced landing.NTSB ERA09LA244Accident · No injuriesLimited investigationFinal reportDe Havilland DHC2 · Plattsburgh, NYThe pilot's improper application of brakes during the landing rollout.NTSB CEN09LA231Accident · No injuriesLimited investigationFinal reportCessna R172K · Hazen, NDThe pilot's failure to maintain directional control of the airplane during the landing roll.