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 CHI01FA001Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · Rapid City, SDSuicideNTSB CHI00LA310Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Petersburg, MIthe pilots failure to abort the takeoff and obtain/maintain clearance from the corn crop. Factors were the tall, wet, grass runway, and the corn crop.NTSB ANC00LA134Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Slana, AKThe pilot's inadvertent touch down. A factor associated with the accident was deep snow on the airstrip.NTSB NYC00LA265Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Greenville, METhe pilot's improper in-flight decision to continue his descent without visual contact with the runway, and his inattention to his altitude, in relation to the airport elevation.NTSB LAX00FA346Accident · 2 fatalField investigationFinal reportCessna 182G · Tuba City, AZthe pilot's inadvertent descent into terrain on the downwind leg for landing. Contributing to the accident was the dark night and sparse population.NTSB FTW00LA269Accident · Serious injuriesLimited investigationFinal reportRobinson R-22B · Tomball, TXThe student pilot's abrupt lowering of the collective. Factors were the student pilot's lack of experience in helicopters and the CFI's delayed remedial action.NTSB CHI00FA302Accident · 2 fatalField investigationFinal reportCessna 150G · Jasper, INthe inadvertent stall by the pilot in command. Contributing factors were the approach airspeed not obtained/maintained by the pilot in command and the wind gusts.NTSB ANC00FA128Accident · 1 fatalField investigationFinal reportCessna 207 · Aniak, AKThe pilot's decision to initiate visual flight into dark night instrument meteorological conditions. Factors associated with the accident are a low ceiling, a dark night, the pilot's failure to follow regulatory procedures and directives, and his self-induced…NTSB DEN00LA170Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Sheridan, WYThe pilot's improper inflight decision to enter a canyon at an altitude insufficient to clear rising terrain. A factor was the aircraft's climb performance being exceeded due to the rising terrain.NTSB IAD00FA082Accident · 1 fatalField investigationFinal reportGrumman AA-5B · Carrollton, OHPilot's improper decision to delay the aborted landing, which resulted in an insufficient airspeed during climb and subsequent collision with terrain. A factor was the wet runway and tailwind.NTSB CHI00LA291Accident · Serious injuriesLimited investigationFinal reportBeech A36TC · Moorehead, MNThe pilots failure to abort the takeoff and the airplane not attaining a proper climb rate for undetermined reasons.NTSB LAX00FA320Accident · 2 fatalField investigationFinal reportCessna 182N · Las Vegas, NVThe pilot's continued visual flight into instrument meteorological conditions into rising terrain and the air traffic controller's failure to issue a Safety Advisory.NTSB NYC00FA257Accident · 1 fatalField investigationFinal reportCessna 172L · Mill Creek, PAThe pilot's improper pre-flight planning, and in-flight planning decision to continue visual fight into deteriorating adverse weather conditions. Factors were the night conditions, low clouds and fog.NTSB LAX00FA314Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Poway, CAThe pilot's intentional flight into known adverse weather.NTSB CHI00FA265Accident · 3 fatalField investigationFinal reportCessna 340A · Mission, SDthe aircraft control not maintained by the pilot. A contributing factor was pilot fatigue.NTSB NYC00LA232Accident · Serious injuriesLimited investigationFinal reportTriple S Aero Lancair IVP · Moraine, OHThe pilot's failure to maintain a proper glide path to the runway which resulted in the airplane contacting a 15-foot levee just short of the runway.NTSB ANC00LA104Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Chenega Bay, AKThe pilot's failure to maintain an adequate lookout. Factors involved in this accident were sunglare, and a tall bush next to the airstrip.NTSB LAX00FA302Accident · 1 fatalField investigationFinal reportPiper PA-24 · Independence, CAThe pilot's failure to maintain terrain clearance. Factors included night conditions, cockpit lighting, which compromised the pilot's night vision, and drug impairment.NTSB SEA00LA158Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235 · Paulina, ORThe pilot's failure to maintain an airspeed above stalling speed (Vs), which resulted in a stall/mush into the terrain. Factors include mountainous/hilly terrain, tall trees, a high density altitude, and the pilot's diverted attention as he attempted to keep…NTSB CHI00LA255Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Omaha, NEthe landing gear not deployed, the checklist not followed, the lack of familiarity with the airplane, the landing gear warning system not understood, and the landing gear warning disregarded by the pilot.NTSB ANC00LA096Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Delta Junction, AKThe pilot's inadequate preflight planning/preparation. Factors in the accident were an uphill takeoff, high vegetation, and a short runway area.NTSB ANC00LA095Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilots selection of unsuitable terrain for landing. A factor was high brush along side the landing area.NTSB CHI00LA250Accident · Serious injuriesLimited investigationFinal reportBell 206B · Marengo, ILthe simulated autorotation performed by the pilot at too low an altitude and airspeed.NTSB NYC00LA215Accident · Minor injuriesLimited investigationFinal reportPiper PA28-180 · Taberg, NYThe pilot's improper decision to attempt a second takeoff from the short grass runway at maximum gross weight, which resulted in the inadvertent stall/mush. Factors in this accident were the airplane's high gross weight and the short grass surface runway.NTSB LAX00FA283Accident · 2 fatalField investigationFinal reportMooney M20E · Jackpot, NVThe pilot inadvertently became lost/disoriented during initial climb and collided with terrain. A related factor was the dark night.NTSB DEN00FA141Accident · 1 fatalField investigationFinal reportMooney M20K · Cheyenne, WYthe airplane's in-flight collision with hilly terrain for undetermined reasons.NTSB ATL00FA069Accident · 3 fatalField investigationFinal reportEurocopter AS350B · Sumner, GAThe pilot experienced spatial disorientation, which resulted in a loss of control of the helicopter. Contributing factors was the dark night.NTSB FTW00LA212Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-401 · Panhandle, TXThe pilot's failure to maintain airspeed, which resulted in a stall.NTSB DEN00FA136Accident · 2 fatalField investigationFinal reportGrumman American AA-5 · Moab, UTThe pilot in command exercising poor judgment and exceeding the aircraft's turning capability. Contributing factors were the pilots' attention being diverted, flying into a known blind canyon, high temperature, and high density altitude.NTSB MIA00LA222Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Covington, TNthe pilot allowed the helicopter to get too low while hovering, which resulted in the tail rotor striking the ground, the separation of the blade, and subsequent force landing.NTSB NYC00LA199Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Lawrence, MAThe pilot's failure to attain the proper touchdown point and his delayed remedial action. Also causal was the pilot's lack of recent experience. A factor in the accident was the tailwind condition.NTSB SEA00FA132Accident · 3 fatalField investigationFinal reportCessna 180F · Gold Bar, WAThe non-instrument rated pilot's attempted VFR flight in instrument meteorological conditions. Contributing factors were mountainous terrain and cloud, low ceiling and obscuration conditions.NTSB SEA00FA127Accident · 1 fatalField investigationFinal reportCessna 175 · Molalla, ORFailure to maintain clearance from mountainous/hilly terrain.NTSB DEN00FA127Accident · 4 fatalField investigationFinal reportCessna 195 · Aspen, COthe pilot's poor in-flight decision to fly up a valley with rapidly rising terrain, which resulted in the airplane colliding with the terrain due to its climb performance being exceeded. A contributing factors was the high, rapidly rising, mountainous terrain.NTSB CHI00FA186Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Capron, ILThe pilot attempting an aerobatic maneuver at a low altitude and the pilot not maintaining clearance from the terrain. A factor to the accident was the pilot disregarding the federal aviation regulations concerning the minimum altitudes required for aerobatic…NTSB NYC00LA189Accident · No injuriesLimited investigationFinal reportCessna 150 · Freemont, DEThe pilot's failure to maintain altitude/clearance and delayed power application while attempting to release a banner from the airplane.NTSB SEA00LA124Accident · Minor injuriesLimited investigationFinal reportBell 47G · Haines, ORThe pilot's failure to correctly judge his rate of descent and his failure to initiate his level off soon enough to keep the helicopter from impacting the terrain. Factors include hilly terrain near the edge of the field he was spraying.NTSB ANC00FA082Accident · 1 fatalField investigationFinal reportCessna 172S · Whittier, AKSuicide.NTSB MIA00LA198Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Ocracoke, NCThe pilot's failure to compensate with rudder control for engine torque and 'p' factor during a go-around resulting in the aircraft drifting to the left, colliding with brush, and spinning around coming to rest in the brush.NTSB DEN00LA121Accident · No injuriesLimited investigationFinal reportCessna 172P · Price, UTThe pilot's failure to maintain directional control of the aircraft during landing roll. Factors were strong and gusty winds.NTSB NYC00LA179Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Woodbine, NJThe pilot-in-command's failure to initiate a timely go-around.NTSB NYC00LA160Accident · Minor injuriesLimited investigationFinal reportBryant/Rhodus LONG-EZ · West Chester, PAWas the failure of the pilot to attain his proper touchdown point. Factors were the downdraft and rising terrain leading to the runway.NTSB IAD00LA050Accident · Serious injuriesLimited investigationFinal reportBakeng Double Deuce · West Alexandria, OHthe pilot's failure to maintain control of the airplane. A factor in the accident was the pilot's failure to properly brief/communicate transfer of the flight controls to the pilot-rated passenger.NTSB ATL00LA058Accident · Minor injuriesLimited investigationFinal reportBell 407 · Lake Placid, FLThe pilot's failure to establish/maintain a safe rate of descent during approach to landing. Contributing factors were the pilot's incorrect altimeter (Kollsman) setting, smoke, and dark night conditions.NTSB MIA00GA184Accident · 1 fatalFinal reportBell UH-1H · Fort Myers, FLthe pilot's failure to maintain control of the helicopter for undetermined reasons. Factors in this accident were self-induced pressure and fatigue due to lack of sleep and rest.NTSB LAX00TA212Accident · Minor injuriesFinal reportPiper PA-18-150 · Austin, NVLoss of engine power caused by a fuel soaked float pontoon causing an over rich fuel/air mixture, in a critical phase of flight.NTSB FTW00LA166Accident · 1 fatalLimited investigationFinal reportCessna A188B · Pioneer, LAThe pilot's failure to maintain clearance with trees while maneuvering during an aerial application flight. A factor was the pilot's lack in experience with aerial application flight operations.NTSB LAX00FA207Accident · 2 fatalField investigationFinal reportCessna 172RG · Prescott, AZThe flight instructor's delayed remedial action, and his failure to correct an inappropriate descent during maneuvering flight, while engaged in commercial flight training maneuvers.NTSB MIA00LA183Accident · No injuriesLimited investigationFinal reportHayes LONG-EZ · Collegedale, TNThe pilot's failure to maintain the proper glide path on final approach to insure arrival at the proper runway touchdown point. A factor in the accident is the pilot's unfamiliarity with the cockpit spoiler control's location and operation.NTSB CHI00LA144Accident · No injuriesLimited investigationFinal reportCessna C-T188C · Elgin, NDthe failure of the pilot in command to maintain clearance with the ground during an aerial application.