NTSB investigations
2,288 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 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."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 ANC08CA105Accident · Minor injuriesData collectionFinal reportWalker AK Bush Flyer · Deadhorse, AKThe pilot's failure to maintain control of the airplane during the landing roll. A factor contributing to the accident was a tailwind.NTSB SEA08CA176Accident · Minor injuriesData collectionFinal reportCessna 210E · Auburn, WAA catastrophic engine failure due to the partial blockage of the lubricating oil galley in one of the crankshaft connecting rod journals, leading to the failure of the connecting rod cap.NTSB CHI08CA240Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164B · Salem, IAThe loss of engine power for an undetermined reason. Contributing to the accident was the high grass encountered during the landing roll.NTSB ANC08LA101Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKThe pilot's excessive speed and excessive application of brakes during the landing roll on soft, sandy terrain.NTSB DEN08CA135Accident · No injuriesData collectionFinal reportGrumman G-164A · Walsh, COThe total failure of a cylinder head assembly. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB ANC08TA099Accident · No injuriesFinal reportPiper PA-18 · Nome, AKThe pilot's failure to maintain directional control of the airplane during the takeoff roll.NTSB DFW08LA209Accident · No injuriesLimited investigationFinal reportEvektor Aerotechnik Sportstar · St Charles, MOThe student pilot's failure to maintain control due to his task saturation as a result of his failure to set the pitch trim to the neutral position before takeoff.NTSB CHI08CA234Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Lawrenceville, ILThe pilot's misjudged application of the brakes during landing.NTSB MIA08CA155Accident · No injuriesData collectionFinal reportCubcrafter CC11-100 · Gilbert, SCThe pilot's improper use of brakes during landing roll resulting in a nose-over.NTSB LAX08CA252Accident · No injuriesData collectionFinal reportCessna 152 · Glendale, AZThe student pilot's misjudged altitude and distance, and failure to attain the proper touchdown point, that led to a landing overrun.NTSB LAX08CA278Accident · No injuriesData collectionFinal reportPiper PA-22 · St. Paul, ORThe pilot's misjudged altitude, speed, and subsequent failure to attain the proper touchdown point while landing.NTSB CHI08CA225Accident · Serious injuriesData collectionFinal reportAero Commander 200D · Tecumseh, MIThe pilot flaring too high, and his inadvertent pilot-induced oscillation during the landing flare/touchdown. Contributing to the accident was the collapse of the nose landing gear.NTSB CHI08LA214Accident · Minor injuriesLimited investigationFinal reportBolenbaugh Phillip William Rans S-6ES · Oshkosh, WIThe pilot's improper landing flare, which resulted in a hard landing and subsequent collapse of the nose landing gear.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.NTSB NYC08CA257Accident · Minor injuriesData collectionFinal reportCessna 172S · Stevensville, MDThe flight instructor's inadequate remedial action following the student pilot's improper recovery from a bounced landing.NTSB SEA08CA165Accident · No injuriesData collectionFinal reportAntares - Balaban MA33 · Byron, CAThe pilot's failure to maintain an adequate airspeed, which resulted in a stall/mush.NTSB LAX08LA240Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Bountiful, UTA partial loss of engine power for undetermined reasons.NTSB LAX08CA234Accident · No injuriesData collectionFinal reportCessna 172M · Leavenworth, WAThe pilot's inadequate preflight planning and failure to attain a sufficient airspeed to continue the takeoff. A contributing factor was the high density altitude and short runway.NTSB CHI08CA199Accident · No injuriesData collectionFinal reportEagle Eagle DW-1 · Bryan, OHThe loss of engine power due to fuel exhaustion as a result of the pilot's improper fuel calculations. A contributing factor was the inaccurate fuel gauge.NTSB NYC08LA249Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Surfside Beach, SCA loss of engine power due to carburetor icing. Contributing to the accident was the obstruction of the carburetor heat flapper by a mud dauber's nest.NTSB NYC08LA247Accident · Minor injuriesLimited investigationFinal reportBoeing B75N1 · Culpeper, VAThe pilot's failure to maintain directional control of the airplane while landing in a quartering tailwind.NTSB NYC08LA245Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Pelham, GAA partial loss of engine power for undetermined reasons which led to a forced landing in unsuitable terrain.NTSB LAX08LA226Accident · No injuriesLimited investigationFinal reportJonsson Sonerai · Hood River, ORThe pilot's failure to maintain directional control during the emergency landing roll with a tailwind. Contributing was the partial separation of the left aileron that prompted the pilot to attempt the emergency landing.NTSB LAX08CA220Accident · Serious injuriesData collectionFinal reportDavid Jarrett Searey · Ennis Lake, MTThe pilot's failure to retract the landing gear prior to landing on the water.NTSB LAX08CA227Accident · Minor injuriesData collectionFinal reportBeech E17B · Hubbard, ORThe pilot's improper use of brakes during the landing rollout.NTSB CHI08CA184Accident · No injuriesData collectionFinal reportHuebner RV6-A · Jerseyville, ILThe muddy, unsuitable terrain encountered during the landing.NTSB NYC08CA240Accident · No injuriesData collectionFinal reportCessna C-195 · Johnstown, NYThe pilot's failure to maintain aircraft control during the landing roll.NTSB LAX08CA208Accident · No injuriesData collectionFinal reportPipistrel Virus 912 · Bend, ORThe pilot's improper flare, inadequate bounced landing recovery, and his failure to maintain directional control.NTSB ANC08CA084Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Anchorage, AKThe pilot's selection of an unsuitable landing area.NTSB ANC08CA080Accident · No injuriesData collectionFinal reportPiper PA-12 · Wasilla, AKThe pilot's selection of an unsuitable landing area.NTSB NYC08CA232Accident · Minor injuriesData collectionFinal reportYowell Mallard II · Groveland, FLThe pilot's failure to use the checklist and his failure to retract the landing gear for a water landing. Contributing to the accident was the pilot's diverted attention.NTSB LAX08CA204Accident · No injuriesData collectionFinal reportAeronca 7DC · Elk River, IDThe pilot's failure to maintain directional control.NTSB MIA08LA130Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Hollywood, FLThe pilot's failure to achieve the proper touchdown point on landing and improper use of brakes. Contributing to the accident was the failure of the throttle cable attachment tab due to preexisting cracks.NTSB LAX08LA201Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Rainier, ORThe inadvertent extension of the left float's landing gear to near the down position due to a failure of the gear's rear hydraulic seal.NTSB DFW08CA175Accident · No injuriesData collectionFinal reportChristen Industries A-1 · Pueblo, COThe pilot's failure to maintain directional control during landing. Contributing to the accident were the wind gust and tailwind.NTSB DEN08LA110Accident · No injuriesLimited investigationFinal reportCessna R172K · Goldsby, OKThe pilot's delay in initiating rejected takeoff procedures, resulting in the airplane going off the end of the runway and nosing over.NTSB ANC08LA077Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Willow, AKA partial loss of engine power during an aborted landing for an undetermined reason, which resulted in a collision with terrain and subsequent nose over.NTSB LAX08LA177Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Wilder, IDThe loss of engine power as a result of failure of the supercharger. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB LAX08CA174Accident · Minor injuriesData collectionFinal reportCessna 182 · Cottage Grove, ORThe pilot's misjudged landing flare.NTSB LAX08CA167Accident · No injuriesData collectionFinal reportCessna 182 · Moab, UTThe pilot's inadequate compensation for the tailwind condition, and improper use of additional power while taxiing. Contributing to the accident was soft ground and a gusting tailwind.NTSB CHI08CA155Accident · No injuriesData collectionFinal reportCessna 180 · Eveleth, MNThe pilot elected to land on a grass airstrip that was unsuitable for landing due to the wet, soft runway conditions. The wet, soft runway were factors.NTSB CHI08CA157Accident · Minor injuriesData collectionFinal reportCessna 172C · Nortonville, NDThe pilot's inadequate preflight which resulted in insufficient fuel on board to complete the flight. A factor associated with the accident was the soft terrain encountered during the forced landing.NTSB NYC08CA203Accident · No injuriesData collectionFinal reportCessna 180 · Kutztown, PAThe pilot's failure to maintain aircraft control.NTSB MIA08CA107Accident · No injuriesData collectionFinal reportWaco GXE · Provincetown, MAThe pilot's failure to maintain directional control while landing.NTSB LAX08FA144Accident · 2 fatalField investigationFinal reportde Havilland DHC-2 MK I · Stehekin, WAThe pilot's failure to retract the landing gear wheels prior to performing a water landing. Contributing to the accident were the pilot's disabling of the landing gear warning/advisory system and possible fatigue due to his work schedule.NTSB LAX08CA143Accident · No injuriesData collectionFinal reportMason RV-9A · Pacific City, ORThe pilot's inadequate flare and failure to maintain control following a hard landing. Contributing to the accident was a temporary partial loss of power due to carburetor icing conditions.NTSB CHI08CA130Accident · No injuriesData collectionFinal reportCessna 150 · Pulaski, WIThe student pilot's failure to take remedial action in response to a porpoise/pilot-induced oscillation during landing. Factors were the porpoise, the pilot's lack of experience, and the separation of the nose landing gear.NTSB ANC08CA066Accident · No injuriesData collectionFinal reportde Havilland DHC-2 · Talkeetna, AKThe pilot's inadvertent activation of the main landing gear brakes during the recovery from a bounced landing.NTSB CHI08CA131Accident · Minor injuriesData collectionFinal reportKuntz Kuntz 2000 GTS EFI · Dickinson, NDThe pilot's inadequate preflight weather evaluation and the unsuitable terrain encountered during the precautionary landing at night. Contributing to the accident was the pilot becoming lost after inadvertently encountering fog while en route, the night…NTSB LAX08LA135Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Oljato, UTThe pilot's failure to achieve a normal touchdown location and loss of directional control during landing roll out. Contributing to the accident were the runway's soft surface and short length.