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 SEA91LA140Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Newcastle, WYThe fracture failure of the landing gear axle.NTSB LAX91LA271Accident · No injuriesLimited investigationFinal reportClassic YMF · Bullhead City, AZExcessive brake application by the pilot in command. A contributing factor in the accident was the wind gusts.NTSB CHI91LA187Accident · No injuriesLimited investigationFinal reportGrumman American AA1C · Lansing, KSThe pilot became lost/disoriented and attempted a precautionary landing. Factors related to the accident were a low level of fuel and soft terrain (wheat field crop).NTSB ANC91LA070Accident · No injuriesLimited investigationFinal reportCessna 180 · Near Iliamna, AKThe pilot's decision to land on an unimproved area. The soft terrain was a related factor.NTSB ANC91LA069Accident · No injuriesLimited investigationFinal reportCessna 206 · Kahiltna River, AKThe pilot's excessive descent and lack of familiarity with the aircraft. Contributing to the accident was the soft condition of the sand bar.NTSB ANC91LA053Accident · No injuriesLimited investigationFinal reportCessna 172 · Cantwell, AKThe pilot in command's poor preflight planning/preparation. A factor in the accident was the snow covered runway.NTSB CHI91LA132Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Fibre, MIThe pilot attempting to taxi on unsuitable terrain.NTSB BFO91LA043Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Morehead, KYThe pilot's operation of his aircraft in exceedingly high wind conditions.NTSB ATL91LA079Accident · No injuriesLimited investigationFinal reportCessna 120 · Pinebluff, NCThe pilot's delay in aborting the takeoff. The pilot's failure to calculate the aircraft's performance for the existing conditions was a factor related to the accident.NTSB ANC91LA048Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's lack of currency with the type of landing gear involved.NTSB LAX91LA153Accident · No injuriesLimited investigationFinal reportPiper J3 · Arbuckle, CAThat the pilot used excessive brakes during the landing roll-out.NTSB LAX91LA119Accident · No injuriesLimited investigationFinal reportCessna 172G · Reno, NVThe pilot's improper planning/preparation decision. Factors related to the accident were the high wind condition and the pilot in commands inability to compensate for the wind condition.NTSB CHI91LA069Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Ashland, NEThe pilot's failure to maintain clearance above the terrain. Factors related to the accident were the low pass and ostentatious display.NTSB CHI91LA024Accident · No injuriesLimited investigationFinal reportCessna 180 · Northwood, NDPoor in-flight planning and decision, unsuitable terrain selected by the PIC.NTSB SEA90LA185Accident · No injuriesLimited investigationFinal reportCessna 180A · Paisley, ORPilot's selection of unsuitable terrain for a landing site.NTSB SEA90LA173Accident · No injuriesLimited investigationFinal reportCessna 172P · Granite Falls, WAThe pilot in command's use of excessive flaps for takeoff resulting in loss of climb performance.NTSB CHI90LA216Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Salisbury, MOProper touchdown point not attained and go-around not performed by the PIC.NTSB NYC90LA188Accident · No injuriesLimited investigationFinal reportCessna 150M · Rochester, NHUndetermined.NTSB DEN90DQA02Accident · No injuriesFinal reportGrumman G-164A · Deming, NMFailure of the pilot to maintain control during landing roll due to the condition of the runway. Contributing to the accident was the poor maintenance of the runway surface.NTSB ANC90LA127Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kustatan River, AKThe pilot selected unsuitable terrain for landing. The terrain was a contributing factor.NTSB ATL90LA143Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Fort Payne, ALThe pilot's selection of a runway which afforded a tailwind, and his improper use of the elevator control during the landing roll.NTSB ANC90LA113Accident · No injuriesLimited investigationFinal reportCessna 180B · Butterfly Lake, AKThe pilot failed to retract the airplane's wheel prior to a water landing. Contributing factors are his failure to follow established procedures/directives, and habit interference caused by his concern over an air traffic conflict during the preceding takeoff.NTSB NYC90LA136Accident · Minor injuriesLimited investigationFinal reportClassic Waco · Plymouth, CTThe failure of the pilot to correctly recover from a bounced landing. Factors related to the accident were: improper use of the brakes by the pilot.NTSB ANC90LA092Accident · No injuriesLimited investigationFinal reportCessna 185-A · Anchorage, AKFailure of the right main gear torque plate causing an uncontrollable landing roll out.NTSB MKC90LA125Accident · No injuriesLimited investigationFinal reportCessna 205 · Jonesburg, MOThe pilot in commands failure to attain a touchdown on the runway resulting in touchdown to the side of the runway and a nose over in soft terrain.NTSB FTW90DPA04Accident · No injuriesFinal reportBoeing A75N1 · Longview, TXThe pilot's abrupt use of the wheel brakes during the landing roll.NTSB DEN90LA117Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Morgan, UTPilot's improper use of the brakes during landing roll.NTSB ANC90LA080Accident · No injuriesLimited investigationFinal reportInterstate S1B1 · Beluga River, AKThe pilot selected unsuitable terrain. Contributing factors were the soft terrain and the pilot's lack of experience in off-airport operations.NTSB BFO90LA047Accident · No injuriesLimited investigationFinal reportRobinson R-22M · Stevensville, MDThe pilot failed to maintain control while taxiing on turbulent water.NTSB ANC90LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nenana, AKThe main wheels (or brakes) had locked for an unknown reason.NTSB ANC90LA059Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cordova, AKThe pilot's improper planning/decision, which resulted in a nose-over of the aircraft when it encountered a wave from a boat during the takeoff run.NTSB MKC90LA080Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mounds, ARThe pilot's improper compensation for wind conditions. Factors related to the accident were: the pilot's selection of the wrong runway and the resultant tailwind condition.NTSB LAX90DVG03Accident · Serious injuriesFinal reportSmyth Sidewinder Smyth · Georgetown, CAThe failure of the pilot to abort his landing and execute a go-around.NTSB ATL90LA085Accident · No injuriesLimited investigationFinal reportCessna 172K · Columbus, OHImproper planning/decision by the pilot. A factor related to the accident was: the adverse wind condition.NTSB LAX90LA103Accident · No injuriesLimited investigationFinal reportPitts S1T · Ramona, CAThe pilots loss of directional control during landing.NTSB LAX90DUG03Accident · No injuriesFinal reportGroves Cougar · Banning, CAPilot's improper wind evaluation and improper aircraft handling after landing. The tailwind and wind gusts were factors relating to the accident.NTSB ANC90LA031Accident · No injuriesLimited investigationFinal reportCessna 185 · Willow, AKSelection of an unsuitable landing area (unsuitable terrain) by the pilot. Factors related to the accident were: deep snow on the runway and failure of the flight service station (fss) specialist to inform the pilot that the runway was closed to wheel…NTSB LAX90LA064Accident · No injuriesLimited investigationFinal reportCessna 185 · Agua Dulce, CAPilot's improper weather evaluation which directly led to his attempted takeoff in an excessive tailwind and subsequent loss of aircraft control during the unsuccessful abort.NTSB ANC90LA016Accident · No injuriesLimited investigationFinal reportCessna 180 · Alexander Lake, AKSelection of unsuitable terrain by the pilot. The snow covered terrain was a related factor.NTSB LAX90LA043Accident · No injuriesLimited investigationFinal reportCessna 140 · Concord, CAImproper use of the brakes by the pilot. The crosswind and the pilot's failure to maintain runway alignment were contributing factors.NTSB DEN90LA018Accident · No injuriesLimited investigationFinal reportCessna U206B · Billings, MTImproper planning/decision by the pilot while taxiing during unfavorable wind conditions.NTSB NYC90LA020Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Lowell, MAThe failure of the pilot to assure that the float wheels were retracted prior to a water landing. A contributing factor was the extension of the left float wheels for an undetermined reason.NTSB SEA90LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182D · Reno, NVThe inadequate compensation for gusty wind conditions.NTSB CHI90LA007Accident · No injuriesLimited investigationFinal reportCessna 140A · Peoria, ILInadequate compensation for wind conditions by the pilot. The tailwind, the pilot's improper use of brakes, and his lack of recent experience in the type of aircraft were considered to be contributing factors.NTSB NYC90LA007Accident · No injuriesLimited investigationFinal reportCessna 185F · Rockwood, METhe pilot's improper compensation for the gusting crosswind. Contributing factor(s) was: the wind conditions and the pilot's selection of a touchdown point.NTSB ATL90LA004Accident · No injuriesLimited investigationFinal reportCessna 170 · Mooresville, NCImproper in-flight planning/decision by the pilot, which resulted in his failure to attain the proper toughdown point on the unidirectional runway. Factors related to the accident were: the unfavorable wind and terrain conditions.NTSB ANC89LA167Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Nenana River, AKImproper planning/decision by the pilot. A factor related to the accident was: the adverse weather condition.NTSB ANC89LA156Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3 · Sheenjek River, AKFailure of the pilot to go around when he was unable to attain the proper touchdown point and his excessive application of brakes during the landing. Contributing factors were: the downdraft, excessive remedial action, and soft terrain.NTSB ANC89LA153Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Gulkana, AKThe pilots improper use of brakes during the landing roll.NTSB ANC89LA152Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKImproper planning/decision by the plt. Contributing factors were rough terrain, rain, high density altitude, tailwind, gusts, and the pilot's improper use of brakes.