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 FTW96LA380Accident · Serious injuriesLimited investigationFinal reportBell UH-1H · Leadville, COThe pilot's improper inflight planning/decision in that he used an inadequate airspeed or an inadequate altitude, or both, for the intentional autorotation.NTSB MIA96LA228Accident · Minor injuriesLimited investigationFinal reportCanadair T-33 · Punta Gorda, FLfailure of the pilot to extend the wing flaps for takeoff, and his failure to attain sufficient airspeed for flight with the flaps retracted, which resulted in a stall/mush after lift-off.NTSB FTW96LA378Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Loreauville, LAThe pilot's inadequate preflight planning/preparation for the flight, resulting in exceeding the maximum gross weight and performance of the helicopter. A factor was the high density altitude.NTSB ANC96FA141Accident · 3 fatalField investigationFinal reportCessna 172 · Eagle River, AKThe first pilot's failure to maintain sufficient distance/altitude from terrain. A box canyon and mountainous terrain are factors in the accident.NTSB NYC96LA179Accident · No injuriesLimited investigationFinal reportPiper J-3 · Wildwood, NJThe pilot's failure to maintain sufficient altitude during a low altitude maneuver.NTSB ANC96LA135Accident · No injuriesLimited investigationFinal reportCessna 206 · Port Alsworth, AKthe pilot's improper in-flight planning/decision, which resulted in intering a box canyon with insufficient altitude to either execute a turn to safety or outclimb rising terrain. A factor associated with the accident was: the pilot allowed the passenger to…NTSB NYC96FA178Accident · 1 fatalField investigationFinal reportCessna 177 · Youngstown, OHthe pilot's delay in aborting the landing, and his failure to attain adequate airspeed to fly out of ground effect, which resulted in a stall/mush and collision with the ground. Factors relating to the accident were: the pilot's improper recovery from a…NTSB CHI96LA319Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Pittsburg, KSthe pilot diverted his attention and failed to maintain sufficient altitude and clearance with the terrain. Factors relating to the accident were: darkness, and the pilot performing low altitude flight at night.NTSB LAX96LA313Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Redlands, CAthe pilot's improper weather evaluation. The uphill runway condition and weather associated with thunderstorm(s) were related factors.NTSB ANC96LA127Accident · No injuriesLimited investigationFinal reportCessna 170B · Cantwell, AKA failure of the pilot to provide sufficient takeoff distance from the edge of the departure lake and his premature liftoff.NTSB NYC96FA163Accident · 1 fatalField investigationFinal reportBeech A36 · Roanoke, VAthe pilot's failure to follow the published instrument approach procedures, and his delayed missed approach, which resulted in an inflight collision with mountainous terrain.NTSB LAX96LA305Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Rosamond, CAThe pilot's inadequate preflight planning and his delayed decision to reverse the airplane's direction.NTSB LAX96TA298Accident · No injuriesFinal reportBell UH-1H · Ukiah, CAthe commercial/student pilot's improper/abrupt use of aft cyclic during the flare, and the instructor's inadequate supervision of the flight.NTSB IAD96LA129Accident · Minor injuriesLimited investigationFinal reportAerofab Lake 250 · Adirondack, NYthe pilot's improper in-flight planning/decision, which resulted in his failure to ensure that he could maintain sufficient altitude and clearance from mountainous terrain after entering a blind canyon. Haze and the terrain were related factors.NTSB ANC96FA118Accident · 1 fatalField investigationFinal reportCessna P206 · Nome, AKThe pilot's failure to maintain terrain clearance. Factors include mountainous terrain, low ceilings and mountain obscuration.NTSB ANC96LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKThe pilot's improper approach to landing, and his delay in initiating a go-around.NTSB SEA96FA170Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Libby, MTcollision with rising mountainous terrain for unknown reason(s).NTSB IAD96LA120Accident · No injuriesLimited investigationFinal reportCessna 172 · Stowe, VTfailure of the pilot to follow proper IFR procedures and to maintain proper terrain clearance (altitude) during an NDB approach. Factors related to the accident were: the pilot's lack of instrument experience, low ceiling, and mountainous terrain.NTSB ANC96FA101Accident · 1 fatalField investigationFinal reportde Havilland DHC-2 · Elfin Cove, AKThe pilot's decision to continue VFR flight into instrument meteorological conditions, and his failure to maintain adequate clearance from rising terrain. Factors associated with the accident were the rising terrain and clouds.NTSB NYC96FA152Accident · 1 fatalField investigationFinal reportChampion 7GCBC · Farmingdale, NJthe pilot's improper handling of the airplane during a banner pickup maneuver, which resulted in a stall/mush and collision with the ground. A factor relating to the accident was: the pilot's lack of experience in the type of operation.NTSB SEA96LA159Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Pullman, WAfailure of the pilot to maintain terrain clearance during a swath run. Factors relating to the accident were: unfavorable (variable) wind conditions, low airspeed, and uneven terrain.NTSB FTW96LA307Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Beedeville, ARThe pilot's failure to maintain terrain clearance.NTSB CHI96LA242Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Belle Plaine, MNthe pilot's misjudgment of the distance and speed during the landing, and his delay in initiating a go-around. Factors relating to the accident were: the tall grass and ravine at the end of the runway.NTSB CHI96LA234Accident · No injuriesLimited investigationFinal reportCessna 172L · Vicksburg, MIthe pilot's premature raising of the flaps during a go-around. The presence of birds was a factor.NTSB CHI96LA232Accident · No injuriesLimited investigationFinal reportCessna 188 · Independence, IAthe delayed jettison of the dry chemicals by the pilot. The inability of the airplane to climb was a related factor.NTSB LAX96LA265Accident · Minor injuriesLimited investigationFinal reportCessna 150L · California City, CAThe pilot's selection of an inadequate cruise altitude in an area of rising terrain and his failure to consider the effect of the high density altitude on the climb capability of the aircraft.NTSB LAX96LA263Accident · No injuriesLimited investigationFinal reportBell 47G3 · Wasco, CAthe pilot's failure to maintain adequate engine rpm during an aerial application flight.NTSB IAD96LA113Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75N1 · Goshen, OHthe pilot's failure to maintain adequate clearance from terrain during short final approach/landing flare. The hot temperature was a related factor.NTSB SEA96LA143Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Sun Valley, IDthe pilot's inadequate compensation for wind conditions and failure to obtain/maintain adequate airspeed for the go-around. The crosswind, downdraft, and high density altitude were related factors.NTSB LAX96LA247Accident · Serious injuriesLimited investigationFinal reportCessna R172K · Oroville, CAundetermined.NTSB CHI96LA220Accident · 1 fatalLimited investigationFinal reportGrumman AA5B · Fryburg, NDthe pilot's VFR flight into instrument meteorological conditions. Factors were the fog, low ceiling, and rising terrain.NTSB CHI96LA214Accident · No injuriesLimited investigationFinal reportSchweizer 2-33 · Union, ILThe pilots misjudgment of the altitude and distance to the runway.NTSB SEA96FA133Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Pomeroy, WAThe pilot's failure to maintain adequate clearance with the surrounding terrain while maneuvering to land. A factor was the rising terrain conditions.NTSB CHI96FA211Accident · 1 fatalField investigationFinal reportMcDonnell Douglas F/A-18C · Bethalto, ILthe pilot's failure to follow the preflight crew briefing and attain a proper altitude during an aerobatic maneuver. Factors in the accident were: the pilot's previous experience of flying similar airshow routines in a different airplane with substantially…NTSB FTW96TA261Accident · Minor injuriesFinal reportBell 212 · Pagosa Springs, COThe pilot's failure to comply with performance data for hover out of ground effect. A factor was not attaining load jettison.NTSB LAX96FA244Accident · 2 fatalField investigationFinal reportCessna 152 · Carmel, CAThe pilot becoming lost and disoriented during a night VFR flight in marginal weather conditions. Factors in the accident were: the pilot's lack of night flying experience, his failure to obtain a preflight weather briefing, low ceilings, and his failure to…NTSB ANC96LA089Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nikiski, AKThe pilot's premature lift-off during the takeoff roll. The pilot's selection of unsuitable terrain for takeoff was a factor in the accident.NTSB SEA96GA129Accident · Minor injuriesFinal reportCessna 182R · Grand View, IDfailure of the pilot to maintain clearance from mountainous terrain in a box canyon. The mountainous terrain and box canyon, limiting the pilot's ability to climb or maneuver and maintain sufficient altitude in the canyon, were related factors.NTSB NYC96FA126Accident · 3 fatalField investigationFinal reportPiper PA-23-150 · Cortland, NYthe pilot failure to maintain directional control of the airplane which resulted in the airplane striking trees. Contributing factors were the pilot's spatial disorientation, dark night conditions, fog, and the pilot's self induced pressure to reach the…NTSB LAX96LA230Accident · Minor injuriesLimited investigationFinal reportAyres S2R · Oracle, AZthe pilot's improper decision to turn toward rising terrain, without releasing or jettisoning the load of fire retardant, while maneuvering at slow airspeed, which resulted in a stall/mush and collision with the terrain. Factors relating to the accident were:…NTSB LAX96LA220Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Placerville, CAthe pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain sufficient altitude to clear surrounding terrain. A factor was the pilot's intentional buzzing.NTSB SEA96LA115Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Tooele, UTfailure of the flight instructor (CFI) to ensure that adequate airspeed was maintained during initial climb after lift-off, which resulted in an inadvertent stall/mush. High density altitude was a related factor.NTSB SEA96LA112Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Prescott, WAfailure of the pilot to visually clear his flight path, after allowing his attention to be diverted, and his resultant failure to maintain sufficient altitude/clearance from a hill. The hilly terrain was a related factor.NTSB CHI96LA188Accident · 1 fatalLimited investigationFinal reportGray Miniplane DSA-1-G · Astoria, ILthe pilot's failure to maintain clearance with the terrain while performing an aerobatic maneuver.NTSB CHI96LA180Accident · No injuriesLimited investigationFinal reportCessna 152 · Eau Claire, WIthe flight instructor's inadequate supervision. A factor relating to the accident was: the student pilot's improper flare.NTSB SEA96LA097Accident · No injuriesLimited investigationFinal reportPowers Bede BD-4 · Pacific City, ORthe pilot's inadequate compensation for wind conditions during the landing flare, and his failure to maintain runway alignment, which resulted in an encounter with tall grass beside the intended landing area. Factors relating to the accident were: the…NTSB ANC96FA079Accident · 2 fatalField investigationFinal reportRepublic RC-3 Seabee · Ketchikan, AKthe airplane crashed for undetermined reason(s).NTSB SEA96LA093Accident · Serious injuriesLimited investigationFinal reportCrescenzi Kitfox · Terrebonne, ORThe pilot's inadequate compensation for wind conditions and failure to maintain altitude/clearance above terrain, while maneuvering to land. The unfavorable wind was a related factor.NTSB FTW96FA200Accident · 1 fatalField investigationFinal reportNorth American Harvard MK II · Lafayette, LAfailure of the pilot to maintain adequate airspeed and/or altitude, while performing aerobatic flight.NTSB ANC96LA066Accident · No injuriesLimited investigationFinal reportSwearingen SW-4 · St George, AKfailure of the captain to maintain proper altitude and wingtip clearance, while aligning the airplane with the runway before landing. His delay in aligning the aircraft with the runway was a related factor.