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 MIA95LA113Accident · No injuriesLimited investigationFinal reportCessna 140 · Foxworth, MSThe pilot-in-command's selection of an unuitable landing strip for landing.NTSB LAX95LA147Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Byron, CAthe unsuitable terrain selected by the pilots.NTSB ANC95LA039Accident · No injuriesLimited investigationFinal reportHelio H700 · Deadhorse, AKAn overload failure of the right main gear retention/limit cable bracket bolts and installation of non-standard bolt hardware by other maintenance personnel. The pilot's failure to abort the takeoff was a factor in the accident.NTSB ANC95LA035Accident · No injuriesLimited investigationFinal reportCessna 150M · Glennallen, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were a soft, snow covered runway, and the pilot's lack of total aeronautical experience.NTSB CHI95LA105Accident · No injuriesLimited investigationFinal reportCessna 185 · Baudette, MNan encountered with a hidden obstruction during taxi. A factor was the ski assembly not having been installed.NTSB SEA95GA062Accident · No injuriesFinal reportBell 206 · Dillon, MTThe pilot's selection of a landing site that was not suitable to support the weight of the helicopter. Factors include terrain covered with soft snow.NTSB SEA95LA054Accident · No injuriesLimited investigationFinal reportCessna TR182 · Bountiful, UTThe pilot's failure to attain proper runway alignment. Factors in the accident were: the dark night conditions and inadequate maintenance of the runway lighting system.NTSB CHI95LA074Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Burwell, NEThe pilot's selection of unsuitable terrain for landing and takeoff. A factor was rough/uneven terrain.NTSB CHI95LA069Accident · No injuriesLimited investigationFinal reportCessna S550 · Newton, IAthe pilot-in-command's failure to attain runway alignment. A factor was a snowbank.NTSB FTW95LA077Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Albuquerque, NMThe pilot did not align the aircraft with the runway. Factors were the dusk light conditions and the pilot's failure to activate the pilot controlled runway lights.NTSB ANC95LA031Accident · No injuriesLimited investigationFinal reportCessna 182M · New Stuyahok, AKA failure of the pilot to maintain directional control of the airplane during the landing roll. A factor in the accident was an icy runway surface.NTSB ANC95LA021Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Juneau, AKThe pilot's selection of unsuitable terrain for the attempted takeoff.NTSB FTW95LA059Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Village Mills, TXThe pilot's selection of unsuitable terrain for takeoff. A factor was the rough condition of the grass runway.NTSB ANC95LA011Accident · No injuriesLimited investigationFinal reportCessna 185F · Anchorage, AKThe pilot's selection of unsuitable terrain for landing. The pilot's disregard of a NOTAM that closed the runway and a slush covered runway area were factors in the accident.NTSB SEA95LA019Accident · No injuriesLimited investigationFinal reportBeech A23 · La Grande, ORThe pilot's failure to maintain directional control. Factors include the soft, wet airstrip, and a ditch near the side of the runway.NTSB CHI95LA056Accident · No injuriesLimited investigationFinal reportCessna 206G · Butler, MOthe pilot's inadequate visual lookout. A factor associated with the accident was the dark night lighting conditions.NTSB NYC95LA236Accident · No injuriesLimited investigationFinal reportPiper PA-28-180C · Nunda, NYthe pilot-in-command's failure to assure that an adequate runway length was available.NTSB FTW95LA024Accident · No injuriesLimited investigationFinal reportMooney M20C · Greeley, COInadvertent landing gear retraction by the pilot flying the aircraft. A factor was inadequate supervision by the flight instructor.NTSB ANC95LA003Accident · No injuriesLimited investigationFinal reportCessna A185F · Kotzebue, AKA failure of the pilot to maintain adequate distance from the terrain (snow bank). Flat lighting and low contrast conditions were factors in the accident.NTSB CHI94LA343Accident · No injuriesLimited investigationFinal reportCessna 150 · North Hedrick, IAInadequate preflight planning and the selection of unsuitable terrain on which to initiate a takeoff. A factor in this accident was the pilot's lack of overall experience.NTSB ATL94LA172Accident · No injuriesLimited investigationFinal reportBell 47D1 Wasp · Hazel Green, ALUndetermined.NTSB SEA94LA238Accident · No injuriesLimited investigationFinal reportCessna 172 · Bullfrog, UTThe pilot-in-command exceeded the airplane's maximum crosswind component capability. A factor related to the accident was the gusty crosswind.NTSB SEA94LA234Accident · No injuriesLimited investigationFinal reportCessna A185F · Conrad, MTThe cfi's failure to assure an adequate inspection of the aircraft, including the proper engagement and function of the rudder pedals, prior to the flight.NTSB ANC94LA131Accident · No injuriesLimited investigationFinal reportCessna 180B · Fort Yukon, AKThe pilot's improper use of the flaps and flight controls, and a delay in aborting the takeoff. A factor in the accident was glassy water conditions.NTSB ANC94LA123Accident · No injuriesLimited investigationFinal reportHelio H295 · Artic Village, AKThe pilot selected unsuitable terrain for landing. A factor was the hidden obstruction (hole).NTSB ANC94LA107Accident · No injuriesLimited investigationFinal reportHelio H-700 · Tok, AKThe partial failure of the airplane's normal brake system.NTSB FTW94LA259Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Booneville, ARThe proper touchdown point not obtained due to excessive airspeed during the approach and landing.NTSB CHI94DER02Accident · No injuriesFinal reportAir Tractor AT-301 · Halstad, MNthe commercial pilot's failure to maintain clearance from terrain during the attempted takeoff. Related factors are the soft terrain and the deterioration in aircraft performance due to the high gross weight.NTSB ANC94LA083Accident · No injuriesLimited investigationFinal reportCessna 206 · Noatak, AKThe pilot's selection of unsuitable landing area. A factor was a 'cut bank' in the landing area.NTSB ANC94LA077Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Ft Richardson, AKThe pilot's selection of unsuitable terrain for landing. A factor which contributed to the accident was the pilot's impairmentNTSB LAX94LA275Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Las Vegas, NVThe failure of the pilot to obtain the proper takeoff speed. Factors are the high density altitude and the crosswind.NTSB SEA94LA158Accident · No injuriesLimited investigationFinal reportCessna A188 · Cut Bank, MTThe pilot's failure to adequately compensate for wind conditions. The crosswind and the ditch were factors.NTSB ANC94LA063Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fairbanks, AKThe pilot's selection of an unsuitable landing area.NTSB NYC94LA079Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Hempstead, NYThe inadvertent collision with a hidden obstruction after swerving to avoid birds during a water takeoff.NTSB SEA94LA108Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Snohomish, WAPoor in-flight planning/decision. A factor to the accident was: high vegetation.NTSB FTW94LA143Accident · No injuriesLimited investigationFinal reportCessna 140 · Hempstead, TXThe pilot's improper selection of the strip between the two runways. Factors were the pilot not being familiar with the airstrip and the soft, wet terrain.NTSB MIA94LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Stuart, FLPoor in-flight planning/decision by the pilot-in-command. Contributing to the accident was wind information disregarded by the pilot-in-command.NTSB ANC94LA042Accident · Minor injuriesLimited investigationFinal reportBell 206B · Wrangell, AKThe pilot-in-command's failure to assure that he had the proper clearance from obstructions prior to landing on the platform. A factor in the accident was the high obstruction (tree strump).NTSB NYC94LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Amherst, MAThe student pilot's inadvertently becoming lost, and the subsequent precautionary landing in a field, resulting in a collision with soft terrain and nose over.NTSB NYC94LA070Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Albion, NYthe pilot's loss of directional control during the landing roll, and the subsequent collision with soft terrain and nose over. Factors related to the accident were: the snowbanks on either side of the runway, and the pilot's lack of recent flight experience.NTSB ANC94LA040Accident · No injuriesLimited investigationFinal reportCessna 180 · Eureka Lodge, AKThe pilot-in-command's selection of unsuitable terrain for a landing.NTSB SEA94LA073Accident · Minor injuriesLimited investigationFinal reportBell 206 L-1 · Salt Lake City, UTThe pilot's selection of unsuitable terrain for a landing site. Factors include snow covered terrain.NTSB CHI94LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Concordia, KSthe flight instructor's inadequate remedial action when the student pilot failed to maintain adequate directional control of the airplane during the landing roll. A related factor is the drifted snow.NTSB BFO94LA042Accident · No injuriesLimited investigationFinal reportCessna 172M · Ravenna, OHFailure of the pilot to maintain directional control during takeoff leading to a collision with a snow bank which resulted in the airplane nosing over.NTSB BFO94LA028Accident · No injuriesLimited investigationFinal reportMitsubishi MU-3 · Teterboro, NJThe pilot selected unsuitable terrain for landing. The runway conditions were factors.NTSB LAX94LA078Accident · No injuriesLimited investigationFinal reportBell 206B · Las Vegas, NVthe pilot's failure to properly position the helicopter away from the dolly edge during the initial touchdown.NTSB ANC94LA024Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Juneau, AKThe pilot in command's selection of a sight unsuitable for landing. A factor in the accident was the ditch on the beach.NTSB ANC94LA022Accident · No injuriesLimited investigationFinal reportCessna 207 · Tuntutuliak, AKFailure of the pilot to maintain proper alignment during the takeoff roll. Factors related to the accident were: darkness and the snow berm along the edge of the runway.NTSB ANC94LA014Accident · No injuriesLimited investigationFinal reportCessna 150 · Chignik, AKThe pilot-in-commands selection of unsuitable terrain on which to perform a takeoff. A factor in the accident was the brush.NTSB CHI94LA029Accident · No injuriesLimited investigationFinal reportCessna 182N · Onaga, KSthe pilot-in-command's poor pre-flight planning and failure to maintain runway alignment. Factors were the dark light conditions and the lack of runway lights.