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 CEN10CA510Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Basile, LAThe loss of directional control during landing due to failure of the right brake for undetermined reasons.NTSB ANC10CA077Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Wasilla, AKThe pilot's failure to maintain directional control during landing, resulting in a runway excursion and nose over.NTSB WPR10LA429Accident · 2 fatalLimited investigationFinal reportFinney Thorp T-18 · Willcox, AZThe pilot’s failure to maintain sufficient airspeed during a steep turn and at a low altitude in the traffic pattern, which resulted in an aerodynamic stall.NTSB CEN10LA503Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Castroville, TXA loss of engine power due to the failure of the torque sensor bearing.NTSB ERA10LA442Accident · 1 fatalLimited investigationFinal reportStinson 108 · Andrews, SCLoss of engine power due to fuel exhaustion, and the student pilot's failure to adequately preflight the airplane prior to takeoff.NTSB ANC10FA076Accident · 2 fatalField investigationFinal reportPiper PA-11 · Willow, AKThe pilot’s failure to maintain adequate airspeed, which resulted in an aerodynamic stall/spin and impact with the ground.NTSB WPR10FA423Accident · Minor injuriesField investigationFinal reportCessna 182 · Ojai, CAA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN10LA502Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR20 · Porter, TXThe pilot's delay in performing a go-around, which resulted in an impact with trees.NTSB ERA10LA438Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Douglas, GAA loss of engine power during takeoff due to fuel contamination. Contributing to the accident was the pilot's inadequate preflight inspection and inadequate maintenance of the fuel system.NTSB ERA10CA440Accident · No injuriesData collectionFinal reportBeech P35 · Hartford, CTThe pilot's inadequate compensation for the crosswind, resulting in a loss of directional control during landing.NTSB WPR10LA417Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Mammoth Lakes, CAThe pilot’s failure to maintain adequate airspeed and airplane control during takeoff in high density altitude conditions, which resulted in an aerodynamic stall.NTSB CEN10LA491Accident · 2 fatalLimited investigationFinal reportSchneider Christen Eagle II · Clearwater, MNThe pilot's failure to maintain aircraft control and his improper decision to perform aerobatic maneuvers without proper experience or training in aerobatic flight. Also causal was his conduct of aerobatic flight in an airplane loaded outside its weight and…NTSB WPR10LA419Accident · No injuriesLimited investigationFinal reportHummel / Finberg Ultra Cruiser · Canby, ORThe loss of engine power due to low cylinder compression.NTSB WPR10CA418Accident · No injuriesData collectionFinal reportWilde Daniel L Zenith 701 · Turlock, CAThe pilot’s inadequate compensation for the crosswind and failure to maintain runway alignment.NTSB ERA10LA437Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Williamstown, NJThe partial loss of engine power during takeoff due to weak spark plugs on the No. 1 cylinder.NTSB ERA10FA435Accident · 2 fatalField investigationFinal reportNorth Wing Scout X-C · Amherst, VAThe pilot's loss of aircraft control for an undetermined reason.NTSB CEN10LA506Accident · No injuriesLimited investigationFinal reportAshcraft DR107 · Aurora, ILThe low cycle fatigue failure of the tail wheel spring during landing.NTSB ERA10LA439Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tunkhannock, PAA total loss of engine power during the initial climb due to the pilots' inadequate in-flight fuel management.NTSB CEN10LA497Accident · 1 fatalLimited investigationFinal reportMiller Charles W Vans RV-7A · El Dorado, ARThe pilot's failure to maintain clearance with trees on takeoff at night. Contributing factors were fatigue and the pilot's lack of recent nighttime experience.NTSB ANC10CA075Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Talkeetna, AKThe pilot’s failure to maintain aircraft control during an off airport landing.NTSB CEN10LA494Accident · No injuriesLimited investigationFinal reportCessna 310F · LaGrange, INThe pilot did not maintain altitude due to his distracted attention to a vibration of unknown origin.NTSB ANC10LA074Accident · No injuriesLimited investigationFinal reportCessna U206G · Homer, AKThe loss of engine power for an undetermined reason, resulting in an off-airport emergency landing and subsequent nose over.NTSB ERA10LA431Accident · 1 fatalLimited investigationFinal reportMaxair MU 582 Drifter · Old Forge, NYThe pilot's failure to use the full length of the lake, which necessitated a steep turn to avoid obstacles during takeoff that resulted in an accelerated stall.NTSB CEN10LA496Accident · No injuriesLimited investigationFinal reportCessna 182T · Mosby, MTA partial loss of engine power for undetermined reasons during an en route climb.NTSB ANC10CA070Accident · No injuriesData collectionFinal reportChampion 7EC · Soldotna, AKThe pilot’s failure to maintain adequate airspeed during the initial climb.NTSB WPR10LA408Accident · No injuriesLimited investigationFinal reportBeech V35B · Sacramento, CAA total loss of engine power during descent due to fuel exhaustion as a result of the pilot's failure to ensure that the fuel cap was secured during the preflight inspection.NTSB WPR10LA407Accident · 1 fatalLimited investigationFinal reportClark RV-6A · Nampa, IDThe pilot's failure to maintain aircraft control, which resulted in a collision with terrain during a rejected inadvertent takeoff.NTSB CEN10LA483Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Idabel, OKA loss of engine power for undetermined reasons.NTSB ERA10LA423Accident · Serious injuriesLimited investigationFinal reportBeech C24R · Eastover, NCThe uncommanded retraction of the nose gear for undetermined reasons and the pilot's improper decision to continue the takeoff after the propeller began to contact the ground.NTSB WPR10CA402Accident · No injuriesData collectionFinal reportCessna 182P · Compton, CAThe pilot's failure to attain the proper touchdown point that resulted in an overrun of the runway and collision with a wall.NTSB ERA10LA422Accident · 2 fatalLimited investigationFinal reportTaylorcraft BC12-D · Harrison, METhe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN10CA480Accident · Serious injuriesData collectionFinal reportBuckeye Industries Dream Machine · Seymour, INAn inadvertent encounter with turbulence which exceeded the performance capability of the powered parachute.NTSB CEN10CA479Accident · No injuriesData collectionFinal reportBeech A23-19 · Wichita, KSThe pilot’s loss of airplane control while landing with a gusting wind.NTSB WPR10FA399Accident · 2 fatalField investigationFinal reportPiper PA28R · Emigrant Gap, CAThe pilots’ failure to maintain sufficient altitude to clear terrain while maneuvering. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB WPR10CA400Accident · Minor injuriesData collectionFinal reportBeech C23 · Wenden, AZThe pilot’s inadequate bounced landing recovery and failure to maintain directional control during landing.NTSB WPR10CA372Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Garberville, CAThe pilot’s improper airspeed, misjudged approach, and failure to attain the proper touchdown point. Contributing to the accident was the pilot’s lack of familiarity with the airport.NTSB ERA10WA428Accident · 4 fatalForeign investigationRobinson R44 · Milazzo, ItalyOn August 12, 2010, about 0600 Universal Coordinated Time (UTC), a Robinson R44, Italian registration I-KOST, operated by Intesa Leasing, Rent and Fly, as a personal flight, collided with a building and the ground during takeoff from a private field at…NTSB ERA10CA417Accident · No injuriesData collectionFinal reportPiper PA-25-260 · St. Petersburg, FLThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN10LA492Accident · Serious injuriesLimited investigationFinal reportInfinity Infinity · Little Rock, ARThe failure of the control lanyard for undetermined reasons.NTSB CEN10LA476Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Winnfield, LAA loss of engine power due to fuel exhaustion.NTSB ANC10FA069Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · McGrath, AKThe pilot’s continued visual flight into instrument meteorological conditions and the airplane’s subsequent aerodynamic stall, which resulted in an in-flight collision with mountainous terrain.NTSB WPR10LA396Accident · No injuriesLimited investigationFinal reportGrumman G164 · Tracy, CAA total loss of engine power while maneuvering due to an internal catastrophic failure to the master rod and piston connecting rod links.NTSB WPR10FA397Accident · 2 fatalField investigationFinal reportAero Commander 500-B · Burns, ORThe non-instrument rated pilot's improper decision to continue flight into an area of known instrument meteorological conditions and his failure to maintain control of the airplane after entering those conditions.NTSB ERA10FA414Accident · 2 fatalField investigationFinal reportCessna 172 · Orange, MAThe pilots did not maintain control of the airplane during a flight in dark night conditions due to spatial disorientation.NTSB CEN10LA472Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Aspen, COThe pilot's failure to maintain directional control during takeoff in gusting crosswind conditions.NTSB WPR10LA393Accident · Minor injuriesLimited investigationFinal reportPiper PA18A · Billings, MTThe pilot's inadequate compensation for the wind conditions and failure to maintain lateral and directional control of the airplane during landing.NTSB ERA10LA424Accident · No injuriesLimited investigationFinal reportW.H. Hunnicutt Hobo · Fletcher, NCA partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to select an adequate forced landing site.NTSB ERA10LA410Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Eastman, GABoth pilots’ failure to use emergency checklist procedures for restarting the engine after the loss of engine power due to fuel starvation.NTSB ERA10FA409Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Washington, GAThe manufacturer's inadequate quality control and improper manufacture of the fuel servo diaphragm assembly, which resulted in fatigue cracking of the hub stud and subsequent loss of engine power due to fuel starvation.NTSB WPR10FA388Accident · 1 fatalField investigationFinal reportDiamond HK36 · Bend, ORAn condition, which could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation, that prompted the pilot to discontinue the flight. Contributing to the accident…