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 SEA94LA009Accident · No injuriesLimited investigationFinal reportCessna 150E · Sandy, ORFailure of the pilot to maintain proper runway alignment during the landing. The lack of adequate runway alignment marking was a related factor.NTSB ATL94IA001Incident · No injuriesIncident investigationFinal reportBoeing 757-232 · Fort Lauderdale, FLFailure of the captain to use the proper rotation and lift-off speeds, which resulted in over rotation of the aircraft during takeoff and a subsequent tail scrape.NTSB BFO93LA185Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Wauseon, OHThe pilot's failure to compensate for the crosswind which resulted in loss of directional control during the flare/touchdown. A factor in the accident was the crosswind component.NTSB ANC93LA184Accident · No injuriesLimited investigationFinal reportCessna 185 · Ketchikan, AKThe pilot's improper planning/decision. The rough water in the takeoff area was a factor.NTSB FTW93IA250Incident · No injuriesIncident investigationFinal reportCessna A185F · Pilottown, LAThe pilot in command becoming physically incapacitated (heart attack).NTSB BFO93LA154Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Centre Hall, PAThe pilot misjudged his airspeed and altitude which resulted in the pilot's failure to attain the proper touchdown point resultng in the airplane exiting the runway and colliding with the berm. A related factor was the location of the berm.NTSB ANC93LA163Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Victory, AKThe partial failure of the airplane's brake system. Factor was the intentional ground looping by the pilot-in-command.NTSB SEA93LA183Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Enumclaw, WAThe pilot's delayed remedial action. Factors include a wet, downhill, grass runway during the abort.NTSB NYC93LA152Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Erwinna, PAThe pilot's failure to maintain aircraft control which resulted in a nose over. A rough uneven runway, and the pilot's diverted attention are contributing factors.NTSB CHI93LA318Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Minto, NDThe pilot's failure to maintain adequate aircraft control during ground maneuvering. Inadequate visual outlook by the pilot and the pilot of the other aircraft was a contributing factor.NTSB CHI93LA310Accident · No injuriesLimited investigationFinal reportCessna 177RG · Emporia, KSThe pilot's selection of unsuitable terrain.NTSB ANC93LA149Accident · No injuriesLimited investigationFinal reportCessna 180 · Skwentna, AKThe pilot's failure to maintain directional control of the airpalne. A factor in the accident was the ditch along the side of the runway.NTSB SEA93LA218Accident · No injuriesLimited investigationFinal reportCessna A188B · Rockford, WAThe pilot failed to maintain alignment with the landing area. A factor to the accident was: high vegetation.NTSB ANC93LA122Accident · No injuriesLimited investigationFinal reportHelio H295 · Talkeetna, AKThe pilot in command's selection of unsuitable terrain. The rough/uneven terrain was a factor.NTSB ANC93LA108Accident · No injuriesLimited investigationFinal reportCessna 206 · Skwentna, AKThe pilot's selection of unsuitable terrain. Factors related to the accident were: the submerged sand bar and the pilot's excessive taxispeed.NTSB SEA93LA141Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Enumclaw, WAThe pilot's failure to attain the proper touchdown point. Factors to the accident were: lack of familiarity with geographic area and the grass.NTSB NYC93LA119Accident · No injuriesLimited investigationFinal reportStart & Flug H-101 Salto · Columbus, OHThe pilot's selection of unsuitable terrain for landing. A factor related to the accident was the interruption of the glider pilot's planned approach by a powered airplane.NTSB SEA93LA128Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Havre, MTThe pilot in command misjudged his clearance from a ditch, and his use of improper remedial action.NTSB FTW93LA162Accident · No injuriesLimited investigationFinal reportCessna A185F · Timbalier Isle, LAPilot's inadequate preflight planning and preparation in the selection of his takeoff route. A factor was the sand barNTSB LAX93LA219Accident · No injuriesLimited investigationFinal reportCessna 182Q · Concord, CAThe passenger/dual student's improper recovery from a bounced landing, and the pilot's inadequate supervision of the flight.NTSB ATL93LA091Accident · No injuriesLimited investigationFinal reportCessna 172 · Wilmington, NCThe ground personnel's failure to ensure that the airplane was clear of obstructions which resulted in the right wing colliding with a utility pole. A factor was the pilot's inadequate visual lookoutNTSB CHI93LA160Accident · No injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Muskegon, MIThe pilot-in-command's misjudging the flare.NTSB LAX93LA256Accident · No injuriesLimited investigationFinal reportCessna 150M · Lakeport, CAThe student pilot's delayed flare and improper bounced landing recovery technique which resulted in an inadvertent porpoise and a collision with the runway. A factor in the accident was the student's lack of total experience.NTSB NYC93FA079Accident · 2 fatalField investigationFinal reportAerotek Pitts S-2B · North Benton, OHThe pilot's failure to maintain adequate aircraft control due to alcohol impairment.NTSB BFO93LA056Accident · No injuriesLimited investigationFinal reportCessna 177RG · Corry, PAFailure of the pilot to maintain runway alignment during the landing roll. Factors related to the accident were: darkness, the pilot's lack of visual cues due to the runway lights being obscured by the plowed snow, and failure of airport personnel to issue a…NTSB CHI93LA098Accident · No injuriesLimited investigationFinal reportCessna 172M · Grain Valley, MOThe student pilot's improper recovery from a bounced landing and failure to maintain directional control.NTSB CHI93LA092Accident · No injuriesLimited investigationFinal reportCessna 185F · Bridgeport, NEThe pilot's failure to maintain proper runway alignment during the landing roll.NTSB BFO93LA028Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Pittsfield, METhe pilot's inadequate inflight decision to continue a landing without runway lights, and his delay in initiating a go-around. A related factor was the pilot's over confidence in his ability.NTSB DEN93LA022Accident · No injuriesLimited investigationFinal reportCessna T210L · Monte Vista, COA loss of control during landing when the aircraft struck a snowbank which was left on the runway as a result of inadequate plowing.NTSB LAX93LA073Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Long Beach, CAA failure of the dual student (second pilot) to properly perform the touch down, and properly assess the terrain at the point of touch down, of an intentional autorotation. Contributing to the accident was a failure of the flight instructor (first pilot) to…NTSB NYC93LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Danbury, CTThe pilot misjudged the clearance between two snow banks, striking one of the snow banks with the airplane's right wing.NTSB NYC93LA032Accident · Minor injuriesLimited investigationFinal reportLet LF-13 · Readington, NJThe pilot's poorly planned approach for landing which resulted in an off airport landing in unsuitable terrain.NTSB ATL93LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Knoxville, TNThe pilots poor inflight decision to attempt to land the aircraft in an unsuitable area.NTSB DEN92LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Craig, COThe pilot's failure to maintain directional control.NTSB CHI92LA291Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Lansing, MIThe pilot's inadequate planning and decision-making.NTSB ANC92LA180Accident · No injuriesLimited investigationFinal reportChampion 7AC · Homer, AKThe pilot in commands inflight planning/decision in selecting unsuitable terrain. A factor relating to the accident was the ditch.NTSB ANC92LA169Accident · No injuriesLimited investigationFinal reportCessna 206 · Chena Marina, AKPilot in commands's poor preflight planning/preparation. Factors contributing to the accident were: lack of understanding of aircraft takeoff performance, lack of recency of PIC experience in type of operation, loss of aircraft performance takeoff…NTSB ANC92LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Seldovia, AKThe failure of the pilot to perform a go around when a tail wind was encountered prior to touch down. Factors related to the accident were: the tailwind and the downdraft.NTSB CHI92LA268Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Harvard, ILFailure of the pilot in command to align the accident airplane with the centerline of the runway during landing.NTSB CHI92LA242Accident · No injuriesLimited investigationFinal reportCessna 182R · Litchfield, MIThe pilot-in-command's failure to use all available runway and his not aborting the takeoff when the wing contacted the corn. A factor was the corn along side the runway.NTSB LAX92LA340Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Tolleson, AZThe pilot's selection of unsuitable terrain for takeoff. Contributing to this accident was the ravine that crossed the runway.NTSB ATL92IA151Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-11 · Los Angeles, CAThe pilot in command's improper use of the aircraft flight controls (elevator) during the landing, which resulted in the aircraft tail contacting the runway surface.NTSB SEA92LA146Accident · No injuriesLimited investigationFinal reportCessna 182Q · Melstone, MTInadequate in flight planning/decision. Factors to the accident were: unsuitable terrain was selected, rough/uneven terrain and a go around was not performed.NTSB ANC92LA102Accident · No injuriesLimited investigationFinal reportCessna 180 · Naknek, AKThe pilot's failure to maintain directional control. Factors include gusty crosswind conditions.NTSB LAX92LA259Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Robbins, CAThe failure of the pilot to maintain an adequate wing tip clearance between the aircraft and a dirt bank paralleling the airstrip.NTSB LAX92LA256Accident · No injuriesLimited investigationFinal reportLake 200 · Clearlake, CAThe pilot's inadequate weather evaluation of the wind on the Lake and his delay in lift-off. Contributing to the accident was the rough water that existed on the unsheltered section of the Lake.NTSB ANC92LA074Accident · No injuriesLimited investigationFinal reportCessna 170B · Old Minto, AKThe pilot's selection of unsuitable terrain. A factor relating to the accident was the ditch in the landing area.NTSB FTW92LA128Accident · No injuriesLimited investigationFinal reportForney F-1 · Mason, TXThe pilot's delay in proceeding to a suitable alternate when his fuel state became questionable and his subsequent loss of control during the off airport precautionary landing. A factor was the gusty wind conditions on landing.NTSB ATL92LA097Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Cartersville, GAThe pilot's failure to operate the flight controls properly during the takeoff attempt and the pilot's planning decision during rollout.NTSB FTW92LA119Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Brinkley, ARThe pilot's failure to achieve proper airstrip alignment for landing, and the resultant loss of directional control.