NTSB investigations
665 cases where the first occurrence was “Nose over”.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 300) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 300) 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 LAX99LA169Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Lancaster, CAThe pilot's decision to attempt a ground turning maneuver in wind conditions beyond the capability of the aircraft.NTSB ATL99LA068Accident · Minor injuriesLimited investigationFinal reportVans RV-6A · Cedar Creek, NCThe soft runway surface.NTSB LAX99LA132Accident · No injuriesLimited investigationFinal reportCessna 172B · Winslow, AZThe pilot's decision to continue flight into known adverse wind conditions which exceeded the ground handling capability of the aircraft.NTSB SEA99LA039Accident · No injuriesLimited investigationFinal reportCessna TU206G · Cascade, IDUnsuitable terrain for landing was selected. Snow covered airstrip was a factor.NTSB CHI99LA080Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Alliance, NEthe unsuitable terrain for landing selected by the pilot-in-command. Factors were the tailwind landing condition and excessive braking by the pilot-in-command.NTSB LAX99TA043Accident · No injuriesFinal reportPiper PA-18-150 · Imperial, CAThe pilot's inadequate compensation for the gusty wind conditions while taxiing from landing.NTSB MIA98LA255Accident · No injuriesLimited investigationFinal reportCessna A185F · Elizabethton, TNThe failure of the pilot to maintain directional control during the landing roll.NTSB ANC98LA160Accident · No injuriesLimited investigationFinal reportPiper PA-18 · New Stuyahok, AKThe pilot's excessive use of brakes during the landing roll.NTSB ANC98LA142Accident · No injuriesLimited investigationFinal reportCessna 170B · Port Alsworth, AKThe solo student pilot's excessive application of brakes during taxi from landing. Factors associated with the accident were the pilot's selection of unsuitable terrain for a precautionary landing, rough terrain, and the fuel leak from the fuel tank vent.NTSB ANC98LA139Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Cordova, AKThe pilot's selection of an unsuitable off airport site for landing. A factor associated with the accident was high vegetation (brush and weeds) in the landing area.NTSB ANC98TA128Accident · No injuriesFinal reportPiper PA-18 · Fairbanks, AKThe pilot's inadequate preflight planning/preparation, and his delay in aborting the takeoff. Factors in the accident were a short runway area for takeoff, trees located at the end of the runway, and the pilot's excessive application of brakes.NTSB SEA98LA165Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Vancouver, WAThe pilots inadequate remedial action, while attempting to recover from an inadvertent activation of the brakes, during the landing-roll. Factors include the inadvertent brake activation and the rough/uneven runway.NTSB SEA98LA168Accident · No injuriesLimited investigationFinal reportCessna 140 · Battleground, WANose Over for undetermined reasons.NTSB CHI98LA325Accident · No injuriesLimited investigationFinal reportCessna 120 · Benton, KSthe pilot's inadvertant excessive use of the toe brakes during the landing roll.NTSB ATL98LA101Accident · No injuriesLimited investigationFinal reportWaco WMF · Chamblee, GAThe pilot's excessive taxi speed and excessive braking action that resulted in a nose over.NTSB SEA98LA137Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Pacific City, ORThe pilot's improper compensation for wind conditions (landing with a tail wind.) Related factors were tail wind conditions, a short runway, and diminished brake system effectiveness.NTSB ATL98LA093Accident · Serious injuriesLimited investigationFinal reportLane Progressive Aerodyne Searey · Windermere, FLThe inadequate design of the landing gear switch by the builder which allowed an inadvertent activation of the landing gear switch, leading to a gear extension during a water landing.NTSB LAX98LA213Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Redding, CAThe pilot's excessive use of the brakes while taxiing, allowing the aircraft to nose over.NTSB CHI98LA202Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Risco, MOthe pilot's abrupt application of the brakes. Factors contributing to this accident were the pilot's inadequate preflight preparation, his delayed decision to abort the takeoff, and the soft field.NTSB ANC98LA072Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Nikiski, AKThe pilot's use of excessive brake application during landing roll.NTSB ATL98LA087Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Pensacola, FLThe pilot's inadvertent activation of the parking brakes which resulted in the nose over during the landing roll.NTSB MIA98LA173Accident · No injuriesLimited investigationFinal reportMejia Bacon II · Winter Haven, FLThe pilot's improper use of brakes on landing rollout.NTSB FTW98LA218Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Dumas, ARThe pilot's improper activation of the parking brake.NTSB CHI98LA117Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-65 · Vernillion, SDthe pilot's failure (or inability) to properly compensate for wind conditions, while taxiing. Factors associated with the accident were: the sandy terrain, and the gusty tailwind condition.NTSB NYC98LA083Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Milford Center, OHthe pilot's excessive application of brakes during an aborted takeoff roll.NTSB MIA98LA108Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Pierson, FLthe pilot's failure to note the windsock before touchdown which resulted in a downwind landing, and the pilot's improper elevator control. Factors were the tailwind and the pilot's complacency.NTSB FTW98LA140Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Lake Village, ARThe pilot's use of unsuitable terrain for takeoff. A factor was the rough/uneven terrain.NTSB SEA98LA032Accident · No injuriesLimited investigationFinal reportCessna 180 · Sun Valley, IDthe pilot's inadvertent actuation of the parking brake.NTSB FTW98LA087Accident · No injuriesLimited investigationFinal reportStarduster SA-100 · Roland, ARThe pilot's inadvertent encounter with soft, wet grass during landing.NTSB NYC98LA054Accident · Minor injuriesLimited investigationFinal reportMayers SEA REY · Gloucester, VAThe pilot's failure to maintain aircraft control during landing, which resulted in a nose over.NTSB LAX98LA051Accident · No injuriesLimited investigationFinal reportLuscombe 8 · Grass Valley, CAthe pilot's inadvertent activation of the aircraft brakes during the landing rollout.NTSB FTW98LA040Accident · No injuriesLimited investigationFinal reportCessna 172G · Elk City, OKThe high winds and the pilot's poor judgment in attempting to taxi in the existing wind conditions.NTSB FTW98LA029Accident · No injuriesLimited investigationFinal reportCessna 185C · Farmington, NMthe pilot's improper preflight of the airplane, by failing to properly set the elevator trim for takeoff, and his improper use use of the elevator flight controls. A related factor was: the pilot's lack of recent experience in the make and model of airplane.NTSB SEA98LA034Accident · No injuriesLimited investigationFinal reportCessna U-206E · Friday Harbor, WAthe pilot's failure to park with the aircraft headed into the wind in high wind conditions. A factor include the high wind condition.NTSB FTW98LA002Accident · Minor injuriesLimited investigationFinal reportBell 206B · New Iberia, LAimproper touchdown by the flight instructor. A related factor was: soft sod in the touchdown/landing area.NTSB ATL97LA146Accident · No injuriesLimited investigationFinal reportCessna 172N · Fuquay-Varina, NCThe pilot's misjudged flare, improper level-off, and improper recovery from a bounced landing.NTSB ANC97LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKbinding or braking action of the left brake for undetermined reason(s).NTSB FTW97LA308Accident · No injuriesLimited investigationFinal reportCessna 182P · Arriba, COfailure of the pilot to properly plan the flight and determine the field conditions before landing. The soft runway condition was a related factor.NTSB ANC97LA116Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Ashton, AKThe pilot's selection of unsuitable terrain. Factors associated with the accident were the tailwind and soft terrain.NTSB FTW97LA283Accident · No injuriesLimited investigationFinal reportWonder RV-6 · Franktown, COthe pilot's failure to maintain control of the aircraft during landing roll. A factor was the uneven runway surface.NTSB SEA97LA134Accident · No injuriesLimited investigationFinal reportCessna 172C · Fall City, WAthe pilot's selection of unsuitable terrain for landing. The soft, wet terrain was a related factor.NTSB SEA97LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · Deer Lodge, MTThe pilot's improper decision to abort the takeoff, and his improper use of brakes during the abort. A factor contributing to the accident was the pilot's failure to maintain directional control during the takeoff roll.NTSB CHI97LA121Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wheeling, ILthe pilot-in-command's inadequate compensation for the wind conditions. A factor associated with the accident was the gusty crosswind condition.NTSB CHI97LA113Accident · No injuriesLimited investigationFinal reportCessna 185 · Pella, IAthe pilot's selection of an unsuitable area for the landing. A factor relating to the accident was: the soft landing surface of the farm strip.NTSB SEA97LA080Accident · No injuriesLimited investigationFinal reportCessna 172 · Auburn, WAthe pilots' inadequate evaluation of the strong winds, when they attempted to turn to taxi with a very strong tailwind. Factors relating to the accident included the high and unfavorable winds.NTSB SEA97LA053Accident · No injuriesLimited investigationFinal reportCessna 170B · Toledo, WAThe pilot's excessive application of the brakes on a tailwheel equipped aircraft. Factors include the pilot's inadequate compensation for wind conditions, and a crosswind blowing at the time of the landing.NTSB NYC97LA008Accident · No injuriesLimited investigationFinal reportCessna 172N · Hilton, NYthe pilot's improper soft field landing technique, which allowed a nose over during the landing rollout. Soft terrain was a related factor.NTSB SEA97LA019Accident · No injuriesLimited investigationFinal reportCessna 170B · Utica, MTThe pilot's improper use of the brakes, while landing a tailwheel aircraft in crosswind conditions. The crosswind was a related factor.NTSB SEA96LA218Accident · No injuriesLimited investigationFinal reportCessna 170 · Enterprise, ORthe pilot's misjudgment of speed and distance during the approach/landing, his failure to attain a proper touchdown point during the landing, and his failure to go around (while there was sufficient runway remaining). The short runway was a related factor.NTSB ANC96LA167Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Noatak, AKThe pilot's selection of unsuitable terrain for landing.