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 ERA09LA392Accident · 1 fatalLimited investigationFinal reportNoles Vance L Vans RV7A · Sanderson, FLThe pilot's continued visual flight into instrument meteorological conditions with convective activity and thunderstorms. Contributing to the accident was his failure to get an adequate weather briefing.NTSB ERA09LA388Accident · Serious injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Oakland, MSA total loss of engine power while maneuvering (after performing aerobatics) for undetermined reasons.NTSB ERA09CA390Accident · No injuriesData collectionFinal reportPiper J3C · South Charleston, WVThe pilot's failure to maintain control during the attempted go-around.NTSB CEN09CA423Accident · No injuriesData collectionFinal reportLewis Keith O Viggenite · Chesterfield, MOThe loss of engine power for unknown reasons.NTSB ERA09LA385Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Brinson, GAThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of experience in the make and model airplane.NTSB ANC09CA060Accident · Serious injuriesData collectionFinal reportBellanca 8GCBC · Sutton, AKThe pilot’s failure to maintain control of the airplane after an in-flight encounter with a downdraft in mountainous terrain, and his decision to fly at an altitude where such an encounter made a successful recovery unlikely.NTSB WPR09LA327Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Taylor, AZThe loss of engine power for undetermined reasons.NTSB WPR09CA332Accident · Minor injuriesData collectionFinal reportCessna 182M · Wilson Bar, IDThe pilot’s misjudged approach that led to a long landing and his failure to execute a go-around when he realized that he overshot his intended point of landing.NTSB WPR09FA326Accident · 1 fatalField investigationFinal reportCessna 150 · South Lake Tahoe, CAA partial loss of engine power due to a malfunctioning carburetor and the pilot’s failure to maintain adequate airspeed while maneuvering to return to the runway. Contributing to the accident was the high density altitude.NTSB ERA09FA377Accident · 2 fatalField investigationFinal reportCessna 400 · Huntington, WVThe pilot's failure to maintain control of the airplane due to spatial disorientation.NTSB ERA09FA376Accident · 4 fatalField investigationFinal reportPilatus PC-12/45 · Raphine, VAThe pilot's failure to maintain control of the airplane while in instrument meteorological conditions following a reported instrumentation failure for undetermined reasons.NTSB ERA09CA381Accident · Serious injuriesData collectionFinal reportThompson David Challenger · Waymart, PAThe pilot's failure to maintain adequate airspeed during approach to land resulting in a stall.NTSB CEN09CA408Accident · Serious injuriesData collectionFinal reportCessna 150B · Conway, ARThe total loss of engine power for undetermined reasons.NTSB ANC09CA061Accident · No injuriesData collectionFinal reportAirborne Edge 582 T · Fairbanks, AKThe pilot's failure to maintain control of the airplane while on approach to land, resulting in an in-flight collision with terrain. Contributing to the accident was the pilot's lack of experience.NTSB WPR09LA325Accident · 2 fatalLimited investigationFinal reportAero Vodochody L-29 · Tehachapi, CAThe pilot’s failure to maintain clearance from terrain while performing a low altitude maneuver.NTSB ERA09LA380Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Westerly, RIThe pilot's failure to use carburetor heat resulting in a complete loss of engine power due to carburetor icing.NTSB ERA09LA379Accident · No injuriesLimited investigationFinal reportCessna 172M · Princeton, NJThe partial loss of engine power for undetermined reasons.NTSB CEN09CA510Accident · No injuriesData collectionFinal reportWohnoutka Steven M Team Z MAX · Iowa, LAA total loss of engine thrust during initial climb due to the failure of the airplane's propeller as a result of preexisting damage.NTSB WPR09LA330Accident · Serious injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Tracy, CAThe loss of engine power for undetermined reasons.NTSB WPR09LA324Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Tucson, AZThe pilot’s failure to maintain directional and lateral aircraft control during takeoff. Contributing to the accident was the partial loss of left engine power for undetermined reasons.NTSB ERA09CA382Accident · No injuriesData collectionFinal reportCessna 172H · Clifton, METhe pilot's mismanagement of his fuel supply which resulted in fuel starvation and a loss of engine power.NTSB CEN09IA438Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Put-In-Bay, OHThe pilot's failure to maintain directional control while landing with a crosswind.NTSB CEN09FA405Accident · 1 fatalField investigationFinal reportBeech C35 · Weslaco, TXThe pilot's failure to maintain aircraft control while operating with a fuel imbalance. Contributing to the accident was the pilot/owner's decision to fly the airplane outside of the operating limitations.NTSB CEN09CA410Accident · No injuriesData collectionFinal reportCessna 150 · Bloomington, ILThe complete loss of engine power as a result of fuel exhaustion due to the pilot's inadequate preflight.NTSB CEN09LA413Accident · Serious injuriesLimited investigationFinal reportBell Helicopter Textron 206L-1 · Breckenridge, COThe pilot's failure to maintain directional control while maneuvering due to a loss of tail rotor effectiveness. Contributing to the accident was the pilot's failure to monitor wind direction while operating in the "Critical Wind Azimuth Area."NTSB CEN09CA414Accident · No injuriesData collectionFinal reportMooney M20 · Steamboat Springs, COThe pilot's improper pitch control during the go-around, which resulted in an aerodynamic stall.NTSB CEN09LA403Accident · Serious injuriesLimited investigationFinal reportAyres S2R-G6 · Ainsworth, IAA component failure of the fuel control unit, which resulted in a loss of engine power.NTSB WPR09CA479Accident · Minor injuriesData collectionFinal reportSchleicher ASK-21 · Jean, NVThe pilot's failure to maintain control of the glider during the initial climb due to an inadvertent encounter with wind.NTSB WPR09LA318Accident · 1 fatalLimited investigationFinal reportAlexander Schleicher ASW 27-18E · Ephrata, WAThe pilot’s failure to maintain control of the glider during flight and his exceedance of the glider’s design limits during an attempted recovery from a spin.NTSB WPR09LA317Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Ventus 2CM · Paragonah, UTThe glider departed controlled flight for undetermined reasons.NTSB CEN09LA400Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Bastrop, TXA loss of engine power due to fuel exhaustion as a result of the pilot's failure to properly verify the fuel load prior to departure.NTSB CEN09LA396Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Shelbyville, INThe partial loss of engine power due to the failure of the mixture control cable. Contributing to the accident was the inadequate maintenance on the airplane and the pilot's decision to operate the airplane in a condition that was not airworthy.NTSB CEN09CA459Accident · Minor injuriesData collectionFinal reportCessna 172P · Usafa, COThe pilot's failure to maintain a safe flying airspeed resulting in an inadvertent stall during the go-around.NTSB ERA09LA400Accident · Serious injuriesLimited investigationFinal reportApollo Monsoon · Kanona, NYThe pilot's loss of control while landing in convective weather conditions. Contributing to the accident was his misjudgment of the approaching weather.NTSB WPR09FA309Accident · 4 fatalField investigationFinal reportBeech B95 · Holbrook, AZThe pilot’s decision to depart when ill and his failure to maintain control of the airplane during a return to the airport, likely because of his physical illness and drug impairment.NTSB ERA09LA369Accident · 2 fatalLimited investigationFinal reportP&M Quikr · Cedar Town, GAA loss of aircraft control for an undetermined reason.NTSB ERA09LA368Accident · Serious injuriesLimited investigationFinal reportPitts Aerobatics S-2B · Woodbine, NJA loss of engine power due to fuel starvation as a result of the pilot's improper fuel transfer in flight.NTSB CEN09CA412Accident · Minor injuriesData collectionFinal reportQuicksilver Mxii Sport · Longmont, COThe loss of engine power for undetermined reasons.NTSB ERA09CA366Accident · Minor injuriesData collectionFinal reportCessna 210-5(205) · Porterdale, GAThe loss of engine power due to fuel exhaustion as a result of the pilot's use of improper fuel caps. Contributing to the accident was the pilot’s selection of an unsuitable area for landing.NTSB CEN09CA386Accident · No injuriesData collectionFinal reportHubbell Prescott Pusher · Ashville, OHA partial loss of engine power due to propeller damage from being struck by the cabin-entry door, which inadvertently opened and departed the airframe for undetermined reasons during flight.NTSB CEN09CA383Accident · No injuriesData collectionFinal reportPietenpol GN-1 · Waxahachie, TXThe pilot's failure to maintain control of the airplane during a landing.NTSB CEN09CA382Accident · Serious injuriesData collectionFinal reportBakeng Deuce · Beach City, TXThe loss of engine power due to fuel starvation resulting from a partially crimped fuel tank vent tube.NTSB WPR09LA308Accident · 2 fatalLimited investigationFinal reportMayo RV-6A · Cottonwood, AZThe partial loss of engine power for undetermined reasons, and the pilot's failure to maintain an adequate airspeed, which resulted in an inadvertent stall/spin.NTSB CEN09LA375Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Mineola, TXThe pilot's failure to maintain control of the airplane during taxi, and his subsequent failure to maintain control after the inadvertent takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of flight experience.NTSB CEN09FA377Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Sanborn, IAA loss of engine power due to fuel exhaustion as a result of the pilot's improper fuel planning and failure to refuel.NTSB CEN09CA420Accident · No injuriesData collectionFinal reportAviat Husky · Greenfield, INThe pilot failed to maintain directional control of the airplane during the takeoff roll.NTSB CEN09CA381Accident · Minor injuriesData collectionFinal reportCessna 177B · Elyria, OHThe student pilot's failure to maintain aircraft control and adequate airspeed during the aborted landing, which resulted in an aerodynamic stall at a low altitude.NTSB CEN09WA612Accident · 2 fatalForeign investigationEurocopter AS350 · Barcelona, SpainOn June 22, 2009 a Eurocopter AS350B3, Spanish registration EC-IOJ was destroyed while filling the fire attack system with water during a fire extinguishing operation. The pilot and passenger both were killed. According to several witness statements, the…NTSB WPR09LA302Accident · No injuriesLimited investigationFinal reportMooney M20TN · San Jose, CAThe pilot's improper landing flare in gusting wind conditions resulting in a collision with an airport sign.NTSB WPR09LA301Accident · Serious injuriesLimited investigationFinal reportPaul Antares · Petaluma, CAThe pilot's failure to maintain aircraft control while landing in gusting winds.