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 ERA09FA537Accident · 3 fatalField investigationFinal reportEurocopter AS-350 · Georgetown, SCThe pilot’s decision to continue the visual flight rules flight into an area of instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and a loss of control of the helicopter. Contributing to the accident was the inadequate…NTSB ERA09WA546Accident · 2 fatalForeign investigationPiper PA18 · Barbones, Ecuador, EcuadorOn September 25, 2009, about 1330 central standard time, a Piper PA-18-150, Ecuadorian registration HC-AHD, registered to and operated by FumiPalma S.A., crashed following a loss of engine power, while on an approach for landing at the Pista Bardones, El Oro,…NTSB ERA09CA545Accident · No injuriesData collectionFinal reportKermit Weeks Quicksilver · Polk City, FLThe pilot’s failure to adequately inspect the landing gear floats for water prior to takeoff.NTSB CEN09LA605Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Troy, MIA loss of engine power during initial climb due to fuel starvation as a result of the pilot's selection of an empty or nearly empty main tank for takeoff.NTSB WPR09LA463Accident · 1 fatalLimited investigationFinal reportFrazier Tangent · Nampa, IDThe pilot's failure to maintain pitch control of the airplane.NTSB ERA09LA536Accident · 1 fatalLimited investigationFinal reportDuke Paul Challenger II · Lumberton, MSThe non-certificated pilot’s failure to maintain clearance from trees during a go-around procedure for unknown reasons.NTSB ERA09CA535Accident · No injuriesData collectionFinal reportC A Tecnam P2002 Sier · Enterprise, ALThe student pilot's failure to maintain control during the landing roll.NTSB CEN09WA598Accident · 2 fatalForeign investigationSchweizer 269C · Blackpool, United KingdomOn September 22, 2009, at 1104 universal coordinated time, a Schweizer 269C helicopter, United Kingdom registered G-LINX, registered to Heli-Lynx Limited, was destroyed when it impacted terrain near Blackpool, Lancashire, England. Visual meteorological…NTSB CEN09LA597Accident · 1 fatalLimited investigationFinal reportPiper PA-12 · Columbia, MOThe pilot's continued visual flight into instrument meteorological conditions, which included low ceilings and fog, and his failure to maintain control of the airplane. Contributing to the accident was the partial loss of engine power as a result of water…NTSB WPR09FA459Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Forest Grove, ORThe flight crew’s failure to maintain adequate main rotor speed while maneuvering, which resulted in a main rotor blade stall and an uncontrolled descent into terrain.NTSB ERA09LA532Accident · No injuriesLimited investigationFinal reportRyan Navion · Fire Island, NYA total loss of engine power during cruise flight due to fuel starvation as a result of a deteriorated fuel gasket.NTSB ERA09LA531Accident · Minor injuriesLimited investigationFinal reportDaniel L Patrick Kolb Mark · Mystic, CTThe pilot's failure to maintain airspeed during final approach, resulting in an inadvertent stall. Contributing to the accident was the pilot's lack of total flight experience.NTSB ERA09FA526Accident · 4 fatalField investigationFinal reportPiper PA-32R-301T · Fort Lauderdale, FLFatigue failure of the No. 5 engine cylinder fuel supply line, which resulted in an engine compartment fire. Also causal was the pilot's failure to immediately secure the engine/perform a forced landing after discovery of the fire, which resulted in the…NTSB ERA09LA527Accident · 2 fatalLimited investigationFinal reportCessna 172 · Lowndesville, SCThe pilot's inadequate preflight planning and improper decision to continue flight into deteriorating weather conditions, which resulted in spatial disorientation after entering instrument flight conditions.NTSB ERA09CA533Accident · No injuriesData collectionFinal reportCessna 182 · Montauk, NYThe pilot’s failure to attain the proper touchdown point while landing.NTSB CEN09CA596Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Princeton, MNThe pilot's failure to maintain directional control during landing.NTSB ERA09LA528Accident · No injuriesLimited investigationFinal reportMooney M20K · Farmville, VAThe pilot’s failure to maintain directional control during the landing rollout.NTSB ERA09FA524Accident · Serious injuriesField investigationFinal reportCurtis John P SEA REY · Winter Haven, FLThe flightcrew's failure to maintain adequate airspeed while maneuvering during a simulated engine failure, resulting in an aerodynamic stall and uncontrolled descent.NTSB CEN09CA589Accident · Serious injuriesData collectionFinal reportDiehl KR-2 · Mt. Vernon, ILThe pilot's improper landing flare while landing with gusting winds and his failure to perform a go-around.NTSB ANC09LA100Accident · No injuriesLimited investigationFinal reportGrumman G-44A · Anchorage, AKA fatigue fracture of an unapproved hydraulic brake line fitting, which resulted in a loss of control during the landing roll. Contributing to the accident was the installation of an unapproved part by an unknown maintenance personnel.NTSB ANC09CA101Accident · No injuriesData collectionFinal reportPiper PA-18-180 · Tok, AKThe pilot's selection of an unsuitable landing/takeoff area, resulting in a runway excursion and a nose over during takeoff.NTSB WPR09LA453Accident · 2 fatalLimited investigationFinal reportQuad City Challenger II · Redlands, CAStructural failure of the right wing during the landing approach due to the separation of the wing's fabric covering.NTSB WPR09LA451Accident · No injuriesLimited investigationFinal reportRaytheon B200 · Hayward, CAThe pilot's failure to maintain directional control after takeoff. Contributing to the accident was the pilot's inadequate preflight and failure to follow the airplane manufacturer's checklist to ensure that the rudder trim control and right propeller control…NTSB ANC09LA102Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Lime Village, AKThe passenger's inadvertent interference with, and application of the right brake pedal during takeoff.NTSB ERA09LA523Accident · No injuriesLimited investigationFinal reportCessna 208 · Sheffield, MAA total loss of engine power due to a failure of the 1st stage sun gear output splines for unknown reasons, which resulted in a power turbine overspeed condition, with subsequent blade distress/release.NTSB CEN09CA588Accident · Serious injuriesData collectionFinal reportPowrachute Airwolf · New London, OHThe pilot's failure to maintain clearance from an obstacle during takeoff and the flight instructor's inadequate supervision.NTSB WPR09CA478Accident · No injuriesData collectionFinal reportCessna T210J · Albany, ORThe malfunction of the left main wheel brake during landing due to inadequate hydraulic fluid in the left brake pedal master cylinder due to leakage.NTSB ERA09CA518Accident · No injuriesData collectionFinal reportPiper PA46 · Chamblee, GAThe pilot's failure to maintain aircraft control during landing. Contributing to the accident was pilot fatigue.NTSB WPR09CA444Accident · No injuriesData collectionFinal reportBeech V35 · Hailey, IDThe pilot’s failure to maintain directional control of the airplane during landing in crosswind conditions.NTSB ERA09LA517Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hillsville, VAThe total loss of engine power for an undetermined reason.NTSB WPR09LA449Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-34 · Lake Elsinore, CAThe pilot's failure to maintain control of the glider after the tow line released during the initial climb.NTSB ERA09FA515Accident · 1 fatalField investigationFinal reportCirrus SR-22 · Rock Hill, SCThe pilot's failure to maintain aircraft control and altitude while maneuvering after takeoff.NTSB WPR09FA437Accident · 1 fatalField investigationFinal reportCessna 152 · Coolidge, AZThe failure of both safety/spotter pilots to see and avoid the other airplane.NTSB WPR09LA432Accident · Serious injuriesLimited investigationFinal reportCessna P206B · Truckee, CAThe pilot’s failure to maintain adequate airspeed for flight, which resulted in an aerodynamic stall and subsequent impact with the ground. Contributing to the accident was the intermittent failure of the stall warning system due to a contaminated switch.NTSB CEN09LA574Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Kimball, NEA loss of engine power due to improper installation of an oil line fitting resulting in oil depletion.NTSB WPR09LA442Accident · Serious injuriesLimited investigationFinal reportSix Chuter SR 7 · Hooper, UTThe non-certificated pilot’s failure to maintain an adequate airspeed for the powered parachute while maneuvering at a low altitude.NTSB ERA09LA509Accident · Serious injuriesLimited investigationFinal reportHebert Kitfox Speedster · Morrisville, VTA total loss of engine power during the initial climb after takeoff for undetermined reasons.NTSB ERA09LA503Accident · 1 fatalLimited investigationFinal reportPiper PA-11 · Quincy, FLThe pilot’s improper use of flight controls following a partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s impairment from the use of an over-the-counter sedating antihistamine.NTSB ERA09LA501Accident · 2 fatalLimited investigationFinal reportKeithley Thomas E Starduster Too · St. Matthews, SCA loss of airplane control during approach for undetermined reasons.NTSB CEN09CA564Accident · No injuriesData collectionFinal reportCessna 180G · Canby, MNThe pilot's failure to maintain directional control of the airplane while landing in gusting crosswinds.NTSB ANC09LA098Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Central, AKThe pilot’s failure to maintain control of the helicopter after an in-flight encounter with a downdraft while landing. Contributing to the accident was the pilot’s inadequate evaluation of wind conditions.NTSB ANC09CA094Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Fairbanks, AKA tailwheel malfunction that limited directional control, which resulted in a runway excursion, and collision with a building.NTSB ERA09LA500Accident · 1 fatalLimited investigationFinal reportBlum Matthew Aventura II · Boca Raton, FLThe improper assembly of both carburetors, resulting in an excessively rich fuel to air ratio and subsequent partial loss of engine power.NTSB CEN09LA571Accident · Minor injuriesLimited investigationFinal reportMesserschmitt-Boelkow-Blohm BO-105S · Thibodaux, LAThe pilot's inability to maintain control due to the mechanic's inadvertent switching of two cyclic control tubes of different lengths during maintenance.NTSB CEN09LA565Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Arvilla, NDThe aircraft owner/mechanic/pilot's installation of an improper tail boom assembly and the resulting fatigue failure of the tail boom's attach fittings.NTSB CEN09CA566Accident · No injuriesData collectionFinal reportPiper J3C-65 · Mondovi, WIThe pilot's failure to maintain adequate airspeed while in the traffic pattern, which resulted in an aerodynamic stall.NTSB ERA09LA511Accident · Minor injuriesLimited investigationFinal reportAir Creation 582SL · Strafford, NHA loss of engine power for undetermined reasons.NTSB ERA09LA502Accident · 2 fatalLimited investigationFinal reportM-Squared Sprint 1000 · Madeira Beach, FLA loss of torque to the gearbox engine-side coupling flange bolts, which resulted in separation of the gearbox and propeller from the engine and the subsequent severing of the airplane's tail structure.NTSB CEN09FA562Accident · 5 fatalField investigationFinal reportPiper PA-32R-300 · Tulsa, OKThe non-instrument-rated pilot’s decision to attempt flight in instrument meteorological conditions, which resulted in spatial disorientation and an in-flight collision with a radio tower guy wire.NTSB ANC09CA096Accident · No injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot’s decision to land on unsuitable terrain, which resulted in a loss of control and a collision with trees.