NTSB investigations
3,485 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 290 |
|---|---|
| 1983 | 222 |
| 1984 | 210 |
| 1985 | 187 |
| 1986 | 159 |
| 1987 | 123 |
| 1988 | 135 |
| 1989 | 122 |
| 1990 | 141 |
| 1991 | 146 |
| 1992 | 143 |
| 1993 | 163 |
| 1994 | 124 |
| 1995 | 139 |
| 1996 | 110 |
| 1997 | 111 |
| 1998 | 105 |
| 1999 | 116 |
| 2000 | 109 |
| 2001 | 130 |
| 2002 | 105 |
| 2003 | 87 |
| 2004 | 72 |
| 2005 | 80 |
| 2006 | 79 |
| 2007 | 77 |
Where
Open the mapLatest cases
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 NYC08CA068Accident · No injuriesData collectionFinal reportCessna 170B · Alton, NHThe pilot's failure to maintain clearance above a frozen lake while maneuvering. Factors contributing to the accident were the pilot's attempt of the low altitude maneuver, and unfavorable lighting conditions.NTSB NYC08CA067Accident · No injuriesData collectionFinal reportMooney M20F · Carrollton, GAThe pilot's descent below the glidepath during the approach, which resulted in a collision with terrain. Contributing factors included the pilot's diverted attention, pilot fatigue, and the night lighting conditions.NTSB DFW08LA134Accident · 2 fatalLimited investigationFinal reportCessna 310 · Glenwood, NMA loss of control for undetermined reasons. Contributing to the accident was the marginal weather conditions in the area at the time of the accident.NTSB NYC08CA072Accident · No injuriesData collectionFinal reportBeech BE-55 · Lancaster, PAThe pilot's failure to maintain a proper glidepath during the landing approach. Contributing to the accident was the pilot's improper decision to fly with known deficiencies in equipment, and the icing conditions.NTSB LAX08CA034Accident · Serious injuriesData collectionFinal reportAir Tractor AT-401 · Soledad, CAThe pilot's failure to maintain an adequate clearance from mountainous terrain while maneuvering during an aerial application mission. Contributing to the accident was the pilot's diverted attention inside the cockpit.NTSB CHI08FA045Accident · 2 fatalField investigationFinal reportCessna 208B · Columbus, OHThe pilot's failure to maintain aircraft control and collision avoidance with terrain due to spatial disorientation. Contributing to the accident were the low cloud ceiling and night conditions.NTSB CHI08LA046Accident · 1 fatalLimited investigationFinal reportSwearingen T R/Masters W Rand KR 2 · Benton, ILThe reason for this accident is undetermined.NTSB MIA08CA019Accident · Minor injuriesData collectionFinal reportLake LA-4-200 · Jacksonville, FLThe pilot's failure to maintain altitude while maneuvering over water. Contributing to the accident was glassy water conditions.NTSB SEA08FA023Accident · 2 fatalField investigationFinal reportCessna T182T · Las Vegas, NVThe pilot's failure to maintain an adequate terrain clearance/altitude during climb to cruise. Contributing to the accident were rising mountainous terrain, the dark nighttime lighting condition, the pilot's loss of situational awareness, and the Federal…NTSB DFW08LA020Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Catarina, TXThe loss of control due to the pilot's failure to maintain clearance with trees while hovering . A contributing factor was the low altitude.NTSB DEN08CA019Accident · No injuriesData collectionFinal reportGrumman American AA-5 · Wheatland, WYThe pilot's improper decision to execute an off-airport landing on a dirt road. A contributing factor was the soft terrain.NTSB ANC08CA002Accident · Minor injuriesData collectionFinal reportde Havilland DHC-2 · King Salmon, AKThe pilot's inadequate compensation for gusty wind conditions during the final approach to land, which resulted in the airplane colliding with terrain. A factor contributing to the accident was the gusty wind.NTSB DEN08FA003Accident · 3 fatalField investigationFinal reportRaytheon C90A · Pagosa Springs, COThe pilot's failure to maintain clearance from mountainous terrain. Contributing to the accident was the pilot's inadequate preflight planning, improper in-flight planning and decision making, the dark night, and the controller's failure to issue a safety…NTSB CHI08CA001Accident · No injuriesData collectionFinal reportDusenberry 1905 Wright Flyer · Dayton, OHThe altitude not maintained by the pilot for a turning maneuver.NTSB CHI08CA013Accident · No injuriesData collectionFinal reportCessna 182 · Middlefield, OHThe proper touchdown point not obtained by the pilot and the inadequate supervision by the certified flight instructor during landing. A contributing factor was the rough terrain encountered during landing.NTSB CHI08CA004Accident · Serious injuriesData collectionFinal reportProgressive Aerodyne Searey · Cokato, MNThe inadequate flare by the pilot during landing. Contributing factors were the lack of an endorsement by the pilot, the lack of total experience in the type of aircraft by the pilot, and the glassy water.NTSB SEA07FA246Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Alsea, ORTerrain clearance was not maintained while maneuvering. A low altitude during the maneuver and hilly terrain were factors.NTSB SEA07CA260Accident · No injuriesData collectionFinal reportRobinson R-22B · Long Beach, CAThe student pilot's loss of directional control while hovering, and the instructor pilot's inadequate remedial action while attempting to take control of the helicopter.NTSB LAX07FA272Accident · 1 fatalField investigationFinal reportGrumman American AA-5 · Joshua Tree, CAThe pilot's failure to maintain terrain clearance during descent. Contributing to the accident were dark night conditions and mountainous terrain.NTSB MIA07FA147Accident · 2 fatalField investigationFinal reportBell 206B · Nokomis, FLThe pilot's failure to maintain clearance from the water.NTSB NYC07LA219Accident · 1 fatalLimited investigationFinal reportNorth American SNJ-2 · Virginia Beach, VAThe pilot's inability to maintain control of the airplane due to physiological incapacitation. Contributing to the accident was the failure of the Federal Aviation Administration to deny or restrict the pilot's medical certification, and the pilot's improper…NTSB SEA07LA251Accident · No injuriesLimited investigationFinal reportCessna 172M · Thompson, UTThe pilot's failure to maintain terrain clearance while maneuvering in a box canyon.NTSB MIA07FA137Accident · 5 fatalField investigationFinal reportBeech A36 · Elizabethton, TNThe poor in-flight planning by the pilot-in-command for flying towards rising terrain with inadequate clearance.NTSB CHI07LA280Accident · Serious injuriesLimited investigationFinal reportMcFaul, Daniel D. Quicksilver GT500 · New London, WIThe pilot not maintaining airspeed during the unintentional takeoff and the pilot's inadvertent stall.NTSB ATL07LA119Accident · 1 fatalLimited investigationFinal reportCessna P206 · Center Hill, FLThe pilot committed suicide. Contributing to the event was the pilot's impairment due to alcohol.NTSB DEN07CA154Accident · No injuriesData collectionFinal reportCessna 172R · Fort Collins, COThe student pilot's improper flare and recovery from a bounced landing.NTSB DEN07MA134Accident · 5 fatalMajor investigationFinal reportBeech E90B · Ruidoso, NMFailure to maintain clearance from terrain due to spatial disorientation.NTSB CHI07LA254Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Overly, NDThe pilot's failure to maintain terrain clearance during the agricultural application flight. Contributing to the accident was the wheat crop.NTSB SEA07CA220Accident · No injuriesData collectionFinal reportHughes 269C · Three Forks, MTThe student pilot's failure to maintain control of the aircraft during autorotation. The flight instructor's inadequate supervision was a factor.NTSB CHI07TA241Accident · Minor injuriesFinal reportChristen Industries A-1 · Elm Springs, SDThe pilot not maintaining clearance from the rising terrain. A factor contributing to the accident was the rising terrain.NTSB CHI07LA237Accident · 1 fatalLimited investigationFinal reportOpus Motorsports BD02 · Dayton, OHThe pilot not maintaining clearance from terrain during the aerobatic maneuver. Factors contributing to the accident were the pilot's restricted ability to see the terrain and the oil smoke present in the air show performer's box.NTSB CHI07CA225Accident · Serious injuriesData collectionFinal reportRyan ST3KR · Coldwater, MIThe pilot's failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in an inadvertent stall/mush condition. A contributing factor was the low altitude at the time of the inadvertent stall.NTSB CHI07CA233Accident · No injuriesData collectionFinal reportSchweizer SGS 1-35C · Northfield, MNThe pilot's failure to maintain adequate airspeed, which resulted in a stall during the off-airport landing. A factor contributing to the accident was the dirt/rock pile.NTSB LAX07TA222Accident · Minor injuriesFinal reportAir Tractor AT-802A · Winnemucca, NVThe pilot's failure to maintain clearance with terrain while maneuvering.NTSB CHI07LA213Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402A · Laurel, IAThe pilot failed to maintain clearance with the upsloping terrain for undetermined reasons.NTSB ANC07LA062Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Skwentna, AKThe pilot's failure to maintain clearance from a glacier, which resulted in a tail rotor strike during landing, and damage to the helicopter during an emergency descent/landing on rough/uneven terrain. Factors contributing to the accident were variable and…NTSB LAX07CA213Accident · Minor injuriesData collectionFinal reportDiamond DA40-G1000 · Strawberry Rese, UTThe pilot failed to maintain adequate terrain clearance. Contributing to the accident was the pilot's decision to turn into upsloping terrain at a low altitude.NTSB CHI07TA201Accident · Minor injuriesFinal reportWSK PZL Mielec PZL M18B · Kyle, SDThe pilot's failure to maintain clearance from terrain during an aerial application maneuver. Contributing to the accident were wind gusts, low altitude, and the reported downdraft.NTSB ANC07CA061Accident · Minor injuriesData collectionFinal reportCessna 185F · Port Alsworth, AKThe pilot's flight into adverse weather conditions, which resulted in an in-flight collision with terrain while maneuvering. A factor contributing to the accident was interference by the pilot-rated passenger.NTSB CHI07CA194Accident · Minor injuriesData collectionFinal reportBoeing N2S-3 · Trenton, MOThe pilot's failure to maintain sufficient altitude/clearance above the water while maneuvering. A factor in the accident was the low altitude maneuver attempted by the pilot.NTSB SEA07CA193Accident · No injuriesData collectionFinal reportRobinson R 22 Beta · Long Beach, CAThe student pilot's improper use of the throttle and cyclic, and the certified flight instructor's inadequate supervision, which resulted in the collision with terrain.NTSB DFW07LA148Accident · Serious injuriesLimited investigationFinal reportAir Tractor 301 · Lueders, TXThe pilot's failure to maintain airspeed which resulted in an inadvertent stall and subsequent impact with terrain.NTSB CHI07CA181Accident · No injuriesData collectionFinal reportBell 206B · Grand Forks, NDThe certified flight instructor's inadequate compensation for the gusting wind conditions and failure to maintain control of the helicopter during a hover for takeoff. A factor contributing to the accident was the gusting wind conditions.NTSB DEN07CA102Accident · Minor injuriesData collectionFinal reportEagle RND Helicycle · Erie, COThe pilot's failure to maintain aircraft control resulting in the helicopter impacting onto the airport ramp. A contributing factor to the accident was the pilot's failure to establish the landing flare in time.NTSB DEN07FA100Accident · 1 fatalField investigationFinal reportBeech 58 · Placitas, NMthe failure of the pilot to maintain adequate terrain separation, for undetermined reasons, which resulted in controlled flight into terrain. A contributing factor was the mountainous terrain.NTSB SEA07FA165Accident · 1 fatalField investigationFinal reportCessna 172 · Yellow Pine, IDThe pilot's selection of the wrong routing through mountainous terrain and his failure to maintain adequate terrain clearance.NTSB CHI07CA166Accident · Serious injuriesData collectionFinal reportCessna A188B · Sargent, NEThe pilot's failure to maintain adequate visual lookout and clearance from the hillside. Factors contributing to the accident include the pilot's diverted attention, the hillside, and the glare from the setting sun.NTSB CHI07LA162Accident · 1 fatalLimited investigationFinal reportAero Commander S2R · Watford City, NDThe agricultural pilot's failure to maintain clearance from the terrain while maneuvering to avoid power lines. The power lines were a contributing factor in the accident.NTSB SEA07FA134Accident · 1 fatalField investigationFinal reportCessna 185 · Wilbur, WAIn-flight collision with terrain shortly after takeoff for undetermined reasons.NTSB MIA07CA100Accident · Serious injuriesData collectionFinal reportHillery W. Grice Alley Cat 1 · Fairhope, ALThe failure of the pilot-in-command to maintain terrain clearance while completing a loop at an airshow, resulting in impact with the runway.