NTSB investigations
3,485 cases where the first occurrence was “In flight collision 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\" = 230) 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" = 230) 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 ANC90LA011Accident · No injuriesLimited investigationFinal reportCessna 150 · Birchwood, AKFailure of the pilot to maintain proper runway alignment during the takeoff roll. Related factors were: dark night, snow covered runway, inadequate snow removal from the runway by personnel (who were responsible for snow removal), and the snowbank (berm).NTSB FTW90LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Marietta, OKThe pilot's use of the wrong runway for takeoff. Factors related to the accident were: the tailwind and rising terrain beyond the departure end of the runway.NTSB SEA90LA011Accident · Serious injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Chilcoot, CAThe pilot's improper inflight planning. Contributing to the accident was a down draft and the pilot's lack of recent expereince in this aircraft type.NTSB NYC90LA025Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B1 · Westfield, MALoss of aircraft control for an undetermined reason, which resulted in the tail rotor striking the ground and separating from the helicopter.NTSB ATL90GA023Accident · 1 fatalFinal reportSikorsky SK-70 · Marathon, FLFailure of the pilot to maintain the proper altitude over the ocean water. Factors related to the accident were: continued operation of the helicopter with a known partial deficiency of the radio altimeter/warning system, darkness, the pilot's lack of visual…NTSB MIA90FA021Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Apopka, FLFailure of the pilot to maintain altitude/clearance above the water, while proceeding over a lake and approaching the vicinity of the airport.NTSB MIA90FA022Accident · 1 fatalField investigationFinal reportPiper 601P · Fort Myers, FLFailure of the pilot to properly follow the IFR procedure and to identify the decision height. Factors related to the accident were: the adverse weather conditions, darkness, the pilot's lack of visual perception without the approach lights, and tree(s) in…NTSB MKC90FA019Accident · 2 fatalField investigationFinal reportCessna 320 · Nebraska City, NEThe pilot's decision to continue the flight into IFR conditions and the failure to maintain adequate alittude. Factors related to the accident were the pilot's over confidence in his ability and the lack of instrument flight experience.NTSB LAX90LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Bishop, CAThe pilot's neglect in failure to ensure adequate clearance was available to pass the parked refueling vehicle. The refueling vehicle parking position on an active taxiway was a factor in the accident.NTSB DEN90LA014Accident · No injuriesLimited investigationFinal reportCessna 206F · Opheim, MTPilot's failure to maintain terrain clearance while executing a low pass.NTSB LAX90LA013Accident · Minor injuriesLimited investigationFinal reportRobinson R22A · Simi Valley, CAStudent pilot's failure to maintain the proper altitude.NTSB MIA90FA017Accident · 1 fatalField investigationFinal reportCessna 150L · Columbia, MSSuicide. The pilot's emotional state of distress was a related factor.NTSB CHI90LA011Accident · 1 fatalLimited investigationFinal reportCessna 152 · Hillsdale, MIPoor judgement of the student pilot by not following his flight instructor's directions on his first supervised solo flight and by not maintaining a safe altitude, which resulted in a collision with the terrain. Related factors were: unauthorized low flight…NTSB DEN90LA006Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Las Vegas, NMFailure of the pilot to abort the takeoff, when she failed to attain sufficient speed within the appropriate takeoff distance. A factor related to the accident was: high density altitude.NTSB ANC90LA001Accident · No injuriesLimited investigationFinal reportCessna 208 · King Salmon, AKImproper planning/decision by the pilot. Contributing factors were: the surrounding terrain, unfavorable wind, downdraft, the pilot's lack of familiarity with the geographical area, and his self induced pressure.NTSB NYC90LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Bingham, METhe pilot's inadequate preflight planning to assure that the airplane was capable of outclimbing the surrounding terrain under the existing wind and airplane weight conditions, resulting in an intentional stall into the terrain. Contributing factor(s) was:…NTSB LAX89FA334Accident · 2 fatalField investigationFinal reportCessna 152 · Lancaster, CAThe pilot's decision to enter into IMC while flying under VFR. Factors contributing to accident were: low ceilings, poor planning and decisions, failure to obtain a preflight briefing and not performing a weather evaluation.NTSB SEA89FA180Accident · 2 fatalField investigationFinal reportCessna 177RG · Nyssa, ORFailure of the pilot to attain sufficient altitude before flying over mountainous/hilly terrain. Factors related to the accident were: dark night, rising/mountainous terrain, and probable impairment from a prescription drug.NTSB MKC89FA197Accident · Serious injuriesField investigationFinal reportCessna 172N · Hyannis, NEFailure of the pilot to maintain sufficient altitude. Darkness and adverse weather conditions were related factors.NTSB MIA89FA252Accident · 2 fatalField investigationFinal reportCessna 152 · Ochopee, FLFailure of the pilot to maintain altitude/clearance over the terrain. Related factors were: dark night, spatial disorientation of the pilot, and his lack of experience in the type of operation (night flying).NTSB NYC89FA220Accident · 1 fatalField investigationFinal reportMBB BO-105CB-4 · Tuckerton, NJThe pilot's delay in remedial action by delaying the pull-up from a descending maneuver.NTSB ANC89LA168Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6 · Sleepy Bay, AKSelection of unsuitable terrain (water condition) by the pilot. The rough water condition was a related factor.NTSB CHI89LA185Accident · No injuriesLimited investigationFinal reportCessna C172R · Frankenmuth, MIThe pilot's failure to maintain control of the aircraft during takeoff as a result of a diversion of attention due to a possible engine problem.NTSB DEN89LA216Accident · No injuriesLimited investigationFinal reportCessna 172N · Provo, UTThe pilot failed to maintain the proper glidepath during a practice instrument approach resulting in a collision with terrain. Contributing factor(s) was: the dark night light condition.NTSB SEA89LA166Accident · Serious injuriesLimited investigationFinal reportConsolidated Aeronautics LAKE-LA-4-200 · Klawock, AKThe pilot misjudged the aircraft height above water while attempting to land on a lake. A contributing factor was the smooth, glassy water surface conditions on the lake.NTSB DEN89FA209Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Lk Havasu City, CAPilot's attention diverted outside the airplane. This diversion resulted in the pilot failing to monitor his altitude while in a descending turn and inadvertently flying the airplane into the water.NTSB DEN89FA208Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Grantsville, UTImproper in-flight planning/decision by the pilot, by entering a box canyon with insufficient altitude to assure a safe exit. Contributing factors were: box canyon, rising terrain, and high density altitude.NTSB ANC89FA160Accident · 1 fatalField investigationFinal reportCessna 185 · Tanacross, AKPoor judgement by the pilot by buzzing the airport and his failure to maintain sufficient altitude/clearance above the terrain. The pilot's use of abrupt maneuvers was a contributing factor.NTSB SEA89FA156Accident · 1 fatalField investigationFinal reportCessna TU206C · Skykomish, WAThe pilot's decision to continue the flight into IMC. The pilot did not adequately plan and prepare for the flight and was unable to maintain a proper altitude above the terrain for VMC. Fog was a related factor.NTSB SEA89LA159Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Atlanta, IDThe pilot's failue to adequately compensate for the downdraft conditions. Contributing factor(s) was: the downwind, downdraft, and high density altitude weather conditions, and the surrounding mountainous terrain.NTSB MKC89LA190Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Wabbaseka, ARImproper planning/decision by the pilot which resulted in his failure to maintain clearance from the tall vegetation (grass). The tall vegetation & high density altitude were considered to be contributing factors.NTSB LAX89LA289Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Tracy, CADual student's failure to properly flare the helicopter during the autorotation power recovery and the cfi's failure to adequately supervise the dual student's performace during a critical phase of flight.NTSB FTW89DRD13Accident · No injuriesFinal reportBell 47G-3B-1 · Rayville, LAFailure of the pilot to maintain sufficient rotor RPM. A factor related to the accident was: the cotton crop.NTSB ATL89DKJ10Accident · Serious injuriesFinal reportPiper PA-36-285 · Atmore, ALThe pilot's failure to maintain clearance from obstacles (the crop) during an agricultural spray run.NTSB MIA89LA225Accident · Minor injuriesLimited investigationFinal reportCocchiarella Buccaneer II · Clermont, FLImproper planning/decision by the pilot, which resulted in a subsequent collison with the ground, when the acft would not climb after takeoff. The high obstructions (trees) and high density altitude were considered to be contributing factors.NTSB DEN89LA196Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Dove Creek, COImproper planning/decision by the pilot. Factors related to the accident were: high density altitude, uphill sloping runway, failure of the pilot to follow the checklist and use all of the available runway, and the rising terrain and obstruction (power line)…NTSB MIA89LA224Accident · No injuriesLimited investigationFinal reportBeech 18 · Greenwood, MSInadvertent wheels up landing by the pilot.NTSB LAX89LA278Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Butte Meadows, CAThe pilot improper in-flight planning to attain proper altitude to clear the mountainous terrain. Contributing factor(s) was: the high terrain and high density attitude.NTSB ANC89LA138Accident · Serious injuriesLimited investigationFinal reportCessna 207-A · Tanana, AKPilot-in-command's improper inflight planning and decisions. He flew into weather that was known to be adverse, and the environmental conditions adversely affected his ability to safely complete the flight.NTSB NYC89LA187Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Mount Joy, PAThe pilot's delay in initiating a go-around, and his failure to maintain proper runway alignment. Factors related to the accident were: failure of the pilot to attain the proper touchdown point and the crop.NTSB ANC89LA139Accident · No injuriesLimited investigationFinal reportMaule M-5 · Nebesna Glacier, AKThe pilot allowed the aircraft to inadvertently touch down, he delayed making a go-around, and he did not maintain sufficient speed to continue the go-around. Contributing factors were: the pilot's selection of unsuitable terrain, high vegetation in the…NTSB SEA89LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Mollala, ORPilot displayed poor judgement and did not adequately plan for the flight. The pilot was unfamiliar with the area and terrain conditions. As a result, the airplane was not able to attain sufficient altitude for the conditions to clear the terrain.NTSB LAX89FA276Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Toms Place, CAFailure of the pilot to attain sufficient altitude to clear terrain obstructions before entering a high elevation basin. Contributing to the accident was a high density altitude which reduced the aircraft's climb performance to less than the rate of climb of…NTSB DEN89FA184Accident · 1 fatalField investigationFinal reportCessna 172M · Albuquerque, NMThe pilot deliberately flew his aircraft into the face of a mountain. A contributing factor was: the psychological condition of the pilot.NTSB LAX89LA264Accident · No injuriesLimited investigationFinal reportCessna 182 · Parker Dam, CAThe pilot's delay in making a go-around, and his failure to maintain clearance from the terrain during the aborted landing. The runway/terrain condition was a related factor.NTSB LAX89LA258Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fremont, CAThe pilot's improper inflight decison to land on an unlighted runway during the hours of darkness. Darkness and the lack of runway lights were related factors.NTSB ATL89FA193Accident · 1 fatalField investigationFinal reportTexas Helicopter OH-13/M74 · Norman Park, GAImproper planning/decision by the pilot, which resulted in his physical impairment from exposure to lannate, and his failure to maintain altitude/clearance above the ground. A factor related to the accident was: failure of the pilot to use a respirator while…NTSB SEA89LA144Accident · No injuriesLimited investigationFinal reportRobinson R22 · Brinnon, WAThe pilot's inadequate in-flight planning. The helicopter skid contacted the water as a result of the pilot's misjudgement of clearance above the water.NTSB MIA89LA203Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Schlater, MSInadequate preflight planning/preparation by the pilot which resulted in the selection of the wrong runway. The tailwindand dirt bank were considered to be contributing factors.NTSB DEN89LA173Accident · No injuriesLimited investigationFinal reportBeech A36 · Cimarron, NMFailure of the pilot to properly plan his flight. He failed to take into account the changable winds and the high density altitude that existed at the airstrip when he attempted to takeoff. A proper climb rate was not possible and theaircraft stalled/mushed…