NTSB investigations
1,048 cases where the first occurrence was “On ground/water encounter with terrain/water”.
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\" = 320) 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" = 320) 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 NYC90LA172Accident · Serious injuriesLimited investigationFinal reportCessna C-152A · Yellowsprings, OHLoss of control when the pilot stalled the airplane after prematurely becoming airborne. Contributing to the accident was a rough field and a hidden obstruction.NTSB DEN90LA157Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Clarkston, UTJammed ailerons resultant from the collision with crops.NTSB DEN90LA150Accident · No injuriesLimited investigationFinal reportCessna T 188C · Wray, COThe failure of the pilot to maintain proper alignment proper alignment during landing.NTSB NYC90LA138Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Lancaster, PAThe pilot's selection of an unsuitable landing site. Contributing to the accident was the pilots decision to land in a field with insufficient space available.NTSB SEA90LA109Accident · No injuriesLimited investigationFinal reportMaule M-5 · Riverside, ORThe pilot's selection of unsuitable terrain for a landing site and his inadequate compensation for the wind condition. Factors related to the accident were: the tailwind and the ditch.NTSB SEA90LA103Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Tekoa, WAFailure of the pilot to maintain clearance between the airplane and tall grass adjacent to the gravel strip.NTSB FTW90LA117Accident · No injuriesLimited investigationFinal reportBoeing E75 · Watonga, OKPic's failure to use all of the available runway. A factor was the high density altitude.NTSB BFO90LA051Accident · No injuriesLimited investigationFinal reportCessna 172P · Chesterfield, VAThe student pilot's improper compensation for wind conditions and failure to maintain runway alignment.NTSB ATL90IA123Incident · No injuriesIncident investigationFinal reportBeech BE-18 · Anderson, SCThe pilot's failure to ensure adequate clearance while taxiing to the ramp. A factor in the incident was a dark, unlighted ramp area.NTSB NYC90LA102Accident · No injuriesLimited investigationFinal reportCessna 152 · West Milford, NJImproper planning/decision by the flight instructor (CFI). Related to the accident was the cfi's lack of experience as an instructor.NTSB LAX90LA161Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Santa Rosa, CAThe pilot's improper recovery from a bounced landing.NTSB BFO90LA040Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Have De Grace, MDThe pilot failed to maintain directional control, and used excessive braking trying to regain control.NTSB MKC90LA099Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Lockwood, MOTouchdown point not attained and go-around not performed by the pilot in command. Contributing factors were a wet, grass runway.NTSB LAX90FA148Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-10-10F · Los Angeles, CAPilot failed to adhere to established landing procedures, maintain a stabilized approach, and allowed the airspeed to go below the predicted v.NTSB MKC90LA076Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Newport, ARFailure of the pilot to maintain proper runway alignment, which resulted in an encounter with soft/wet (muddy) terrain and a subsequent nose over of the aircraft.NTSB LAX90LA122Accident · No injuriesLimited investigationFinal reportBoeing 737-300 · Santa Ana, CAThe pilot's improper rotation during takeoff.NTSB LAX90LA077Accident · No injuriesLimited investigationFinal reportCessna 182Q · Watsonville, CAThe pilot's inadequate visual lookout.NTSB CHI90LA088Accident · No injuriesLimited investigationFinal reportMitsubishi MU-300 · Gary, INFailure of snow removal personnel to recognize the potential hazard of the snow ridge on the runway and communicate this information to the control tower. Factors related to the accident were: the runway/terrain/light conditions, and failure of airport…NTSB LAX90LA100Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Fresno, CAThe pilot's improper handling of the airplane during taxi.NTSB MKC90LA055Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Columbia, MOExcessive taxi speed and inadequate visual outlook by the pilot. Factors related to the accident were: dark night and the ditch.NTSB LAX90LA099Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Big Bear, CAThe pilot's failure to maintain adequate clearance between the aircraft wing tip and the snow bank. A factor in the accident was the snow berms alongside the runway.NTSB DEN90LA046Accident · No injuriesLimited investigationFinal reportBoeing 757-222 · New York, NYOverrotation of the aircraft during takeoff. Factors related to the accident were: the first officer's improper use of the flight manual, which resulted in his improper calculations of the rotation speed, and inadequate supervision concerning verification of…NTSB ANC90LA026Accident · No injuriesLimited investigationFinal reportCessna 207A · Nondalton, AKImproper planning/decision by the pilot. Factors related to the accident were: inadequate positioning of the temporary runway markers, snow covered runway/terrain conditions, partial whiteout condition, and the snow berms at the edges of the runway.NTSB NYC90DFJ01Accident · No injuriesFinal reportSteele Acrosport II · Penn Yan, NYFailure of the pilot to maintain directional control during the takeoff ground run. His lack of experience & the snowbank were related factors.NTSB CHI90LA052Accident · No injuriesLimited investigationFinal reportCessna 172P · Middletown, OHThe inability to establish a sufficient climb after takeoff. Contributing to the accident was the pilot's lack of total experinece in this type of aircraft.NTSB BFO90FA012Accident · No injuriesField investigationFinal reportBritish Aerospace BAE 3101 · Staunton, VAThe pilot's failure to properly align the airplane with the runway heading during the takeoff run. Factors related to the accident were: airport personnel's failure to assure that runway marking and edge lights were adequately cleared of snow, adverse…NTSB ANC90LA028Accident · No injuriesLimited investigationFinal reportCessna 182 · Chakachamna Lk, AKInadequate preflight preparation of the takeoff area by the pilot, and his attempt to take off on unsuitable terrain. The soft/snow covered terrain was considered to be a contributing factor.NTSB SEA90LA022Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Boulder City, NVThe pilot did not attain proper alignment with the runway. Contributing to the accident was the ditch and the pilot's diverted attention.NTSB ANC90LA008Accident · No injuriesLimited investigationFinal reportCessna 140 · Fairbanks, AKPilot's failure to assure condition of runway prior to landing and failure to maintain runway alignment during landing.NTSB ATL90LA021Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Lafayette, GAThe pilot's failure to abort the takeoff, when the airplane began to veer left during the takeoff roll. Contributing to the accident was the pilot's failure to inspect the airplane wheel for damage after it dropped off the runway during taxi.NTSB CHI90LA018Accident · No injuriesLimited investigationFinal reportBeech A36 · Lansing, ILPilot's poor judgement in electing to taxi across an unmarked area in dark night conditions, at an airport with known construction in progress and the airport management's failure to assure the initial repairs were sufficient to correct the holes made during…NTSB FTW90LA009Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Addison, TXThe pilot's decision to continue the taxi during dark night conditions without taxiway lights, an operable landing light or, assistance from airport personnel.NTSB ANC90LA004Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Montague Island, AKSelection of unsuitable terrain by the pilot. Contributing factors were: rough terrain, gusty winds, high vegetation, and trees.NTSB ANC89LA157Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Igushik, AKThe pilot selected unsuitable terrain for a landing. Soft terrain was a contributing factor.NTSB ANC89LA158Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Trading Bay, AKSelection of unsuitable terrain (landing area) by the pilot. Contributing factors were: improper information provided by other personnel and a hidden obstruction (log) in tall vegetation (grass).NTSB ANC89LA154Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Iliamna, AKThe pilot's selection of unsuitable terrain for an off-airport operation. Factors related to the accident were: the adverse terrain conditions.NTSB MIA89FA237Accident · 1 fatalField investigationFinal reportEagle DW-1-220 · Oklawaha, FLThe loss of control on the ground during the landing roll for undetermined reasons.NTSB ANC89LA149Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Fairbanks, AKThe pilot was taxiing too fast to negotiate a bend in the river. Trees & the river bank were contributing factors.NTSB NYC89LA191Accident · No injuriesLimited investigationFinal reportCessna 421C · Waterville, MEImproper planning/decision by the pilot, his failure to obtain NOTAMS, and failure of the approach controller to provide a safety advisory about the runway condition.NTSB FTW89DRG04Accident · No injuriesFinal reportSchweizer G-164B · Austwell, TXPilot's selection of an unsuitable landing area (terrain). High vegetation and rough terrain were contributing factors.NTSB ANC89LA129Accident · Minor injuriesLimited investigationFinal reportCessna 206G · Iliamna, AKImproper planning/decision by the pilot & his failure to attain adequate speed to fly. The terrain (bank) was a contributing factor.NTSB SEA89LA138Accident · No injuriesLimited investigationFinal reportGrumman 164B · Hermiston, ORThe airport owners failure to mark a hidden hazard.NTSB ANC89LA125Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Golovin, AKThe pilot's poor judgement, his inadequate preflight planning/preparation, and his selection of the taxiway (wrong runway) for takeoff. Contributing factors were: the pilot's physical condition (fatigue), his self induced pressure, the weather conditions, and…NTSB LAX89DVA08Accident · No injuriesFinal reportSchweizer G-164B · Livingston, CAThe pilot's decision to attempt a takeoff on unsuitable terrain. A factor was the water on the airstrip.NTSB FTW89LA123Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Port Aransas, TXThe collapse of the taxiway, which was inadequately maintained.NTSB SEA89LA108Accident · No injuriesLimited investigationFinal reportCessna 170B · Gerlach, NVThe pilot displayed poor judgement by selecting unsuitable terrain for landing. As a result, the airplane nosed over during the landing roll on the soft terrain.NTSB CHI89LA108Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Cedar, MIPilot in command attempting to land with too high an aispeed and with insufficient runway remaining to allow either a go around or the ability to bring the airplane to a stop in the space remaining.NTSB CHI89DET07Accident · No injuriesFinal reportGood Varieze · Spencerville, INThe pilot's failure to maintain proper runway alignment during the soft field landing.NTSB CHI89DEM01Accident · Serious injuriesFinal reportCessna 188A · Belding, MIThe pilot's poor preflight assessment of the runway condition/aircraft performance capabilities, and the aircraft's resultant failure to attain flying speed. Soft terrain is a factor in the accident.NTSB FTW89LA101Accident · No injuriesLimited investigationFinal reportCessna 206D · Saint Jo, TXThe pilot's decision to attempt to takeoff from a field that was not suitable for such purpose.