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 LAX93LA156Accident · No injuriesLimited investigationFinal reportCessna 182F · Chandler, AZThe pilot's inadequate weather evaluation resulting in an inadvertent encounter with gusty wind conditions while taxiing.NTSB BFO93LA037Accident · No injuriesLimited investigationFinal reportCessna 182Q · Gettysburg, PAThe pilot's inadequate in-flight decision to land on the snow covered runway that was not currently maintained. Contributing to the pilot's decision was the inadequate report of the runway's condition.NTSB CHI93LA084Accident · No injuriesLimited investigationFinal reportPiper PA-12 · White Bear Lake, MNThe pilot selected unsuitable terrain for landing. The snow covered runway was a factor.NTSB SEA93LA065Accident · No injuriesLimited investigationFinal reportCessna 182C · Huntington, UTThe improper in flt decision by the pilot in command to land on an airstrip unsuitable for landing. A factor relating to the accident was the soft snow covering the airstrip.NTSB SEA93GA049Accident · No injuriesFinal reportPiper PA-18-135 · Council, IDThe pilot's failure to maintain proper altitude during the low pass. The snow covered terrain and the pilot's inadequate preflight preparation were factors.NTSB ANC93LA023Accident · No injuriesLimited investigationFinal reportDe Havilland DHC2 · Two Moon Bay, AKAn inadvertant landing gear extension and wheels down water landing by the pilot in command. A factor relating to the accident was the lack of checklist use by the pilot.NTSB SEA93LA037Accident · No injuriesLimited investigationFinal reportMaule M5-180C · Garden Valley, IDInadequate preflight planning and preparation. Factors include the snow covered runway.NTSB NYC93LA038Accident · 1 fatalLimited investigationFinal reportHelio H-700 · Shelton, CTThe pilot's failure to check the position of the landing gear before attempting a water landing.NTSB MIA93LA024Accident · No injuriesLimited investigationFinal reportCessna 182B · Aberdeen, NCThe improper in flight decision of the pilot in command to attempt a long landing, downwind on a short wet sod runway. Contributing to the accident was the failure of the pilot in command to execute a go around when observing the wind and landing conditions.NTSB LAX93LA034Accident · No injuriesLimited investigationFinal reportCessna 195 · El Cajon, CAThe pilot's improper use of the brakes.NTSB ATL93LA020Accident · No injuriesLimited investigationFinal reportMaule M4-210C · Pickens, SCThe pilot's failure to follow normal before takeoff procedures which included placing the propeller lever in the high RPM low pitch position. The pilot also delayed in aborting the takeoff attempt and applied hard braking which resulted in a nose over.NTSB CHI93LA023Accident · No injuriesLimited investigationFinal reportCessna 140 · Waverly, IAThe pilot's excessive application of brakes during landing roll.NTSB ANC93LA002Accident · No injuriesLimited investigationFinal reportCessna A185E · Admiralty Isl, AKThe pilot's selection of unsuitable terrain. A factor related to the accident was: the soft sand.NTSB SEA92LA208Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Gates, ORThe excessive application of the brakes by the pilot in command. Factors contributing to the accident were the tailwind and the pilots visual (mis)perception of runway gradient.NTSB ANC92LA171Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Totatlanika Rvr, AKThe pilot's poor inflight planning/decision in evaluating and selecting unsuitable terrain for the landing area. Factors contributing to the accident were: snow covered terrain, and the pilot's lack of recent experience in this type of operation.NTSB BFO92LA147Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Rochester, MAThe pilot's abrupt application of the brakes which resulted in the airplane nosing over.NTSB SEA92LA190Accident · Serious injuriesLimited investigationFinal reportWSK PZL Mielec M-18A Dromader · Mattawa, WAThe inadvertent locking of the acft brakes while landing by the PIC, resulting in an acft nose over on the gravel strip.NTSB CHI92LA246Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Chillicothe, MOThe pilot's improper use of the airplanes brakes.NTSB SEA92LA174Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Paul, IDThe pilot's selection of unsuitable terrain. The soft terrain was a factor.NTSB SEA92LA171Accident · No injuriesLimited investigationFinal reportBoeing B-75 · Three Forks, MTThe pilot's failure to maintain directional control. Factors include a crosswind gust.NTSB BFO92LA117Accident · No injuriesLimited investigationFinal reportRobinson R22A · Sanford, METhe pilot's selection of unsuitable terrain to execute a landing.NTSB CHI92LA205Accident · No injuriesLimited investigationFinal reportCessna 180H · Blaine, MNThe pilot's inadvertent activation of wheel brakes.NTSB NYC92LA115Accident · No injuriesLimited investigationFinal reportCessna 140 · Wauseon, OHThe pilot improperly used the brakes, resulting in the airplane nosing over.NTSB DEN92LA058Accident · No injuriesLimited investigationFinal reportCessna 185 · Durango, COImproper use of brakes. Factors were: poorly planned approach and excessive landing speed.NTSB SEA92LA106Accident · No injuriesLimited investigationFinal reportCessna A185F · Spray, ORThe pilot's selection of unsuitable terrain for landing. Factors include soft and uneven terrain.NTSB CHI92LA156Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Greenwood, ILExcessive application of the brakes during landing roll.NTSB ANC92LA073Accident · No injuriesLimited investigationFinal reportCessna C-150K · Beluga, AKThe improper inflt decision by the pilot to land on a remote, private, snow covered airstrip. A factor relating to the accident was the soft, wet snow on the strip.NTSB SEA92LA090Accident · No injuriesLimited investigationFinal reportCessna 172N · Parkdale, ORThe pilot's failure to use the proper touchdown point for landing. A factor relating to the accident was the soft dirt runway surface.NTSB ANC92LA054Accident · No injuriesLimited investigationFinal reportCessna A185F · Fairbanks, AKPoor in flight planning/decision. Factors to the accident were: snow covered terrain, and wrong runway not identified.NTSB FTW92LA090Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Roanoke, LAThe locking of the main landing gear brakes.NTSB BFO92LA040Accident · No injuriesLimited investigationFinal reportCessna 180C · Clarence, NYThe pilot's inadequate inflight decision to land with a defective ski landing gear on unsuitable terrain, which resulted in a nose over.NTSB FTW92LA078Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gillette, ARThe unsuitable terrain selected by the pilot.NTSB SEA92LA048Accident · No injuriesLimited investigationFinal reportCessna 172P · Nordman, IDThe pilot selected unsuitable terrain. Factors contributing to the accident were: the snow covered runway, and the pilot in command's inadequate preflight planning.NTSB SEA92LA043Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-65 · West Jordan, UTThe pilot in command's failure to maintain control of the aircraft. A factor contributing to the accident was gusty wind conditions.NTSB SEA92LA032Accident · No injuriesLimited investigationFinal reportCessna 185 · Stanley, IDThe pilot-in-command's selection of unsuitable terrain (snow covered runway) for landing resulting in a nose over on landing rollout.NTSB LAX92LA072Accident · No injuriesLimited investigationFinal reportCessna 172K · Kamuela, HIThe pilots encounter with a wind gust beyond the ground handling capability of the aircraft and his failure to obtain preflight weather information.NTSB SEA92LA021Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Ocean Shores, WAThe pilot's misjudgement of wind information. A factor contributing to the accident was high wind conditions.NTSB SEA92LA008Accident · No injuriesLimited investigationFinal reportMcholland XPA-11 · Sandpoint, IDA poor in-flight decision. Contributing to the accident was the rough/uneven terrain.NTSB ANC92LA004Accident · No injuriesLimited investigationFinal reportCessna 170B · Chugiak, AKThe student pilot's failure to maintain directional control during the takeoff run.NTSB ATL91LA174Accident · No injuriesLimited investigationFinal reportCessna 150J · Wilsonville, ALThe pilot's inadequate preflight planning, and his improper use of flaps during the takeoff roll. Factors in the accident were: the high density altitude, the rising runway conditions, and the departure end obstructions at the airstrip.NTSB SEA91LA232Accident · No injuriesLimited investigationFinal reportCessna 140 · Gates, ORThe student pilot's excessive remedial action. Factors to the accident were poor supervision by the CFI.NTSB SEA91LA244Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Metaline Falls, WAThe pilot's inadvertent use of the parking brake. A factor contributing to the accident was the absence of the parking brake on the landing checklist.NTSB MIA91LA215Accident · No injuriesLimited investigationFinal reportBell 47G2A · Immokalee, FLThe improper use of the flight controls by the pilot in command, which resulted in a collision with the ground and a nose over.NTSB CHI91LA288Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Afton, MNThe pilot's inadvertent lowering of the wheels during the water landing.NTSB ANC91LA139Accident · No injuriesLimited investigationFinal reportCessna 206 · Kelly River, AKThe pilot's inadequate judgment in deciding to land a tricycle gear airplane on a sandbar.NTSB NYC91LA216Accident · No injuriesLimited investigationFinal reportCessna TU206G · Block Island, RIImproper planning/decision by the pilot by electing to takeoff with a known deficiency with the equipment. The deficiency (cracked/leaking float) was a related factor.NTSB ATL91LA137Accident · No injuriesLimited investigationFinal reportCessna 182 · Jenkinsburg, GAThe separation of the nose wheel, during the landing roll, for undetermined reasons.NTSB LAX91LA299Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Crows Landing, CAThe pilot Landing his airplane erroneously on the wrong Landing surface. Factors in this accident were: sunglare and its interference with the pilot's vision and the soft terrain.NTSB BFO91LA066Accident · No injuriesLimited investigationFinal reportCessna 175B · Farmington, MDAn aborted takeoff due to the pilot's reported binding of the elevator.NTSB ANC91LA083Accident · No injuriesLimited investigationFinal reportCessna 170B · Lake Louise, AKThe pilot not maintaining directional control during the takeoff roll. Contributing to the accident was the rough condition of the airstrip.