NTSB investigations
1,332 cases where the sequence of events included Collision during takeoff/land.
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\" = '490' 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" = '490' 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 ANC16CA058Accident · No injuriesData collectionFinal reportPiper J5A · Sterling, AKThe pilot's improper fuel management, which led to fuel exhaustion and a subsequent forced landing on a road too narrow for the airplane.NTSB ERA16LA300Accident · No injuriesLimited investigationFinal reportCessna 150 · Littleton, MAA total loss of engine power during descent for reasons that could not be determined because postaccident examination of the airframe and engine revealed no anomalies that would have precluded normal operation.NTSB ERA16FA289Accident · 6 fatalField investigationFinal reportPiper PA 31 · Northport, ALA total loss of power in both engines due to fuel starvation as a result of the pilot's fuel mismanagement, and his subsequent failure to follow the emergency checklist. Contributing to the pilot's failure to follow the emergency checklist was his lack of…NTSB CEN16LA311Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Cardington, OHThe partial loss of engine power due to carburetor icing during an attempted go-around.NTSB GAA16CA419Accident · No injuriesData collectionFinal reportCessna 172 · Lewiston, MTThe pilot's failure to ensure that his seat was adjusted and locked, which resulted in his seat sliding aft during the takeoff roll, and the subsequent loss of directional control and runway excursion.NTSB GAA16CA403Accident · No injuriesData collectionFinal reportCessna 172 · Rexburg, IDThe student pilot's failure to retract the flaps during a go-around in high density altitude conditions, resulting in the airplane's inability to climb and a subsequent collision with terrain and nose over.NTSB GAA16CA390Accident · No injuriesData collectionFinal reportPiper PA46 · Claremore, OKThe pilot's failure to maintain directional control during takeoff after multiple climb attempts at insufficient airspeed, which resulted in a runway excursion, a landing gear collapse, and a collision with a ditch.NTSB CEN16LA273Accident · No injuriesLimited investigationFinal reportBrandt Sonex · Lodi, WIThe separated rocker arm assembly for undetermined reasons, which resulted in the partial loss of engine power and led to the landing gear collapsing during the subsequent forced landing.NTSB ANC16CA055Accident · No injuriesData collectionFinal reportKirbybilt Xcalibur · Valdez, AKThe pilot's failure to maintain an adequate glide path during landing, which resulted in the airplane landing short of the airstrip, a landing gear collapse, and subsequent substantial damage to the fuselage.NTSB ERA16FA257Accident · 3 fatalField investigationFinal reportPiper PA 28R-201 · Esperance, NYThe pilot's inadequate preflight weight and balance and performance planning, which resulted in the airplane being over gross weight. Also causal were the pilot's decision not to use the entire runway for takeoff, his premature liftoff, and his failure to…NTSB WPR16LA138Accident · 3 fatalLimited investigationFinal reportCessna 172 · Brookings, ORThe pilot's spatial disorientation and loss of situational awareness during the departure turn in dark night conditions, which resulted in an in-flight collision with water.NTSB ANC16LA038Accident · No injuriesLimited investigationFinal reportCessna 206 · Halibut Cove, AKThe pilot's failure to maintain clearance from trees during an attempted go-around.NTSB CEN16LA252Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Houghton Lake Heights, MIThe pilot's delayed reaction to the variable wind condition, which resulted in an excessive descent rate and the airplane's subsequent collision with a wire fence short of the runway.NTSB ERA16CA218Accident · No injuriesData collectionFinal reportPiper PA32 · Block Island, RIThe pilot's failure to attain the proper touchdown point and the airplane’s subsequent collision with obstacles during an attempted go-around.NTSB CEN16FA216Accident · 2 fatalField investigationFinal reportCessna 150F · Rockville, INThe pilot's use of an improper soft-field takeoff procedure, which resulted in the airplane having insufficient airspeed to climb out of ground effect and its subsequent impact with trees near the departure end of the runway.NTSB CEN16FA215Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Jonesboro, ARThe pilot's failure to maintain helicopter control during takeoff. Contributing to the accident was the pilot's impairment due to his combined use of alcohol and diphenhydramine, which led to his improper decision to fly after drinking alcohol and degraded…NTSB ANC16CA031Accident · No injuriesData collectionFinal reportMaule M 6-235 · Fairbanks, AKThe pilot's decision to land on terrain unsuitable for a wheel equipped airplane.NTSB CEN16LA228Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Deming, NMThe pilots’ failure to maintain adequate control of the airplane during the initial climb after takeoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall at a low altitude. Contributing to the accident was the…NTSB GAA16CA284Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Ferndale, MTThe pilot's loss of directional control during takeoff resulting in a decision to rotate early, and a collision with a hangar and subsequent fire.NTSB GAA16CA273Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Shulin Lake, AKThe pilot's failure to maintain clearance from trees during final approach.NTSB CEN16WA398Accident · Serious injuriesForeign investigationCirrus SR22 · Ailly-sur-Somme, FranceNTSB CEN16LA187Accident · No injuriesLimited investigationFinal reportBeech B100 · Dexter, MOA collapse of the right main landing gear for reasons that could not be determined because of the damage to the landing gear system.NTSB CEN16LA178Accident · No injuriesLimited investigationFinal reportMooney M20K · Akron, OHA missing bolt in the nose landing gear assembly, which resulted in the airplane suddenly turning left and the pilot's inability to maintain directional control during a crosswind takeoff.NTSB GAA16CA228Accident · No injuriesData collectionFinal reportBeech C23 · Yucca Valley, CAThe pilot's failure to attain airspeed and a positive rate of climb during takeoff in gusty wind conditions, resulting in a loss of directional control, an uncontrolled descent and collision with terrain.NTSB ERA16LA171Accident · Minor injuriesLimited investigationFinal reportCessna 421 · Foley, ALThe pilot's failure to obtain proper takeoff speed before breaking ground, which resulted in the airplane’s failure to gain altitude and a collision with trees and terrain.NTSB ERA16LA157Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 175 · Wartburg, TNCatastrophic engine failure due to a fatigue fracture of the No. 6 connecting rod cap.NTSB DCA16WA126Accident · Minor injuriesForeign investigationBoeing 737 · Jakarta, IndonesiaThe government of Indonesia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on April 04, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the…NTSB GAA16CA164Accident · No injuriesData collectionFinal reportPphu Ekolot KR-030 Topaz · Lake Dallas, TXThe pilot's failure to maintain directional control during the landing in a crosswind, which resulted in a runway excursion and an impact with terrain.NTSB GAA16CA163Accident · No injuriesData collectionFinal reportEnstrom F280 · Sodus, NYThe pilot's improper collective application at touchdown during a practice run-on landing, which resulted in the main rotor system impacting the tailboom and the forward portion of the fuselage impacting terrain during remedial action by the flight…NTSB GAA16CA154Accident · No injuriesData collectionFinal reportNicholson David F RV 9 · Allison, IAThe pilot's improper soft-field landing technique, which resulted in a nose landing gear collapse and a nose over.NTSB GAA16CA149Accident · Minor injuriesData collectionFinal reportAmerican AA 1 · Brigham City, UTLoss of directional control during landing, due to nose landing gear damage sustained in the prior takeoff, resulting in a runway excursion and nose over.NTSB ERA16LA114Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Gainesville, FLThe failure of the engine crankshaft near the Nos. 4 and 5 crankshaft journals due to oil starvation. The reason for the oil starvation could not be determined during postaccident examination.NTSB GAA16LA135Accident · No injuriesLimited investigationFinal reportPinkston Randy T RV-7 · Tavernier, FLThe pilot's misidentification of a parallel roadway for the runway and the airplane's subsequent collision with numerous objects during landing.NTSB ANC16CA014Accident · No injuriesData collectionFinal reportCessna 180 · Sleetmute, AKThe pilot's decision to make contact with an unsuitable landing surface, resulting in a nose over.NTSB GAA16CA123Accident · No injuriesData collectionFinal reportCessna 150 · Lapeer, MIThe student pilot's failure to achieve an adequate climb rate while turning to avoid obstacles during an aborted landing, resulting in an uncontrolled descent, collision with terrain, and a nose over.NTSB CEN16LA097Accident · No injuriesLimited investigationFinal reportPiper PA 28-140 · Sturtevant, WIThe pilot's failure to maintain a proper glidepath during a landing at dusk, which resulted in impact with a moving ground vehicle. Contributing to the accident was the inoperative precision approach path indicator.NTSB GAA16CA105Accident · No injuriesData collectionFinal reportEngineering & Research Ercoupe 415 · Chappell, NEThe pilot's inability to correct for a crosswind during the takeoff roll due to the interlinked flight control design, which resulted in a runway excursion, and a collision with terrain.NTSB GAA16CA093Accident · No injuriesData collectionFinal reportCessna 172 · Newton, IAThe pilot's failure to maintain airplane control during the takeoff, resulting in a runway excursion, and airplane nose over.NTSB GAA16CA085Accident · No injuriesData collectionFinal reportKelm David Kitfox 7 · Tracy, CAThe pilot's failure to maintain pitch control during the landing, which resulted in a hard landing, runway excursion and impact with terrain.NTSB CEN16LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-181 · Pontiac, MIThe pilot’s operation of the airplane below the glideslope and off course during a night, instrument approach, which resulted in a collision with trees and terrain.NTSB GAA16CA069Accident · No injuriesData collectionFinal reportPiper PA 46-350P · Mammoth, CAThe pilot's decision to takeoff in high crosswind conditions resulting in the inability to maintain an adequate crosswind correction, consequently failing to maintain directional control and departing the runway, and subsequently colliding with fixed airfield…NTSB WPR16FA029Accident · 2 fatalField investigationFinal reportAirbus Helicopters AS350B3E · Carlsbad, CAThe pilot's loss of control during landing on a dolly. Contributing to the accident were the pilot's decision to conduct the flight without an instructor despite multiple flight instructors' recommendations to the contrary, his failure to land on the ramp…NTSB CEN16FA037Accident · 1 fatalField investigationFinal reportCessna 182Q · Richmond, MOThe airplane's impact with trees and terrain during an off-airport forced landing in dark night conditions following a partial loss of engine power. The reason for the partial loss of engine power could not be determined because postaccident examination did…NTSB CEN16LA035Accident · Minor injuriesLimited investigationFinal reportGlimn Kitfox 2-3 · Escanaba, MIThe airplane owner's inadequate maintenance and servicing of the propeller gearbox, which resulted in oil starvation, failure of the gearbox in flight, and a subsequent loss of propeller thrust. Contributing to the outcome was the airplane's low altitude at…NTSB CEN16LA029Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Tecumseh, MIThe pilot's failure to maintain directional control during the landing and his subsequent improper decision to attempt an aborted landing after the airplane had departed the runway.NTSB ERA16WA049Accident · 1 fatalForeign investigationRobinson R44 · Guarani Municipality, BrazilOn October 25, 2015, at 1730 local time (1930 coordinated universal time), a Robinson R44, Brazilian registration PP-BAO, was substantially damaged when it impacted trees and a lake after takeoff in the Guarani Municipality, State of Minas Gerais, Brazil. The…NTSB GAA16CA040Accident · No injuriesData collectionFinal reportCessna 182J · Skwentna, AKThe pilot's failure to maintain pitch control during landing, which resulted in a porpoise and structural damage to the airplane.NTSB GAA16CA013Accident · No injuriesData collectionFinal reportBeech F33 · Marana, AZThe student pilot's failure to maintain sufficient airspeed during the base to final turn resulting in an inadvertent aerodynamic stall and impact with terrain during recovery by the flight instructor.NTSB GAA16CA006Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Devine, TXThe pilot's failure to maintain obstacle clearance during the takeoff, which resulted in the helicopter striking power lines.NTSB CEN16LA006Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Parkston, SDThe pilot’s decision to take off from a confined area and his failure to adequately compensate for wind conditions during the takeoff, which resulted in collision with obstacles.