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 CHI01LA253Accident · No injuriesLimited investigationFinal reportCessna 150M · Rapid City, SDThe student solo pilot failed to compensate for the wind conditions. Factors included the high wind, gusts, and tailwind.NTSB SEA01LA142Accident · No injuriesLimited investigationFinal reportCessna 150 · Blackfoot, IDPilot's failure to maintain directional control of the airplane while landing.NTSB IAD01LA079Accident · No injuriesLimited investigationFinal reportBoeing A75L300 · Matawan, NJThe inadequate maintenance inspection of the airplane by its owner, which resulted in a locked brake and a nose-over during the takeoff roll.NTSB ATL01LA084Accident · No injuriesLimited investigationFinal reportFleet BI-PLANE · Homestead, FLThe pilot's improper use of flight controls during a landing on a sod airstrip that resulted in a nose over.NTSB LAX01LA230Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Nixon, NVThe pilot’s failure to attain the proper touchdown point and his misjudged distance/speed during landing rollout. Factors were the tailwind condition and the downhill landing area.NTSB CHI01LA159Accident · No injuriesLimited investigationFinal reportCessna 172M · Middleton, WIThe pilot attempted a touch and go on unsuitable terrain. A factor associated with the accident was the tall wet grass airstrip on which the touch and go was attempted.NTSB SEA01LA103Accident · No injuriesLimited investigationFinal reportPiper J3F-65 · Brush Prairie, WAThe first pilot's failure to maintain aircraft control during a high-speed taxi maneuver. Tall grass adjacent to the runway was a factor.NTSB SEA01LA081Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Seattle, WAThe high wind conditions encountered as the aircraft began its takeoff roll. Contributing factors were the variable and gusty wind conditions.NTSB SEA01LA079Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Summer Lake, ORthe pilot's decision to land on a dry lake bed without first taking action to determine the firmness of the surface. Factors include soft terrain at the location the pilot chose to land.NTSB LAX01LA132Accident · No injuriesLimited investigationFinal reportCessna 170B · Lincoln, CAThe certified flight instructor's inadequate supervision of his dual student who used excessive braking on landing resulting in the airplane's nose over.NTSB FTW01LA056Accident · No injuriesLimited investigationFinal reportNeely B D Kit Fox 4 · Cedar Park, TXthe pilot's excessive braking during the landing roll.NTSB MIA01LA052Accident · No injuriesLimited investigationFinal reportCessna 305A · Morganton, NCThe failure of the pilot to maintain aircraft control about the aircraft's lateral axis during landing rollout, and the resultant nose over.NTSB SEA01LA027Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Gleneden Beach, ORThe pilot's excessive application of main wheel brakes. Factors include the pilot's failure to maintain directional control and his inadequate remedial action during his attempt to regain control.NTSB IAD01LA014Accident · No injuriesLimited investigationFinal reportGick Aerocomp CA6WB · White Post, VAThe pilot's inadequate preflight. Also causal in the accident was the under-inflated tire that flattened and locked during landing, and collapsed the nose landing gear.NTSB SEA01LA020Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Ontario, ORInadequate remedial action by the first pilot. The student pilot's improper flare while landing was a factor.NTSB SEA01LA018Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Great Falls, MTThe pilot's improper decision to land on unsuitable terrain. Factors include snow covered terrain.NTSB SEA01LA013Accident · No injuriesLimited investigationFinal reportCessna 172N · Spangle, WAThe pilot's inadequately executed remedial action and his failure to ensure that the aircraft touched down at the proper location. Factors include a dark night, an unlighted runway, and trees off the approach end of the runway.NTSB SEA01LA006Accident · No injuriesLimited investigationFinal reportCessna 185F · Driggs, IDThe pilot's failure to maintain directional control. Factors include soft terrain adjacent to the runway.NTSB LAX01LA010Accident · No injuriesLimited investigationFinal reportCessna 170B · San Carlos, CAThe pilot's improper and excessive application of brakes resulting from his failure to maintain directional control during landing rollout.NTSB NYC01LA011Accident · No injuriesLimited investigationFinal reportBoeing B75-N1 · Warrenton, VAThe pilot's improper recovery from a bounced landing.NTSB SEA00LA189Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Corvallis, ORThe instructor pilot's delayed remedial action. Factors include the student's failure to properly initiate a flare, and the soft terrain immediately adjacent to the taxiway.NTSB NYC00LA255Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Laconia, NHThe pilot's failure to maintain aircraft control. A factor in the accident was the large wave.NTSB SEA00LA168Accident · No injuriesLimited investigationFinal reportCessna 172B · Sunriver, ORThe pilot's improper decision to continue the takeoff after the aircraft failed to climb or accelerate immediately after the initial liftoff. Factors were inadequate preflight planning, to include the pilot's failure to calculate takeoff performance data,…NTSB SEA00LA167Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A-150 · North Plains, ORThe pilot's excessive use of brakes. Contributing factors were the pilot's misjudgment of distance/speed (landing long and fast) and lack of experience in the make/model of aircraft.NTSB CHI00LA216Accident · No injuriesLimited investigationFinal reportMonocoupe 90A · Creve Coeur, MOthe excessive brakes applied by the second pilot. A factor to the accident was the unavailability of brakes on the flight instructor's side of the aircraft.NTSB ANC00LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Cordova, AKThe pilot's excessive application of the airplane's brakes.NTSB CHI00LA205Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Decatur, MIthe left main landing gear brake was locked during landing. A factor associated with the accident was the uneven terrain on which the landing was made.NTSB CHI00LA199Accident · No injuriesLimited investigationFinal reportCessna 140 · St. Francis, MNthe pilot selected to land in a field that was unsuitable for landing. A factor was the soft field.NTSB NYC00LA194Accident · No injuriesLimited investigationFinal reportCessna 140 · Alliance, OHThe pilot's improper decision to abort the takeoff. A factor in this accident was the dark night conditions.NTSB NYC00LA182Accident · No injuriesLimited investigationFinal reportCessna 180 · Jackson Center, PAA seized left brake as reported by the pilot.NTSB LAX00LA243Accident · No injuriesLimited investigationFinal reportCessna A185F · Marana, AZthe pilot's excessive use of wheel brakes during the landing roll resulting in the airplane's nosing over.NTSB NYC00LA169Accident · No injuriesLimited investigationFinal reportRepublic RC3 · Speculator, NYThe pilot inadvertently lowering the landing gear of the amphibian airplane for a water landing.NTSB FTW00LA177Accident · No injuriesLimited investigationFinal reportStarduster Too SA300 · Spicewood, TXThe pilot's failure to maintain directional control of the airplane during the landing roll. A factor was the muddy terrain condition.NTSB NYC00LA143Accident · No injuriesLimited investigationFinal reportde Havilland DH-82A · Pittsfield, METhe pilot's improper use of unsuitable terrain for landing. A factor in the accident was the soft terrain.NTSB MIA00LA160Accident · Minor injuriesLimited investigationFinal reportDaniel A. Shapiro Searey 1DK · Morganton, NCThe inadvertent forward elevator input by the pilot-in-command while reducing throttle control resulting in the airplane nose-over.NTSB CHI00LA106Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Saint Joseph, MOthe pilot's inadequate compensation for the wind condition. A factor to the accident was the high winds.NTSB SEA00LA047Accident · No injuriesLimited investigationFinal reportCessna 180H · Bozeman, MTAircraft control was not maintained. Inadequate remedial action was a factor.NTSB MIA00LA071Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Deland, FLThe pilot's evasive maneuver during landing roll due to panic after hearing another pilot report landing on the opposite runway resulting in the pilot losing directional control and nosing over in soft terrain. A factor in the accident was the pilot of the…NTSB FTW00LA060Accident · No injuriesLimited investigationFinal reportCessna 172R · Angleton, TXThe pilot's failure to maintain control of the airplane during landing. A factor was the gust of wind.NTSB LAX00LA059Accident · Minor injuriesLimited investigationFinal reportQuest II Walsh Aventura II · Antioch, CAThe pilot's inattention to the fact that he had failed to retract the landing gear wheels prior to performing a water landing.NTSB FTW00TA007Accident · No injuriesFinal reportBell 206B · Slaton, TXThe pilot's initiation of the simulated emergency procedure at a low altitude.NTSB MIA99LA266Accident · No injuriesLimited investigationFinal reportCessna A188B · South Oxford, MSthe pilot's improper use of the brakes during the landing rollout.NTSB NYC99LA233Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Minerva, OHThe pilot's failure to maintain directional control.NTSB NYC99LA232Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT17 · Westminister, MDThe pilot's failure to maintain control of the airplane while taxiing.NTSB SEA99LA163Accident · No injuriesLimited investigationFinal reportStinson V77 · Tacoma, WAThe pilot-in-command's inadvertent use of heavier than normal braking during the landing roll. A contributing factor was the gusty wind conditions.NTSB DEN99LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Lamar, COThe left brake locked during takeoff roll for undetermined reasons.NTSB NYC99LA158Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Marston Mills, MAThe inadvertent control interference of the airplane's brakes by the passenger. A factor related to the accident was the pilot in commands insufficient passenger briefing.NTSB DEN99LA111Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Boulder, COThe pilot's failure to maintain control of the aircraft during landing roll.NTSB FTW99LA157Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Monaville, TXThe pilot's failure to touch down on the dry area of the landing strip. A factor was the soft terrain condition on the sides of the grass strip.NTSB DEN99LA073Accident · Minor injuriesLimited investigationFinal reportDavis RV-6A · Truth Or Cnsqnc, NMA soft runway surface that caused the airplane to nose over.