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 LAX97LA155Accident · No injuriesLimited investigationFinal reportGordon Price Ultimate 10-300S · Yuma, AZthe pilot's failure to maintain adequate vertical clearance from the runway, while flying inverted. Factors relating to the accident were: the light conditions at dusk, and the pilot's lack of visual ques due to the light conditions.NTSB CHI97FA102Accident · 2 fatalField investigationFinal reportCessna T210N · Vichy, MOfailure of the pilot to properly follow the missed approach procedure and maintain the minimum descent altitude (MDA) during night/IFR flight. Factors relating to the accident included: darkness, low ceiling, fog, and failure of the pilot to properly…NTSB ANC97MA161Accident · 5 fatalMajor investigationFinal reportCessna 208B · Wainwright, AKThe pilot's intentional VFR flight into instrument meteorological conditions and his failure to maintain altitude/clearance from terrain. Factors contributing to the accident were the weather conditions.NTSB ANC97LA048Accident · No injuriesLimited investigationFinal reportPiper PA-31-T3 · Stebbins, AKThe pilot's decision to continue VFR into IMC. Factors associated with the accident are fog/obscuration, and the pilot's failure to initiate a go-around earlier in the approach.NTSB LAX97FA148Accident · 1 fatalField investigationFinal reportCessna 152 · S. Lake Tahoe, CAThe pilot's collision with mountainous terrain due to his failure to follow published high density altitude departure procedures during climb out, and route selection which exceeded the airplane's maximum climb performance specifications. Also causal was the…NTSB LAX97LA141Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Avalon, CAThe pilot's misjudging the airplane's altitude and distance to the runway and an excessive descent rate, which led to an undershoot, and the pilot's failure to maintain an adequate airspeed during the approach. Contributing factors were the pilot's delay in…NTSB LAX97FA142Accident · 2 fatalField investigationFinal reportCessna P210N · Corona, CAThe pilot's failure to maintain adequate terrain clearance during a nighttime flight at low altitude through a mountainous area. Factors in the accident were the conditions of low clouds and dark light conditions.NTSB MIA97FA097Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Andrews, NCThe pilot's poor in-flight planning in attempting to maintain VFR conditions at night over mountainous terrain, and his failure to maintain clearance from the mountain. Contributing to the accident was: the pilot's inadequate preflight planning for not…NTSB FTW97TA115Accident · Minor injuriesFinal reportPiper PA-18-150 · Laredo, TXthe pilot allowed the airplane to get into an excessive rate of descent, during approach for an off-airport landing.NTSB ANC97LA078Accident · No injuriesLimited investigationFinal reportCessna 185F · Ketchikan, AKthe pilot allowed an excessive rate of descent to develope during an approach to land, and delayed in initiating a go-around.NTSB SEA97LA062Accident · Serious injuriesLimited investigationFinal reportHall Kitfox · Billings, MTThe pilot-in-command's failure to maintain flying airspeed while executing a downwind turn at low altitude immediately following takeoff.NTSB SEA97LA065Accident · No injuriesLimited investigationFinal reportHughes 269C · Hood River, ORThe pilot-in-command's misjudgment of altitude and airspeed during a turn.NTSB MIA97FA082Accident · 2 fatalField investigationFinal reportCessna 402C · St. ThomasThe failure of the pilot to maintain altitude while making a visual approach at night over water in black hole conditions resulting in the aircraft descending and crashing into the sea. Contributing to the accident was the failure of the pilot and operator to…NTSB CHI97FA067Accident · 1 fatalField investigationFinal reportCessna 150 · Larchwood, IAthe noninstrument-rated pilot's takeoff into instrument meteorological conditions. The weather was a factor.NTSB FTW97FA100Accident · 3 fatalField investigationFinal reportPiper PA-28-200 · Lone Wolf, OKthe pilot's impairment of judgment and performance due to drugs, his resultant improper planning/decision, and his failure to maintain sufficient altitude (clearance above a lake), while performing aerobatic flight. Factors relating to the accident were: the…NTSB NYC97LA050Accident · No injuriesLimited investigationFinal reportBerry Vans RV-4 · York, PAthe pilot's delay in initiating a go-around, and his failure to maintain airspeed, which resulted in an inadvertent stall/mush and contact with the terrain.NTSB ANC97LA021Accident · No injuriesLimited investigationFinal reportHefty Polar CUB · Anchorage, AKfailure of the pilot to maintain sufficient altitude/clearance from a snow berm during the landing. The snow berm and flat light conditions were related factors.NTSB ANC97LA019Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Dillingham, AKthe pilot's failure to maintain sufficient altitude or clearance from terrain during a go-around. A factor related to the accident was: the dark, night condition.NTSB SEA97LA046Accident · Serious injuriesLimited investigationFinal reportCessna TU-206 · Cascade, IDThe pilot's failure to maintain adequate altitude/clearance from the terrain while reversing course in mountainous terrain. Factors include the mountainous terrain and tall trees in the area where he was maneuvering.NTSB SEA97FA043Accident · 2 fatalField investigationFinal reportPiper PA-28R · Fort Smith, MTThe pilot's failure to maintain clearance from terrain. Factors include the pilot inadvertently becoming lost/disoriented, the dark night (minimum ambient light), and mountainous/hilly terrain.NTSB IAD97FA039Accident · 4 fatalField investigationFinal reportAerostar 601P · Chesapeake, VAfailure of the pilot to maintain proper altitude/clearance above the ground after takeoff. A related factor was the pilot's self-induced pressure to depart before the arrival of bad weather.NTSB MIA97FA047Accident · 2 fatalField investigationFinal reportChampion 7GCBC · Fort Lauderdale, FLIntentional aerobatics at too low an altitude that did not allow for recovery from an intentional maneuver. Contributing to the accident was the operation of the airplane at an overgross weight condition.NTSB FTW97FA073Accident · 2 fatalField investigationFinal reportCessna 210L · Brackettville, TXfailure of the pilot to maintain sufficient altitude and/or clearance from terrain, while on a cross-country flight at night. Factors relating to the accident were: darkness, the prevailing low ceilings, and mountainous/hilly terrain.NTSB NYC97FA194Accident · 2 fatalField investigationFinal reportLearjet 35A · Dorchester, NHThe captain's failure to maintain situational awareness, which resulted in the airplane being outside the confines of the instrument approach; and the crew's misinterpretation of a step-down fix passage, which resulted in an early descent into rising terrain.…NTSB FTW97FA067Accident · 6 fatalField investigationFinal reportBeech A36 · Chacon, NMThe pilot's failure to maintain altitude and clearance from the high, mountainous terrain. Factors were; high wind, turbulence, and mountain wave conditions.NTSB NYC97FA030Accident · 3 fatalField investigationFinal reportCessna 425 · Bohemia, NYthe pilot's early descent to decision height and his failure to perform the missed approach procedure. A factor was the failure of air traffic control to issue a safety advisory.NTSB LAX97LA068Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Lakeport, CAinadequate supervision by the flight instructor (CFI), and his delayed corrective action to the student pilot's abrupt control inputs, thereby allowing the main rotor blades to strike the ground. Factors relating to the accident were: the CFI's lack of…NTSB IAD97FA032Accident · 3 fatalField investigationFinal reportMbb BO-105CBS · Penn Yan, NYthe pilot's failure to maintain altitude/clearance from the terrain. Factors relating to the accident were: the pilot's diverted attention to the GPS, darkness, low ceiling, rising terrain, and high wind condition.NTSB FTW97LA059Accident · No injuriesLimited investigationFinal reportCessna 340 · El Dorado, TXthe pilot's inadequate compensation for wind conditions. The gusty wind was a related factor.NTSB SEA97LA036Accident · 2 fatalLimited investigationFinal reportPiper PA18-135 · Cohagen, MTThe pilot's failure to maintain airspeed. Factors were the intentional flight at a low altitude and the over gross condition of the airplane.NTSB LAX97FA065Accident · 2 fatalField investigationFinal reportOpperman Lancair IV-P · Suisun City, CAIn-flight loss of control for an undetermined reason.NTSB ANC97LA010Accident · No injuriesLimited investigationFinal reportCessna 172M · Bethel, AKthe pilot's improper planning/decision, and resultant failure to obtain/maintain sufficient airspeed during takeoff. A factor related the accident was: taking off with a tailwind.NTSB IAD97FA023Accident · Serious injuriesField investigationFinal reportBeech 65-A90 · Orange, VAThe pilot's inadequate preflight inspection and his failure to complete the pretakeoff checklist which resulted in a takeoff roll with the control lock in place.NTSB SEA97FA027Accident · 1 fatalField investigationFinal reportCessna P210N · Boring, ORThe pilot's attempt to conduct visual flight into instrument meteorological conditions. A factor contributing to the accident was the presence of thick fog.NTSB CHI97FA027Accident · 1 fatalField investigationFinal reportCessna T210N · Springfield, MOthe pilot's failure to set the altimeter to the current setting given by the controller resulting in the aircraft altimeter reading 260 feet higher than the actual aircraft altitude. Factors involved were pilot fatigue, weather conditions at approach…NTSB LAX97LA041Accident · No injuriesLimited investigationFinal reportBeech F33A · Marana, AZimproper planning/decision by the flight instructor (CFI), which resulted in his failure to recover from a descent during demonstration of a simulated (engine-out) emergency procedure.NTSB FTW97LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Plainview, TXthe pilot's continued descent below the minimum descent altitude (MDA). Factors relating to the accident were: darkness, the adverse weather conditions.NTSB ATL97FA014Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Avon Park, FLThe pilot's improper use of the elevator trim, which resulted in runway contact by the propeller during the takeoff roll and subsequent loss of aircraft control.NTSB CHI97LA008Accident · No injuriesLimited investigationFinal reportHughes 369E · Hesston, KSthe pilot selected unsuitable terrain for landing. The factors involved were: an inoperative landing light, dusk light conditions, and the terrain condition.NTSB SEA97LA010Accident · 1 fatalLimited investigationFinal reportPiper PA-36-300 · Prosser, WAfailure of the pilot to maintain clearance from the terrain, while en route to an apple orchard that he intended to spray. A factor relating to the accident was: the turbulent wind condition over the hills.NTSB FTW97FA014Accident · 1 fatalField investigationFinal reportMbb BO-105 CBS-4 · Cameron, LAthe pilot's failure to maintain clearance with terrain for undetermined reasons. Contributing factors were the dark night and pilot fatigue.NTSB LAX97LA009Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Jackpot, NVthe pilot's inadvertent disorientation in dark night time conditions and failure to maintain a proper climbing attitude.NTSB FTW97LA023Accident · Serious injuriesLimited investigationFinal reportAerostar RX 8 · Albuquerque, NMA sudden increase in wind velocity.NTSB LAX97FA003Accident · 4 fatalField investigationFinal reportCessna 172RG · Grand Canyon, AZthe pilot's inadequate preflight planning and preparation, which resulted in an inability to outclimb rising/wooded terrain after takeoff. Factors relating to the accident were: failure of the pilot to ensure that the aircraft's gross weight was not exceed…NTSB IAD97FA001Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Brandywine, MDThe pilots failure to maintain his assigned altitude in IFR conditions. A related factor was the failure of the radar controller to prevent the descent of N2881W to an altitude below the minimum vectoring altitude. Additionally, the controller's failure to…NTSB FTW97FA002Accident · 1 fatalField investigationFinal reportBell EAA Biplane P · Manzanola, COfailure of the pilot to maintain sufficient altitude/clearance above the terrain, while performing a low altitude maneuver. A factor relating to the accident was the pilot's lack of familiarity with this make and model of aircraft.NTSB FTW96LA403Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Watkins, COthe pilot-in-command's failure to use proper procedures and engage the turbochargers for takeoff from a high altitude airport. A factor was the high density altitude.NTSB LAX96FA339Accident · 1 fatalField investigationFinal reportCessna T207A · Littlefield, AZThe pilot's failure to maintain clearance with terrain during descent for undetermined reasons. Contributing factors were the dark night and mountainous terrain.NTSB NYC96LA184Accident · No injuriesLimited investigationFinal reportCessna 172N · Shirley, NYthe pilot's prematurely retraction of flaps during the go-around, which resulted in settling (mushing) of the airplane and a collision with the ground.NTSB FTW96TA383Accident · No injuriesFinal reportBell 47G-3B-1 · Rangely, COthe pilot's excessive cyclic control input during a low altitude operation, and his failure to maintain altitude/clearance from high vegetation (sage brush). The proximity of high vegetation was a related factor.