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 WPR11LA075Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Chino, CAThe student pilot's failure to properly position the flaps for the takeoff, failure to maintain airplane control during the procedure, and the flight instructor's delayed remedial action.NTSB ERA11LA084Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Rochester, NHThe out-of-rig condition of the tailwheel lock, which resulted in a loss of directional control on landing.NTSB ERA11CA087Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1-23D · Aberdeen, MDThe pilot's loss of control during an intentional aerobatic maneuver (spin) resulting in a collision with trees.NTSB CEN11LA120Accident · No injuriesLimited investigationFinal reportBeech 300 · Minneapolis, MNThe pilot's failure to follow the aircraft checklist in locking the cabin door prior to departure which resulted in its in-flight separation.NTSB ERA11WA088Accident · 1 fatalForeign investigationPiper PA-32R-301T · Roma, ItalyOn December 8, 2010, at 1443 UTC, a Piper PA-32R-301T, N58SE, registered to Aircraft Guaranty Title Corporation Trustee,collided with a bus depot after departing runway 34 from Roma Urbe Airport (LIRU), Roma, Italy. The airplane had been recently purchased by…NTSB ERA11CA081Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Pahokee, FLThe pilot's failure to maintain control of the helicopter during takeoff.NTSB ERA11CA080Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Canal Point, FLPilot fatigue due to lack of sleep resulting in incapacitation (falling asleep) and ground contact while maneuvering at a low altitude.NTSB CEN11CA123Accident · No injuriesData collectionFinal reportCessna 177B · Seymour, INThe pilot's failure to maintain directional control while taking off with a gusting wind.NTSB ERA11FA078Accident · 2 fatalField investigationFinal reportCessna U206G · Leverett, MAA total loss of engine power due to the fatigue failure of the crankshaft, which resulted from improper tightening of the cylinder hold-down nuts.NTSB CEN11LA093Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Ponca City, OKThe pilot's loss of control during landing for undetermined reasons.NTSB WPR11LA069Accident · 1 fatalLimited investigationFinal reportSabre Trike · Peoria, AZAn in-flight loss of control for undetermined reasons.NTSB ERA11LA079Accident · Minor injuriesLimited investigationFinal reportEasler Kelly Rans S6ES · St. Augustine, FLA total loss of engine power during initial climb for undetermined reasons.NTSB CEN11LA090Accident · 1 fatalLimited investigationFinal reportSoutherland Freebird Litesport U · Decatur, ILThe pilot's reported inability to control his amateur-built airplane for undetermined reasons after the airplane inadvertently became airborne while conducting a high-speed taxi.NTSB WPR11LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-181 · Wittmann, AZThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA11FA074Accident · 1 fatalField investigationFinal reportBeech A36 · Theodore, ALThe pilot's failure to maintain aircraft control while maneuvering at night in deteriorating weather conditions due to spatial disorientation. Contributing to the accident was the pilot's failure to obtain a weather briefing.NTSB CEN11LA086Accident · 1 fatalLimited investigationFinal reportMaule M-5-180C · Emory, TXThe pilot's loss of control and failure to attain/maintain adequate airspeed during an attempted go-around after a hard bounced landing, resulting in an aerodynamic stall. Contributing to the accident was the pilot’s recent minimal experience in airplane…NTSB WPR11LA064Accident · 1 fatalLimited investigationFinal reportKennedy Lancair 320 · Hubbard, ORThe loss of control during takeoff for undetermined reasons. Contributing to the accident was the pilot's impairment from an over-the-counter sedating medication.NTSB ERA11CA092Accident · No injuriesData collectionFinal reportHaeussler Ray Sonex · Buffalo, NYThe pilot's failure to maintain directional control during takeoff due to his abrupt advancing of the throttle.NTSB CEN11LA083Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Nocagdoches, TXA total loss of power in both engines for undetermined reasons.NTSB WPR11FA059Accident · 1 fatalField investigationFinal reportMooney M20R · Hollister, CAThe pilot did not ensure the airplane was loaded within its weight and balance envelope, which resulted in longitudinal instability and a loss of aircraft control during the initial climb.NTSB CEN11CA187Accident · No injuriesData collectionFinal reportCessna 182M · Lubbock, TXThe pilot's inadequate visual lookout resulting in a collision with an airport sign.NTSB CEN11LA082Accident · 1 fatalLimited investigationFinal reportCessna 172M · Velma, OKThe pilot’s failure to maintain control of the airplane while maneuvering, which resulted in an inadvertent stall and subsequent impact with terrain. Contributing to the accident was the pilot's relative inexperience in pipeline patrols.NTSB ERA11CA069Accident · No injuriesData collectionFinal reportCessna 172G · Winter Haven, FLThe pilot's inadequate preflight/inflight fuel planning resulting in fuel exhaustion and total loss of engine power.NTSB CEN11FA079Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Norfolk, NEThe pilot’s decision to continue the flight into instrumental meteorological conditions which resulted in a collision with a tree.NTSB ERA11WA075Accident · 1 fatalForeign investigationPiper PA-25 · Tapurah City, BrazilOn November 18, 2010, about 1700 Universal Coordinated Time (UTC), a Piper PA-25-235, Brazilian registration PT-WOP, operated by Aeroagricola Boa Safra Ltda, lost control and crashed into trees during an agricultural flight at the Marape Farm, Tapurah City,…NTSB ERA11GA066Accident · 3 fatalFinal reportCessna M337B · Avon Park, FLThe pilot's inadvertent encounter with an unexpected intense rain shower with severe turbulence at night.NTSB CEN11FA075Accident · 1 fatalField investigationFinal reportHawker-Beechcraft A36 · Oklahoma City, OKThe pilot’s loss of control of the airplane during night instrument meteorological conditions, likely due to spatial disorientation.NTSB WPR11FA052Accident · No injuriesField investigationFinal reportGates Lear Jet 25B · Portland, ORThe failure of the flight crew to stop the airplane on the runway due to the flying pilot’s failure to attain the proper touchdown point. Contributing to the accident was an anti-skid system that was not performing optimally, which allowed the airplane to…NTSB WPR11FA050Accident · 2 fatalField investigationFinal reportDiamond Aircraft Ind DA20-C1 · Payson, UTThe pilots' failure to maintain adequate airspeed during a slow flight maneuver that resulted in a stall and spin, and the flight instructor’s delayed or improper remedial actions to recover from the spin. Contributing to the accident was the flight school’s…NTSB ERA11LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Hobe Sound, FLA partial loss of engine power due to fuel contamination in the carburetor.NTSB WPR11LA048Accident · Serious injuriesLimited investigationFinal reportMD Helicopter 369D · Salem, ORThe pilot’s failure to maintain clearance between the longline and trees, which resulted in the longline snagging a tree and then recoiling into the main rotor blades and a subsequent loss of helicopter control.NTSB ERA11CA059Accident · No injuriesData collectionFinal reportHiller-Rogerson Helicopter UH12E · Madison, FLThe pilot's encounter with a settling with power condition while he was performing slow, low-level, out-of- ground-effect flight maneuvers.NTSB CEN11LA067Accident · 1 fatalLimited investigationFinal reportBrantly B-2B · Post, TXThe pilot's decision to operate the helicopter over the maximum gross weight and forward of the recommended center of gravity.NTSB ERA11LA056Accident · 1 fatalLimited investigationFinal reportCarlo Robert Quicksilver SPT 2S · Lajas, PRThe pilot’s failure to maintain adequate airspeed, which resulted in an aerodynamic stall and entry into a spin.NTSB ERA11FA054Accident · 4 fatalField investigationFinal reportPiper PA-44-180 · West Palm Beach, FLThe failure of both the pilot and the certified flight instructor to ensure that the left fuel selector was in the on position for takeoff and their failure to follow the proper procedures when the left engine lost power shortly after takeoff, resulting in an…NTSB ERA11LA063Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Merritt Island, FLThe pilot's failure to maintain directional control while landing, which resulted in a main landing gear collapse and subsequent runway excursion.NTSB CEN11LA066Accident · 1 fatalLimited investigationFinal reportGearn Geary D Swearingen SX300 · Milford, IAA loss of control for undetermined reasons.NTSB CEN11CA062Accident · No injuriesData collectionFinal reportCessna 172 · Pineville, LAThe pilot/mechanic’s improper inspection of the airplane following the engine installation.NTSB CEN11CA057Accident · Serious injuriesData collectionFinal reportSix Chuter SR7 · Winnie, TXThe collapse of the powered parachute's canopy on short final for undetermined reasons, resulting in a loss of lift.NTSB WPR11LA039Accident · Serious injuriesLimited investigationFinal reportLansdorf Qualt · Sonoma, CAA partial 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 WPR11LA038Accident · No injuriesLimited investigationFinal reportCessna T210N · Baggs, WYThe failure of a connecting rod cap retaining bolt during cruise flight, which resulted in a loss of engine power.NTSB ERA11LA050Accident · 1 fatalLimited investigationFinal reportNorth American/Schwamm AT-6F · Fitchburg, MAA total loss of engine power due to a cracked carburetor float and resulting carburetor malfunction.NTSB ERA11LA049Accident · Serious injuriesLimited investigationFinal reportAirborne Classic · Stow, MAThe operator's inadequate engine maintenance, which resulted in a total loss of engine power. Contributing to the accident was the pilot's decision to conduct a downwind takeoff.NTSB ERA11LA048Accident · 2 fatalLimited investigationFinal reportBean R E/R B Weld Glasair III · Winchester, TNThe pilot's inadvertent climb and entry into instrument meteorological conditions during a course reversal, which resulted in spatial disorientation and a loss of control.NTSB CEN11CA065Accident · No injuriesData collectionFinal reportWelch Thomas RV9 · Sac City, IAThe pilot's loss of directional control while landing with a gusting wind.NTSB WPR11CA035Accident · No injuriesData collectionFinal reportCessna 172S · Branscomb, CAThe pilot's failure to maintain clearance from trees during the landing roll on an unimproved airstrip.NTSB CEN11LA050Accident · 1 fatalLimited investigationFinal reportMcfarland Bill Challenger II · Praire Du Sac, WIThe separation of the fuselage-mounted wing strut attachment fitting for an undetermined reason, which resulted in the separation of the left wing of the airplane.NTSB CEN11LA049Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Schaumburg, ILThe pilot did not maintain airspeed following a loss of engine power during takeoff climb, which resulted in an aerodynamic stall. Contributing to the accident was the loss of engine power due to the unlocked engine primer.NTSB CEN11CA121Accident · No injuriesData collectionFinal reportPiper J3C-65 · Cypress, TXThe pilot's failure to maintain directional control of the airplane during landing.NTSB ERA11FA042Accident · 1 fatalField investigationFinal reportMD Helicopters 369E · Thomas, WVThe pilot's failure to clear the helicopter and its external load from surrounding structures and his failure to execute a timely release of the external load, which resulted in an inadvertent entanglement and collision with wires and terrain. Contributing to…