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 FTW97LA311Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402 · Patterson, LAThe pilot's failure to maintain terrain clearance.NTSB CHI97LA254Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Britton, SDthe pilot's failure to maintain clearance with the terrain during the spray run and his failure to maintain adequate airspeed during the turn after having contacted the terrain. A factor was the pilot's diverted attention.NTSB IAD97LA108Accident · 1 fatalLimited investigationFinal reportRiekkenen Ryelong LE · Wurtsboro, NYThe pilot performed an aerobatic maneuver and misjudged the altitude.NTSB LAX97LA275Accident · 2 fatalLimited investigationFinal reportGrumman American AA-5 · Monterey, CAthe pilot's failure to maintain adequate clearance from surrounding terrain.NTSB FTW97FA299Accident · 2 fatalField investigationFinal reportBeech 58P · Colorado Spring, COfailure of the pilot to follow IFR procedures; and his failure to maintain proper altitude, while executing a missed approach from an attempted ILS approach. Related factors included: low ceiling, rain, fog, the pilot's overconfidence in his personal ability,…NTSB FTW97LA297Accident · Serious injuriesLimited investigationFinal reportBeech F33A · Creede, COThe pilot's intentional low altitude flight over mountainous terrain, inadequate altitude to clear surrounding obstacles, and his misjudging vertical clearance. A factor was the pilot's use of an inappropriate chart for navigation.NTSB CHI97LA234Accident · Minor injuriesLimited investigationFinal reportRutan Defiant · Alma, MIthe pilot did not perform an adequate preflight check and he did not perform the takeoff checklist. Factors included the pilot's inadequate design of the safety latch and the canopy inadvertently deploying.NTSB FTW97LA300Accident · No injuriesLimited investigationFinal reportPoor Boys Toys Exec 90 · Patricia, TXThe failure of the pilot to maintain terrain clearance with the crops during a surveying flight. A factor was the pilots diverted attention.NTSB SEA97LA179Accident · No injuriesLimited investigationFinal reportCessna 180B · Spanish Fork, UTThe pilot's inadequate compensation for the crosswind. A factor was the crosswind.NTSB LAX97FA259Accident · 2 fatalField investigationFinal reportPiper J3C-85 · Bullhead City, AZimproper judgement of the pilot by intentionally performing low level maneuvers, and his misjudgment of a level-off over water.NTSB ANC97LA110Accident · No injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe pilots failure to maintain terrain clearance during the downslope, downwind, high altitude, takeoff. Factors were the snow and lighting conditions, and the tailwind takeoff.NTSB SEA97LA174Accident · No injuriesLimited investigationFinal reportBell 47G-3B1 · Idaho Falls, IDThe pilot-in-command's failure to verify the proper chemical and fuel load aboard prior to takeoff. Factors contributing to the accident were: excessive fuel and chemical loading by ground personnel, tailwind conditions, and high density altitude.NTSB FTW97LA275Accident · 1 fatalLimited investigationFinal reportEichman Aerobat III · Brownsville, TXinadequate design by the pilot/builder/designer. Related factors were: the porpoise that was encountered by the pilot during the takeoff, and the subsequent jammed rudder.NTSB CHI97LA213Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Fessenden, NDthe pilot's premature liftoff and/or failure to abort the takeoff while there was sufficient runway remaining.NTSB LAX97FA241Accident · 3 fatalField investigationFinal reportCessna TR182 · Panamint Spring, CAfailure of the pilot to attain a proper touchdown point for landing, and his delay in initiating a go-around. Factors relating to the accident were: the pilot's attempt to land at the wrong airport, uphill slope of the runway, high density altitude, and…NTSB NYC97FA144Accident · 2 fatalField investigationFinal reportCessna TR182 · Seaside Heights, NJfailure of the pilot to maintain sufficient altitude/clearance above water, while maneuvering over the ocean during a dark moonless night. Related factors were: darkness, the pilot's probable illusion of altitude, spatial disorientation, and lack of…NTSB LAX97LA244Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 601 · Boulder City, NVthe pilot's inadequate in-flight planning/decision, his failure to obtain the current wind information, his selection of the wrong runway, and his delay in aborting landing.NTSB CHI97LA211Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Springfield, ILfailure of the pilot to maintain safe altitude/clearance from the terrain. Factors relating to this accident were: the hazy weather condition, the resultant difficulty in keeping the other airplane in sight, and the pilot's diverted attention, while looking…NTSB SEA97LA163Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Creek, IDThe pilot-in-command's inadequate terrain clearance and failure to maintain directional control. Also, the overload of the aircraft's left main landing gear strut assembly. Factors contributing to the accident were high density altitude conditions, downdrafts…NTSB MIA97LA204Accident · No injuriesLimited investigationFinal reportMoran Teenie TWO · Pinehurst, NCThe pilot's decision to takeoff with a tailwind and improper recovery from a bounced landing. This resulted in a premature lift off, in-flight collision with terrain, on-ground loss of directional control, and subsequent on-ground collision with a taxiway…NTSB FTW97LA256Accident · Minor injuriesLimited investigationFinal reportLet Blanik L-13 · Pagosa Springs, COThe pilot's improper inflight planning in that he allowed the glider to descend to too low an altitude and stray too far from the airport, exceeding the aircraft's glide capabilities. A factor was his failure to utilize maximum braking action.NTSB FTW97LA250Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Ashdown, ARThe inadvertent stall/mush. A factor was the high density altitude.NTSB LAX97FA225Accident · 2 fatalField investigationFinal reportCessna R172K · Moreno Valley, CAThe pilot's continued VFR flight into instrument meteorological conditions, and his attempt to climb through a low stratus cloud layer while in mountainous/hilly terrain. The pilot's failure to obtain a weather briefing, the weather, and the terrain were…NTSB MIA97LA198Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Bainbridge, GAthe pilot's failure to maintain proper airspeed during the initial climb after takeoff, and improper flare during an emergency (precautionary) landing, which resulted in a hard touchdown and subsequent nose over. Factors related to the accident were: the…NTSB FTW97LA236Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Leadville, COan attempt by the pilot to fly the aircraft over mountainous terrain in a regime that was beyond its climb performance limit. High density altitude was a related factor.NTSB MIA97LA195Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Tunica, MSThe pilots poor preflight planning preparation for attempting to takeoff with a tailwind and with the hopper loaded 3/4 full during a 93degree F., day at a density altitude of 2,400 feet.NTSB LAX97FA286Accident · 1 fatalField investigationFinal reportCessna 172N · Cuyama, CAundetermined.NTSB SEA97LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Madras, ORThe pilot's failure to abort the takeoff. Factors include high vegetation, rough runway, and failure to attain adequate flying speed.NTSB SEA97LA150Accident · No injuriesLimited investigationFinal reportCorben Junior ACE · East Wenatchee, WAThe dual student's improper attempt to abort the takeoff and the flight instructor's inadequate supervision of the flight.NTSB FTW97FA229Accident · 1 fatalField investigationFinal reportAir Tractor AT-301 · Las Animas, COin-flight collision with terrain, while maneuvering, for undetermined reason(s).NTSB SEA97LA141Accident · Minor injuriesLimited investigationFinal reportWood Murphy Rebel · Marion, MTThe pilot's failure to maintain clearance from the terrain/water. Factors include gusty winds and downdrafts.NTSB LAX97LA212Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Rio Linda, CAthe pilot's inadequate preflight planning/preparation by failing to ensure that sufficient airspeed would be obtained and/or maintained to remain clear of obstacles at the departure end of the runway. The obstacles (power lines & poles) were a related factor.NTSB SEA97LA140Accident · Minor injuriesLimited investigationFinal reportRepublic RC-3-1 · Monument Valley, UTthe pilot's inadequate preflight planing/preparation, and his failure to maintain sufficient altitude or clearance from the terrain. Factors relating to the accident included: high, gusty, variable winds, and terrain induced downdrafts.NTSB LAX97FA210Accident · 1 fatalField investigationFinal reportCessna 210K · Topanga, CAThe pilot's failure to maintain proper VFR altitude over mountainous terrain obscured by clouds, and his intentional descent into instrument meteorological weather conditions.NTSB LAX97GA205Accident · 1 fatalFinal reportRockwell OV-10A · Hollister, CAthe pilot's failure to maintain adequate ground clearance altitude while performing a low-level aerobatic maneuver. A factor in the accident was the pilot's lack of experience in the aircraft.NTSB CHI97LA163Accident · 1 fatalLimited investigationFinal reportSiefert 5151RG · Shelbyville, INthe cause of the accident is undetermined.NTSB SEA97LA131Accident · No injuriesLimited investigationFinal reportCessna 182C · Hardin, MTthe student's delay in initiating a go-around. A factor relating to the accident was: the sunglare.NTSB SEA97LA125Accident · Serious injuriesLimited investigationFinal reportCessna 402C · Rawlins, WYThe pilot's failure to maintain clearance from the terrain during the initial climb after a night takeoff. Factors include a dark night and rising terrain off the departure end of the runway.NTSB SEA97LA123Accident · Minor injuriesLimited investigationFinal reportPiper PA-38 · Fruitland, UTThe pilot's failure to maintain clearance from mountainous terrain. Factors include his improper inflight decision to attempt to fly through a mountain pass under high density altitude conditions in an aircraft that was operating near the limits of its…NTSB SEA97LA115Accident · No injuriesLimited investigationFinal reportRobinson R22B · Boise, IDimproper handling of the helicopter by the student pilot/applicant, during a hover autorotation, which resulted in loss of tail rotor effectiveness. The check pilot's inadequate remedial action was a related factor.NTSB LAX97FA177Accident · 5 fatalField investigationFinal reportBeech A36TC · Truckee, CAfailure of the pilot to maintain altitude and clearance above the terrain, while turning (for an unknown reason) back toward the airport after takeoff. Factors relating to the accident were: the environmental conditions (light conditions at dusk and high…NTSB ATL97LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Jacksonville, FLThe pilot's failure to maintain terrain clearance while on a low pass, leading to propeller damage. A factor was birds in the area.NTSB SEA97LA099Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Rosalia, WAThe pilot-in-command's failure to maintain clearance with terrain. Factors contributing to the accident were, hilly terrain conditions and impairment due to recent use of marihuana.NTSB FTW97LA179Accident · Serious injuriesLimited investigationFinal reportCallair A2A · Grants, NMInadvertent stall. Factors were the ground depression, the high density altitude, and a lack of recent experience in the make and model of aircraft.NTSB LAX97LA173Accident · 2 fatalLimited investigationFinal reportShoaf Christen Eagle II · Half Moon Bay, CAundetermined.NTSB FTW97FA171Accident · 3 fatalField investigationFinal reportPiper PA-32RT-300T · Rye, COThe pilot initiating flight into IMC conditions in mountainous terrain. Factors were mountainous terrain, low ceiling, snow, preflight planning, and in-flight planning and decision making.NTSB ANC97LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Ninilchik, AKfailure of the pilot to maintain altitude/clearance from a closed runway, while making a low pass, which resulted in an inadvertent touchdown.NTSB MIA97FA142Accident · 2 fatalField investigationFinal reportBoeing Stearman N2S-4 · Apex, NCThe pilot-in-command's ostentatious display by performing an aerobatic maneuver with inadequate altitude.NTSB SEA97LA088Accident · Serious injuriesLimited investigationFinal reportRockwell S-2R · Prescott, WAfailure of the pilot to maintain terrain clearance from uneven/hilly terrain.NTSB NYC97LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Lumberton, NJThe pilot's delay in initiating remedial action to arrest an excessive descent rate during a go-around. A crosswind condition was a contributing factor.