NTSB investigations
10,134 cases where the sequence of events included Collision with terr/obj (non-CFIT).
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CHI08CA121Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Vermillion, SDThe pilot's failure to adequately compensate for the crosswind condition. Contributing to the accident were the crosswind and the soft terrain.NTSB LAX08CA114Accident · No injuriesData collectionFinal reportMurphy Murphy Rebel · Grass Valley, CAThe pilot's failure to maintain directional control.NTSB DEN08LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Reserve, NMThe pilot's loss of aircraft control, resulting in an inadvertent stall. Contributing factors in this accident were the sudden windshift to a gusting tailwind, an uphill runway, high density altitude, the pilot's failure to use all available runwayt, and his…NTSB LAX08FA109Accident · Serious injuriesField investigationFinal reportPiper PA-23-160 · San Dimas, CAA loss of engine power in the left engine due to fuel starvation as a result of the pilot's inadequate preflight inspection and the pilot's failure to abort the takeoff following the power loss.NTSB DEN08LA077Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Angleton, TXThe pilot's inadequate visual lookout and his failure to maintain clearance from the tranmission lines. A factor in this accident was the unmarked transmission wires.NTSB DEN08GA076Accident · 1 fatalFinal reportAir Tractor AT-602 · Fort Carson, COThe pilot's failure to maintain aircraft control following the jettison of the load during an aerial fire flighting mission, which resulted in an inadvertent stall and impact with terrain. Contributing to the accident were the improperly configured aircraft…NTSB LAX08LA108Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Columbia, CAThe flight instructor's decision to attempt takeoff with an engine discrepancy and subsequent failure to abort takeoff when the airplane did not attain adequate airspeed during the initial climb, resulting in an aerodynamic stall. Contributing to the accident…NTSB ANC08FA053Accident · 4 fatalField investigationFinal reportEurocopter AS 350 B2 · Chickaloon, AKAn in-flight overtorque of the engine-to-transmission driveshaft resulting in disconnection of the main transmission from the engine. The overtorque likely occurred due to an in-flight main rotor blade contact with snow-covered terrain, precluding significant…NTSB LAX08LA103Accident · Serious injuriesLimited investigationFinal reportArtic S-1B2 · Rock River, WYThe pilot's failure to maintain an adequate airspeed while maneuvering that led to an inadvertent stall. A contributing factor in the accident was the low altitude of the flight that reduced the time available for recovery from an upset.NTSB MIA08LA089Accident · 1 fatalLimited investigationFinal reportDayon Lancair Legacy · Lakeland, FLThe pilot's failure to maintain aircraft control. Contributing to the accident was the pilot's distraction with the canopy during takeoff.NTSB DEN08IA080Incident · No injuriesIncident investigationFinal reportHill Hatz CB-1 · Erie, COthe pilot's failure to maintain directional control during landing. A contributing factor was the gusty wind conditions.NTSB ANC08LA052Accident · Minor injuriesLimited investigationFinal reportPiper J5A · Big Lake, AKA loss of engine power during takeoff/initial climb for an undetermined reason.NTSB NYC08CA166Accident · No injuriesData collectionFinal reportWim J Huisman Velocity 173 Fixed · Ocala, FLThe pilot's failure to maintain directional control during the landing. Contributing to the accident was the wind gusts.NTSB LAX08FA101Accident · Serious injuriesField investigationFinal reportCessna 310Q · Compton, CAThe loss of both engines' power during approach due to fuel exhaustion that resulted from the pilot's inadequate preflight inspection and failure to verify the quantity of fuel on board the airplane.NTSB LAX08CA100Accident · Minor injuriesData collectionFinal reportQuestair Venture · Salt Lake City, UTThe failure of the left side master brake cylinder that led to a loss of braking capability during landing rollout. A contributing factor was the presence of a ditch next to the runway's end.NTSB DEN08CA075Accident · No injuriesData collectionFinal reportCessna 182N · Amarillo, TXThe pilot's failure to maintain aircraft control during the landing. Contributing to the accident were the crosswind, gusty wind conditions and the pilot's inadequate compensation for the wind conditions.NTSB ANC08CA051Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Stevensville, MDThe pilot's misjudged speed/distance during landing.NTSB LAX08CA110Accident · Serious injuriesData collectionFinal reportSnobird Charger · Toledo, WAThe pilot's improper use of the flight controls during takeoff.NTSB DEN08LA074Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5A · Beaumont, TXThe pilot's inability to maintain aircraft control in cruise flight and encounter with a thunderstorm. Contributing to the accident was an inadvertent stall/spin.NTSB CHI08LA101Accident · 2 fatalLimited investigationFinal reportCessna 172K · Roseglen, NDThe pilot failed to maintain obstacle clearance from the TV antenna during a low altitude maneuver. Contributing factors were the antenna, the night conditions, and pilot impairment due to alcohol.NTSB ANC08FA050Accident · Serious injuriesField investigationFinal reportGrumman G-21A · Unalaska, AKThe pilot's failure to maintain clearance from a truck while landing, and the vehicle operator's decision to ignore runway warning signals. Contributing to the accident was an inoperative vehicle gate system and the failure of airport management to adequately…NTSB LAX08CA095Accident · No injuriesData collectionFinal reportCurtiss-Wright Travel Air 4000 · Carlsbad, CAThe pilot's inadequate crosswind compensation and failure to maintain directional control during landing rollout.NTSB DFW08LA095Accident · No injuriesLimited investigationFinal reportHawker Beechcraft G36 · El Dorado, KSThe improper installation of the fuel manifold valve's brass plug. Contributing to the accident was the unsuitable landing area for the forced landing.NTSB SEA08CA109Accident · No injuriesData collectionFinal reportPiper J3C-65 · Bisbee, AZThe pilot's failure to obtain/maintain sufficient airspeed after takeoff, which resulted in a stall/mush condition.NTSB SEA08LA105Accident · 1 fatalLimited investigationFinal reportGlasair Glasair III · Cheyenne, WYThe pilot's improper decision to continue VFR flight into instrument meteorological weather conditions. Contributing to the accident were low ceilings, snow and whiteout conditions.NTSB SEA08CA107Accident · No injuriesData collectionFinal reportCessna 152 · Tucson, AZThe pilot's inadequate compensation for the gusty wind condition, which resulted in a loss of control and impact with terrain while landing. A contributing factor was the gusty wind condition.NTSB NYC08FA157Accident · 2 fatalField investigationFinal reportCartwright H Jr/Cottrell M RV-10 · Seale, ALThe pilot-in-command's in-flight loss of control due to spatial disorientation. Contributing to the accident were the weather conditions and the pilot-in-command's lack of flight experience in the accident airplane.NTSB NYC08CA159Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Vero Beach, FLThe student pilot's loss of directional control on landing. Contributing to the accident was the crosswind and wind gusts.NTSB NYC08LA152Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Louisville, KYThe pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall/spin.NTSB NYC08CA154Accident · Minor injuriesData collectionFinal reportAmerican AA-1A · Alabaster, ALThe pilot's failure to utilize carburetor heat during a power off approach.NTSB NYC08CA153Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Lincoln, METhe pilot-rated-passenger's failure to maintain directional control during takeoff.NTSB MIA08CA087Accident · No injuriesData collectionFinal reportAmerican Grumman AA 1B · State College, PAA partial loss of engine power for an undetermined reason.NTSB DFW08CA096Accident · No injuriesData collectionFinal reportCessna C-182 · Porter, TXThe pilot's loss of directional control due to the partial failure of the left brake.NTSB DEN08CA073Accident · No injuriesData collectionFinal reportCessna 170B · Fort Collins, COthe pilot's failure to maintain directional control during takeoff.NTSB CHI08CA105Accident · No injuriesData collectionFinal reportSchultz Mini 500 · Batavia, OHThe failure of the helicopter's centrifugal clutch during hover which led to the pilot's inability to maintain control of the craft and its subsequent impact with the ground.NTSB DFW08TA092Accident · No injuriesFinal reportRobinson R44 · Topeka, KSA malfunctioning magneto, resulting in a high engine rpm and low rotor warning indications. A contributing factor was the impact with a light pole, during the precautionary landing.NTSB SEA08CA103Accident · Minor injuriesData collectionFinal reportPiper PA-28-236 · Alturas, CAThe pilot's inadequate compensation for the gusty crosswind conditions. The wind gusts were a contributing factor.NTSB DEN08LA071Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · La Porte, TXThe loss of tail rotor effectiveness. Contributing factors were the sudden windshift to a tailwind, and the pilot initiating a hovering turn in ground effect.NTSB CHI08CA114Accident · Minor injuriesData collectionFinal reportBardouche Quad City Ultralight · Pulaski, WIThe loss of engine power during cruise due to the separation of the spark plug because of the loose threads. Contributing to the accident was trees.NTSB SEA08CA102Accident · No injuriesData collectionFinal reportPiper PA-22/20 · Three Forks, MTThe pilot's inadequate compensation for wind conditions during landing. A gusting crosswind was a contributing factor.NTSB NYC08CA151Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Columbus, GAThe flight instructor's improper decision to abort the takeoff after the cabin door latch opened. Contributing to the accident was the cabin door unlatching.NTSB LAX08FA092Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Benson, AZThe pilot's misjudged speed and altitude during approach that led to a long landing and his subsequent failure to maintain control during an attempted go-around. Contributing to the accident were the dark night, the pilot's low total night flight experience,…NTSB CHI08CA103Accident · No injuriesData collectionFinal reportKoleno Titan T-51 · Geneva, OHThe failure of the propeller pitch control mechanism during approach. Contributing to the accident were the inability of the pilot to maintain airspeed and altitude, and the unsuitable terrain.NTSB LAX08IA093Incident · No injuriesIncident investigationFinal reportBennett Lancair 320 · Hillsboro, ORThe malfunction of the airplane's battery and alternator that resulted in the failure of the landing gear to extend and lock in place.NTSB SEA08LA101Accident · Minor injuriesLimited investigationFinal reportJihlavan KP 5 ASA · Marana, AZThe pilot's failure to maintain an airspeed above stalling speed (Vs) during an emergency landing after takeoff. Contributing to the accident was an inadequate preflight inspection, and the airplane's canopy coming partially open shortly after takeoff.NTSB SEA08LA100Accident · No injuriesLimited investigationFinal reportCessna 182A · Buckeye, AZA loss of engine power for undetermined reasons. Contributing to the accident was the soft terrain.NTSB LAX08CA111Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Grand Canyon, AZThe pilot's inadequate compensation for the wind conditions and delay in aborting the takeoff. Contributing to the accident were wind gusts and a crosswind.NTSB SEA08CA099Accident · No injuriesData collectionFinal reportBeechcraft 35-C33A · Prescott, AZFuel starvation due to the pilot's improper preflight and failure to select a tank containing fuel before takeoff.NTSB NYC08LA150Accident · Serious injuriesLimited investigationFinal reportHatle Rans S-12 · Rincon, GAThe pilot's failure to maintain airspeed during initial climb which led to an aerodynamic stall.NTSB MIA08CA084Accident · No injuriesData collectionFinal reportGrumman American AA5B · Marlboro, MAThe pilot's inadequate compensation for wind gusts while on final approach.