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 CHI96LA352Accident · No injuriesLimited investigationFinal reportCessna 172RG · Aurora, ILundetermined.NTSB ANC96FA139Accident · 1 fatalField investigationFinal reportCessna 206 · Yakutat, AKThe pilot's landing on the water with the landing gear inadvertently extended.NTSB LAX96LA243Accident · No injuriesLimited investigationFinal reportMini Ace CA61-F · Byron, CAThe pilot's encounter with a sudden crosswind gust beyond the capabilities of the aircraft.NTSB ANC96LA091Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe flight instructor's excessive application of the brakes during the landing roll. A factor in the accident was the flight instructor's restricted view of the landing area.NTSB LAX96LA225Accident · No injuriesLimited investigationFinal reportCessna 150H · Angels Camp, CAThe attempt by the pilot to operate the aircraft with a float known to be leaking. A factor was the pilot's lack of experience in the operation of float equipped aircraft.NTSB SEA96LA109Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Richland, WAthe pilot's failure to perform a go-around and his subsequent excessive use of the aircraft brakes. The short airstrip length and the pilot's excessive airspeed for the approach were related factors.NTSB SEA96LA108Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Rimrock, WAthe pilot's delay in aborting the takeoff, and his excessive use of brakes while decelerating the airplane during the aborted takeoff. Factors relating to the accident were: the pilot's loading the airplane above its maximum gross weight, high density…NTSB MIA96LA156Accident · No injuriesLimited investigationFinal reportMarcellus Star Fire · Umatilla, FLThe pilot's improper use of brakes on landing roll out resulting in a nose over.NTSB CHI96LA143Accident · No injuriesLimited investigationFinal reportCessna 172 · Terre Haute, INthe pilot's improper planning/decision, which resulted in his inadequate compensation (or inability to compensate) for the wind condition. The high/gusty wind condition was a related factor.NTSB ANC96LA050Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKimproper planning/decision by the pilot, and his selection of unsuitable terrain on which to land a ski equipped airplane.NTSB SEA96LA086Accident · No injuriesLimited investigationFinal reportCessna 150F · Plains, MTthe pilot's excessive use of brakes during the landing rollout.NTSB ANC96LA055Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Paxson, AKthe student pilot's selection of an unsuitable off airport landing site. Factors associated with the accident were the soft and snow covered terrain.NTSB IAD96LA059Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Waynesville, OHThe pilot's failure to maintain control of the accident aircraft during the landing roll. Factors were the wet portion of the grass runway and the pilot's selection of a landing runway with a 10 knot quartering tailwind.NTSB IAD96LA051Accident · No injuriesLimited investigationFinal reportMulholland Witchawk · Celina, OHthe pilot's selection of unsuitable terrain for a precautionary landing.NTSB CHI96LA106Accident · No injuriesLimited investigationFinal reportCessna 172E · Tofte, MNthe pilot's failure to perform adequate preflight planning which resulted in landing at a closed airport. The snow covered runway was a factor.NTSB NYC96LA068Accident · No injuriesLimited investigationFinal reportCessna 172M · Bedford, MAthe flight instructor's inadequate supervision of the flight, the pilot's improper compensation for the wind conditions, and the high wind. The instructor's inadequate evaluation of the weather was a contributing factor.NTSB CHI96LA100Accident · No injuriesLimited investigationFinal reportCessna 172 · Ankeny, IAthe pilot's poor judgment in attempting flight operations in the existing wind condition, and the high gusting wind.NTSB ANC96LA028Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Cooper Landing, AKthe pilot's selection of unsuitable terrain for landing. Soft snow conditions were a factor in the accident.NTSB SEA96LA051Accident · No injuriesLimited investigationFinal reportMadorin Kitfox III · Grantsville, UTthe pilot's selection of an unsuitable area for a precautionary landing. A factor was the snow covered terrain.NTSB ANC96LA170Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKThe pilot's selection of an unsuitable site for landing. A factor associated with the accident is the snow-covered terrain.NTSB NYC96LA045Accident · No injuriesLimited investigationFinal reportCessna 150J · Kutztown, PAthe student pilot's selection of an unsuitable runway for landing. The snow covered runway was a related factor.NTSB LAX96LA070Accident · No injuriesLimited investigationFinal reportCessna 208B · Sacramento, CAthe pilot was given an erroneous wind velocity due to a malfunctioning wind gauge in the control tower. Factors relating to the accident were: the high/gusty wind conditions, and the pilot's improper evaluation of the actual wind condition.NTSB NYC96LA030Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Kutztown, PAthe pilot's improper use of brakes during the landing roll resulting in the airplane nosing over.NTSB BFO96LA025Accident · No injuriesLimited investigationFinal reportSellors Kitfox IV · Pasadena, MDThe pilot's improper (abrupt) application of brakes during the landing roll. Factors relating to the accicent were: the pilot's failure to attain the proper touchdown point during the landing, and his lack of experience in the make and model of airplane.NTSB SEA96LA018Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Seeley Lake, MTThe pilot's selection of unsuitable terrain for landing. The snow covered runway was a factor.NTSB SEA96LA017Accident · No injuriesLimited investigationFinal reportPiper PA-22 · La Grande, ORThe pilot's poor judgment in attempting flight in the existing wind conditions.NTSB ANC96TA011Accident · Minor injuriesFinal reportBellanca 8GCBC · Fairbanks, AKThe pilot's inadequate recovery from a bounced landing. The snow-covered landing surface and the pilot's decision not to perform a go-around were factors.NTSB ANC96LA010Accident · No injuriesLimited investigationFinal reportCessna 185 · Kodiak, AKThe check pilot's inadequate compensation for wind conditions. Factors relating to the accident were: the rough water and adverse wind conditions.NTSB FTW96LA023Accident · No injuriesLimited investigationFinal reportCessna 172D · Pryor, OKThe high wind and the pilot's poor judgment in attempting the flight.NTSB FTW96LA015Accident · Minor injuriesLimited investigationFinal reportAdams Kitfox · Seminole, TXthe pilot's excessive braking.NTSB ANC96LA004Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKImproper planning/decision by the pilot concerning his method of testing the landing area. His selection of an unsuitable area was a related factor.NTSB FTW96LA006Accident · No injuriesLimited investigationFinal reportDonegan Benton Kitfox II · Seguin, TXthe pilot's improper braking technique.NTSB ANC95LA145Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Skwentna, AKThe pilot's improper planning/decision. A factor relating to the accident was: the pilot's selection of a short/uneven landing area that required excessive braking action while landing with a tailwind.NTSB NYC95LA186Accident · No injuriesLimited investigationFinal reportCessna 150E · West Addison, VTThe pilot's selection of an unsuitable landing area. A factor is a soft landing area.NTSB ATL95LA133Accident · No injuriesLimited investigationFinal reportCessna 172 · Bayboro, NCThe pilot's inadequate procedure in that he elected to land the aircraft on unsuitable terrain with no mechanical malfunctions.NTSB ANC95LA096Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Homer, AKThe pilot's improper (excessive) use of the brakes after the airplane crested the landing site's crown and started downhill.NTSB SEA95LA115Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Medford, ORAn unreliable fuel quantity gage and an inadequate preflight. The tall vegetation in the landing area was a factor.NTSB ANC95LA064Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Big Delta, AKThe pilot's failure to maintain proper alignment with the landing surface. A factor relating to the accident was: the rough/uneven landing surface.NTSB SEA95LA100Accident · No injuriesLimited investigationFinal reportBoeing E75 · Newberg, ORThe pilot's improper use of the aircraft brakes. Contributing to the accident was the pilot's decision not to perform a go-around, which resulted in failure to attain the desired touchdown point on landing.NTSB ANC95TA054Accident · No injuriesFinal reportBellanca 8GCBC · Fairbanks, AKThe pilot's failure to verify the position of the parking brake knob prior to landing.NTSB FTW95LA192Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M-18A Dromader · Gerome, ARThe pilot's use of unsuitable terrain for landing.NTSB LAX95LA166Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Chino, CAfailure of the attachment link for the master cylinder return spring, which allowed the left brake to lock.NTSB ANC95GA083Accident · No injuriesFinal reportPiper PA-18 · Copper Center 2, AKThe pilot not using the checklist and landing with the skis pumped down.NTSB BFO95LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Allentown, PAthe pilot's inadequate compensation for wind conditions. Related factors were the gusty wind conditions and the pilot's poor weather evaluation.NTSB SEA95LA073Accident · No injuriesLimited investigationFinal reportFleet 7 · Arlington, WAThe pilot-in-command's improper use of the brakes. A factor was the failure to maintain directional control during landing rollout.NTSB NYC95LA062Accident · No injuriesLimited investigationFinal reportCessna 172L · Saratoga Spgs, NYThe pilot's poor judgment in attempting a flight under the existing wind conditions.NTSB SEA95LA047Accident · No injuriesLimited investigationFinal reportCessna 120 · Scappoose, ORThe pilot's improper recovery from a bounced landing and inadvertent use of the brakes.NTSB SEA95LA036Accident · No injuriesLimited investigationFinal reportCessna 172G · Salt Lake City, UTThe pilot's inadequate compensation for wind conditions during runup. The unfavorable wind was a factor.NTSB LAX95LA071Accident · No injuriesLimited investigationFinal reportCessna 175 · Davis, CAthe failure of the pilot to maintain directional control of the aircraft while on the rollout phase of landing on a dirt road. A factor in the accident was the pilot's intentional selection of the road as a landing site.NTSB CHI95LA059Accident · No injuriesLimited investigationFinal reportAmerican Champion Citabria 7-GCBC · Ulysses, KSthe pilots improper use of brakes during practice landings, and his lack of total experience in tail wheel equipped airplanes.