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 ERA14CA171Accident · Serious injuriesData collectionFinal reportCessna 172 · Carlisle, PAThe pilot's decision to depart with a known mechanical malfunction and his improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and subsequent impact with terrain during an off-airport landing.NTSB WPR14CA156Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Mesa, AZThe student pilot's excessive speed during taxi which resulted in a runway overrun. Contributing to the accident was the pilot's inadequate monitoring of the remaining runway length available during the landing roll.NTSB ERA14WA196Accident · 2 fatalForeign investigationRobinson R22 - Beta · Ribeirão Preto, BrazilOn March 23, 2014, about 1355 universal coordinated time, a Robinson R22 Beta, Brazilian registration PP-SSP, was substantially damaged when it impacted the ground on a corn plantation in Ribeirao Preto, Brazil. The pilot and a passenger were fatally injured.…NTSB ERA14CA169Accident · No injuriesData collectionFinal reportCessna 172M · Knoxville, TNThe student pilot's failure to maintain directional control during the takeoff roll, which resulted in a collision with an obstacle.NTSB ERA14CA165Accident · Serious injuriesData collectionFinal reportFantasy Air Sro Allegro 2000 · Kill Devil Hills, NCThe pilot's failure to maintain control of the airplane during the landing approach in gusty wind conditions.NTSB CEN14LA197Accident · No injuriesLimited investigationFinal reportRobinson R44 - II · Menard, TXThe pilot’s inadequate recovery from a practice autorotation, which resulted in an improper touchdown attitude and collision with terrain.NTSB WPR14WA154Accident · 5 fatalForeign investigationCessna U206 - G · Caboolture, AustraliaOn March 22, 2014 about 1123 local time, a Cessna 206 airplane, Australian registration VH-FRT, crashed shortly after takeoff near Caboolture, Australia. The airplane was substantially damaged and the pilot and four passengers were fatally injured. The…NTSB CEN14FA167Accident · 5 fatalField investigationFinal reportSocata TBM 700 · Ridgway, COThe pilot's loss of airplane control during an instrument approach procedure, which resulted in the airplane exceeding its critical angle of attack and entering an inadvertent aerodynamic stall and spin.NTSB WPR14LA146Accident · No injuriesLimited investigationFinal reportColumbia Aircraft Mfg LC42 550FG · Truckee, CAThe pilot’s failure to maintain directional control during both the landing and the subsequent attempted go-around.NTSB WPR14LA142Accident · No injuriesLimited investigationFinal reportBellanca 17 31 · Salt Lake City, UTThe failure of the right main landing gear extension spring to maintain adequate pressure, which allowed the landing gear to collapse during the landing roll.NTSB ERA14LA164Accident · Serious injuriesLimited investigationFinal reportFarace Thomas Scott Kitfox II · Vicksburg, MSThe airplane’s low-level encounter with a downdraft that maximum engine power could not overcome.NTSB ERA14LA161Accident · 1 fatalLimited investigationFinal reportCessna LC41-550FG · Palatka, FLThe pilot’s improper management of the fuel mixture and his failure to use the appropriate checklist and guidance during the flight, which resulted in an overrich mixture condition, carbon-fouling of the spark plugs, and a subsequent total loss of engine…NTSB CEN14CA186Accident · No injuriesData collectionFinal reportCessna 172N · Marine City, MIThe pilot's improper recovery from a bounced landing.NTSB CEN14CA170Accident · No injuriesData collectionFinal reportDonald G Stokes Challenger II · Crockett, TXThe pilot's failure to maintain control of the airplane, resulting in a hard landing.NTSB WPR14LA141Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Porterville, CAThe student pilot’s failure to maintain directional control during takeoff.NTSB CEN14FA163Accident · 1 fatalField investigationFinal reportSmith Aerostar 601P · Aurora, COThe pilot's operation of the airplane while intoxicated, which resulted in a loss of airplane control.NTSB CEN14CA440Accident · Serious injuriesData collectionFinal reportMooney M20J · Lamar, COThe pilot allowed the airplane to liftoff without sufficient airspeed which resulted in a stall and subsequent impact with the terrain.NTSB CEN14CA164Accident · No injuriesData collectionFinal reportPiper PA 28R-201 · Ruidoso, NMThe pilot's failure to adjust the engine's fuel-air mixture and decision to takeoff in high density attitude conditions which degraded the airplane's performance.NTSB WPR14FA137Accident · 2 fatalField investigationFinal reportEurocopter AS 350 B2 · Seattle, WAThe loss of helicopter control due to a loss of hydraulic boost to the tail rotor pedal controls at takeoff, followed by a loss of hydraulic boost to the main rotor controls after takeoff. The reason for the loss of hydraulic boost to the main and tail rotor…NTSB CEN14LA165Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Wichita Falls, TXThe loss of engine power due to the misrigging of the fuel mixture control.NTSB CEN14LA161Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Greenwood, INThe flight instructor's failure to ensure that carburetor heat was used while performing maneuvers at reduced power settings in conditions conducive to the formation of carburetor ice, which resulted in a partial loss of engine power due to carburetor ice.…NTSB ERA14LA156Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Stuart, FLThe pilot’s improper preflight planning and fuel management, which resulted in a total loss of power in both engines due to fuel exhaustion.NTSB CEN14CA160Accident · Minor injuriesData collectionFinal reportPiper PA 28-235 · De Beque, COThe pilot's failure to maintain control of the airplane while maneuvering at low altitude.NTSB ERA14WA154Accident · 5 fatalForeign investigationBeech BE9L-C90 · Villavicenco, ColombiaOn March 12, 2014, about 1133 universal coordinated time, a Hawker Beechcraft BE9L- C90, Colombian registration HK4921, was destroyed by impact and a postcrash fire, in the vicinity of Villavicencia, Meta, Colombia. The Colombian commercial pilot and four…NTSB WPR14FA135Accident · 2 fatalField investigationFinal reportEvolution Trikes Revo · Kekaha, HIThe pilot's reconfiguration of the fuel venting system, which resulted in a loss of engine power and subsequent loss of aircraft control.NTSB ERA14FA153Accident · 1 fatalField investigationFinal reportWaters Peter T Avid Bandit · Washington, PAThe pilot’s failure to maintain airspeed and angle of attack, which resulted in an aerodynamic stall and loss of aircraft control in gusty and turbulent wind conditions.NTSB WPR14FA132Accident · 1 fatalField investigationFinal reportCessna 120 · Carson City, NVThe pilot’s delayed decision to initiate a course-reversal turn when the airplane was unable to attain sufficient altitude to cross a mountain range, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall…NTSB CEN14CA154Accident · No injuriesData collectionFinal reportCessna 185 · Eden Prairie, MNThe pilot's loss of directional control during takeoff with a gusty crosswind.NTSB ERA14LA147Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Fairhope, ALThe pilot’s failure to maintain adequate separation from a helicopter during the approach to landing, which resulted in an encounter with the helicopter’s trailing vortices, a loss of airplane control, and impact with terrain.NTSB ERA14LA146Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Mulberry, FLThe failure of the pilot and the parachutist to see and avoid each other, which resulted in the airplane’s wing colliding with the parachute’s suspension lines.NTSB ERA14FA144Accident · 3 fatalField investigationFinal reportRogers George T Lancair IVP · Hartsville, SCFailure of the flying pilot to maintain control of the airplane while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall. Contributing to the accident were the…NTSB ERA14CA150Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · Salisbury, NCThe flight instructor's decision to continue the landing in close proximity to a landing helicopter, resulting in an encounter with rotor vortices, loss of airplane control, and collision with terrain.NTSB CEN14CA156Accident · No injuriesData collectionFinal reportOlson Kenneth H T Zodiac 601 HDS · Garrison, MNThe pilot's failure to maintain directional control during takeoff which resulted in the airplane striking a snow bank.NTSB ANC14CA018Accident · No injuriesData collectionFinal reportPiper PA 18 · Tanana, AKThe passenger inadvertently interfered with the rudder control pedal, which resulted in a loss of directional control during takeoff.NTSB ERA14WA148Accident · 1 fatalForeign investigationZivko Aeronautics Edge 540T · Al Khor, QatarOn March 17, 2014, about 1725 local time, a Zivko Aeronautics Edge 540T, N149WA, was substantially damaged when it collided with the ground during an airshow performance at Al Khor Airport (OTBK), Al Khor, Qatar. The commercial pilot was fatally injured. The…NTSB ERA14CA151Accident · No injuriesData collectionFinal reportCessna 172M · Pittstown, NJThe pilot's failure to maintain directional control while landing.NTSB CEN14CA153Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 · Cleveland, OHThe pilot's improper flare and recovery from a bounced landing, which resulted in a loss of control and impact with terrain.NTSB ERA14LA142Accident · No injuriesLimited investigationFinal reportCessna 172R · Jackson, TNA total loss of engine power due to maintenance personnel’s improper installation of the lower vacuum pump.NTSB ERA14LA141Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Atlantic City, NJA partial loss of engine power at takeoff for reasons that could not be determined during a postaccident examination or engine test run.NTSB WPR14FA127Accident · 1 fatalField investigationFinal reportPiper PA 46 350P · Truckee, CAThe pilot’s failure to properly execute the missed approach in instrument conditions. Contributing to the accident were the pilot’s lack of instrument proficiency, as demonstrated by his failure to execute the required procedure turn to align with the final…NTSB ERA14FA138Accident · 1 fatalField investigationFinal reportBeech F33 · Lumberport, WVA stroke or cardiovascular event, which resulted in the pilot’s acute impairment or incapacitation and his subsequent flight into terrain.NTSB ERA14CA140Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Mayaguez, PRThe pilot's loss of directional control of the airplane during landing, which resulted in a runway excursion.NTSB CEN14CA157Accident · No injuriesData collectionFinal reportAeronca 7AC · Adrian, TXThe pilot's failure to maintain directional control of the airplane during the landing roll which resulted in the airplane ground looping.NTSB WPR14CA129Accident · No injuriesData collectionFinal reportPartenavia P 68 Observer · Molokai, HIThe pilot's inadequate decision to continue an unstable approach in dark night conditions, which resulted in a collision with trees and hard landing.NTSB WPR14LA123Accident · No injuriesLimited investigationFinal reportLake LA 4 200 · Corona, CAThe loss of engine power during initial climb for reasons that could not be determined because a postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR14CA122Accident · No injuriesData collectionFinal reportCessna 172M · Ramona, CAThe student pilot's inadequate flare and failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB WPR14LA119Accident · 1 fatalLimited investigationFinal reportSabrena Dragonfly · Maricopa, AZThe pilot’s failure to maintain control of the airplane while maneuvering, which resulted in the airplane exceeding its critical angle of attack and subsequently experiencing an aerodynamic stall and spin at a low altitude.NTSB ERA14CA136Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Lake Wales, FLThe pilot's improper flare during a water landing, which resulted in the wings contacting the water.NTSB CEN14LA149Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Presidio, TXThe pilot’s failure to maintain sufficient rotor rpm when transitioning the helicopter from a hover to forward flight, which resulted in a loss of helicopter control.NTSB ERA14LA130Accident · Serious injuriesLimited investigationFinal reportVictor M Cordero RV-9A · Apopka, FLThe failure of the propeller spline shaft, the drive disk adapter, and the propeller speed reduction unit (PSRU) input spline due to a lack of inspection and lubrication, which resulted in a total loss of propeller drive and a subsequent forced landing.…