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 ANC01LA104Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Palmer, AKThe pilot's selection of an unsuitable area for an off-airport landing.NTSB ANC01LA096Accident · No injuriesLimited investigationFinal reportCessna U206 · Yakutat, AKThe pilot's failure to maintain clearance from high vegetation during the takeoff roll.NTSB ANC01LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Haines, AKThe pilot's failure to maintain directional control during the takeoff roll. Factors associated with the accident are the pilot's selection of unsuitable terrain for takeoff, and a rough/uneven takeoff area.NTSB CHI01LA207Accident · No injuriesLimited investigationFinal reportBurkhart Grob G 103 Twin II · Ionia, MIThe pilot not maintaining clearance from the tall grass during his recovery from the bounced landing. A factor was the tall grass.NTSB LAX01LA242Accident · No injuriesLimited investigationFinal reportCessna 310I · Amargosa Valley, NVThe pilot's attempt to depart on a taxiway unsuitable for takeoff under existing conditions. An additional factor was a berm at the end of the taxiway.NTSB ATL01LA078Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-3 · Titusville, FLThe pilot's failure to maintain directional control during a bounced landing, resulting in a ground loop and subesequent collision with the runway.NTSB SEA01LA129Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Fragaria, WAThe pilot's failure to maintain adequate directional control. Contributing factors were the embankment and the deer.NTSB ATL01LA076Accident · No injuriesLimited investigationFinal reportCessna 172P · Cedar Key, FLThe pilot's improper in-flight decision to abort the landing resulted in the collision with water. A factor was the variable wind condition.NTSB IAD01LA072Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Berlin, MDpilot's failure to maintain directional control during landing roll. A factor was the crosswind.NTSB MIA01LA173Accident · No injuriesLimited investigationFinal reportBeech 77 · Rock Hill, SCThe poor weather evaluation by the pilot for landing with a tailwind and failure of the pilot to perform a go-around after the first bounced landing.NTSB ANC01LA072Accident · No injuriesLimited investigationFinal reportArctic S-1B2 · Petersburg, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was soft terrain.NTSB ANC01LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Haines, AKThe pilot's selection of unsuitable terrain for takeoff. Factors in the accident were soft terrain, and the pilot's delay in aborting the takeoff.NTSB ANC01LA071Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Egegik, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were a soft area of runway, and sunglare.NTSB SEA01LA107Accident · No injuriesLimited investigationFinal reportHerriford RAF 2000 · Gardiner, MTthe pilot's failure to rotate the aircraft until he was well past the normal takeoff rotation speed, and his abrupt rotation at this higher speed.NTSB ANC01LA060Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Alexander, AKThe instructor pilot's inadequate supervision of the flight. Factors in the accident were the dual student's selection of unsuitable terrain for landing, and the presence of a sand bar in the landing area.NTSB SEA01LA098Accident · No injuriesLimited investigationFinal reportCessna 172 · Rogersburg, WAThe pilot's failure to maintain aircraft control while on final approach for landing. A tailwind was a factor.NTSB SEA01LA096Accident · No injuriesLimited investigationFinal reportCessna 180A · Mercer Island, WAthe pilot's inadequate visual lookout during an approach and landing in open water. Factors include a large wave/swell at the location where the pilot elected to land his float-equipped airplane.NTSB ATL01LA051Accident · No injuriesLimited investigationFinal reportCessna 182Q · Ball Ground, GAThe student pilot's failure to maintain directional control during landing roll. A factor is the ditch.NTSB NYC01LA111Accident · Minor injuriesLimited investigationFinal reportKnab-Douglas Jurca MJ5 Sirocco · G. Barrington, MAThe pilot's failure to obtain the proper touchdown point, which resulted in an overrun. A factor in this accident was the gusty wind condition.NTSB ANC01LA059Accident · No injuriesLimited investigationFinal reportCessna 207 · Kongiganak, AKThe pilot's selection of an unsuitable area for taxi. A factor associated with the accident was a rough/uneven taxiway.NTSB ANC01LA051Accident · No injuriesLimited investigationFinal reportCessna 150 · Cantwell, AKThe pilot's selection of unsuitable terrain for landing and subsequent nose over during the landing flare. Factors in the accident were soft, snow-covered terrain on the runway.NTSB ANC01LA045Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Palmer, AKThe pilot's selection of an unsuitable takeoff area. A factor associated with the accident was rough/uneven terrain.NTSB ANC01LA052Accident · No injuriesLimited investigationFinal reportCessna 180 · Iliamna, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was uneven terrain.NTSB CHI01LA106Accident · No injuriesLimited investigationFinal reportCessna 172RG · Sunfield, MIThe pilot's inadequate preflight preparation and the unsuitable terrain for takeoff encountered. Factors included the slushy runway and the snowbank.NTSB IAD01LA023Accident · No injuriesLimited investigationFinal reportCessna 172S · Lincoln Park, NJthe pilot's failure to maintain proper runway alignment during landing. Factors in the accident were the night lighting and the snow bank.NTSB ANC01LA021Accident · No injuriesLimited investigationFinal reportCessna 180H · Wasilla, AKThe pilot's selection of an unsuitable landing/taxi area. A factor associated with the accident was weak ice.NTSB ANC01LA019Accident · No injuriesLimited investigationFinal reportCessna 180 · Clarks Point, AKThe pilot's excessive application of the brakes during landing roll. Factors associated with the accident were water on the runway, low tire pressure, a sheared tire valve stem, and a fractured landing gear axle.NTSB ANC00LA130Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wasilla, AKThe pilot's failure to maintain directional control during the takeoff roll. A factor associated with the accident was the presence of tall brush alongside the runway.NTSB CHI00LA301Accident · Minor injuriesLimited investigationFinal reportChampion 7GCBC · Valentine, NEthe delayed aborted takeoff. Factors relating to this accident were the pilot's inadequate planning/preparation for the flight, the high density altitude, and the ditch.NTSB ANC00LA115Accident · No injuriesLimited investigationFinal reportCessna 207 · Kongiganak, AKThe pilot's selection of an unsuitable, rough, runway. Factors were the crosswind, the pilot's inexperience, the company's inadequate surveillance of their operation, and dispatch of an inexperienced pilot to the unsuitable airport.NTSB NYC00LA244Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Windsor, NHthe pilot's improper preflight planning to make a takeoff toward obstacles, and his delayed decision to abort the takeoff, which resulted in an overrun into unsuitable terrain.NTSB ANC00LA103Accident · No injuriesLimited investigationFinal reportCessna 185 · Kaktovik, AKThe pilot's selection of an unsuitable takeoff area on the airstrip. Factors associated with this accident were the rough takeoff area, and the pilot's loss of directional control.NTSB LAX00LA298Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Grass Valley, CAThe pilot's failure to attain proper alignment with the runway during approach for landing. Contributing factors were the pilot's inadequate and improper preflight planning and in-flight decision.NTSB ANC00LA097Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Port Alsworth, AKThe pilot's failure to touchdown at the proper point on the landing area. Factors associated with this accident were the rough landing area, and the brush along the gravel bar.NTSB CHI00LA213Accident · No injuriesLimited investigationFinal reportCessna 120 · Shawano, WIInadequate preflight planning and the pilot's delay in aborting the takeoff. A factor was the road embankment.NTSB CHI00LA198Accident · No injuriesLimited investigationFinal reportCessna T188C · Rock Dell, MNthe failure of the pilot to maintain clearance with the terrain.NTSB LAX00LA241Accident · No injuriesLimited investigationFinal reportCessna 206 · Gerlach, NVThe pilot's attempt to takeoff from an unsuitable area and his collision with a dirt berm.NTSB SEA00LA111Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · Mountain Home, IDThe pilot's decision to takeoff in unfavorable weather conditions without first calculating takeoff performance data. Factors include gusty winds, downdrafts, terrain-induced turbulence, and rough/uneven terrain where the pilot elected to make the…NTSB ANC00LA067Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Ninilchik, AKThe pilot's failure to maintain directional control during the take-off run. Factors associated with the accident were rough/uneven, soft terrain.NTSB CHI00LA155Accident · No injuriesLimited investigationFinal reportEdgerly S-12 · Hartford, MIrestricted directional control. Factors relating to this accident were the rough, uneven runway, and the trees.NTSB SEA00LA115Accident · No injuriesLimited investigationFinal reportCessna 182B · Laurel, MTThe pilot's selection of unsuitable terrain for the precautionary landing. Wet and soft terrain, and the pilot's failure to maintain directional control of the aircraft during the landing roll were factors.NTSB CHI00LA147Accident · No injuriesLimited investigationFinal reportCessna A188B · Sublette, KSthe failure of the pilot to attain aircraft control. Factors to the accident were the uneven terrain, the failure of the pilot to maintain directional control on the ground, and the crop.NTSB ANC00LA058Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Big Lake, AKThe pilot's selection of an unsuitable taxi area, and excessive taxi speed. A factor associated with this accident was a ditch in the taxi area.NTSB LAX00TA186Accident · No injuriesFinal reportMcDonnell Douglas 500N · Los Angeles, CAThe combined failure of the operator management and the check pilot to ensure the landing area was suitable for the slide on landing. Factors were the high vegetation that entangled the skids, resulting in the abrupt stop and nose down movement of the…NTSB SEA00LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hillsboro, ORAn inadequately planned approach. Misjudging distance/altitude and improper remedial action were factors.NTSB ATL00LA052Accident · No injuriesLimited investigationFinal reportCessna 172M · Clinton, TNThe pilot's inadequate in-flight planning necessitating an intentional ground loop maneuver on landing. Contributing factors were the pilot's misjudgment of distance/airspeed, the high terrain surrounding the runway, and the tailwind condition.NTSB ANC00LA046Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Anchorage, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was a frozen puddle.NTSB ANC00LA045Accident · No injuriesLimited investigationFinal reportCessna 150M · Chickaloon, AKThe pilot's selection of an unsuitable landing area. Factors associated with the accident were an open service door, and snow-covered terrain.NTSB ANC00LA031Accident · No injuriesLimited investigationFinal reportCessna 170B · Big Lake, AKThe pilot's selection of unsuitable terrain for takeoff. Factors in the accident were soft, snow-covered terrain, and an inadvertent ground loop.NTSB ANC00LA030Accident · No injuriesLimited investigationFinal reportCessna 180H · Ophir, AKThe pilot's selection of an unsuitable taxi area. A factor associated with the accident was the soft, snow-covered terrain.