NTSB investigations, 2014
671 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 year(c.\"eventDate\") = 2014
AND 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 year(c."eventDate") = 2014 AND 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 WPR14LA265Accident · No injuriesLimited investigationFinal reportPiper PA 18-135 · Turner, ORThe collapse of the left main landing gear during landing roll for reasons that could not be determined because the pilot would not make the airplane available for a postaccident examination.NTSB WPR14LA249Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Quincy, CAThe partial loss of engine power during takeoff due to the separation of the exhaust baffling, which resulted in a partial blockage of airflow to the engine. Contributing to the accident was maintenance personnel’s inadequate inspection of the exhaust system…NTSB WPR14FA244Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA 5B · Florence, ORThe noninstrument-rated pilot’s visual flight into instrument meteorological conditions, which resulted in his spatial disorientation and the subsequent loss of airplane control.NTSB ERA14CA310Accident · No injuriesData collectionFinal reportJackson Fred M Clipper · Altamont, NYThe pilot's failure to apply carburetor heat prior to descending in atmospheric conditions conducive to serious icing at all power settings, which resulted in a total loss of engine power.NTSB ERA14CA298Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Milton, FLThe pilot's failure to maintain the proper approach path, and his delayed remedial action, which resulted in a runway undershoot and collision with terrain prior to the runway.NTSB CEN14CA289Accident · No injuriesData collectionFinal reportCessna 182A · Valmeyer, ILThe inadvertent deployment of the skydiver's drogue chute when he exited the airplane, resulting in it contacting and damaging the horizontal stabilizer.NTSB WPR14LA245Accident · No injuriesLimited investigationFinal reportAir Tractor AT 502B · Princeton, CAThe partial loss of engine power during takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR14CA246Accident · No injuriesData collectionFinal reportPiper PA 22-160 · Jackson, MTThe pilot's failure to maintain directional control of the airplane during landing roll.NTSB ERA14FA289Accident · 1 fatalField investigationFinal reportMeyer Clair O 2/3 P 51B/C Mustang · Marion, SCThe airplane's impact with terrain shortly after takeoff due to a physiological incapacitation of the pilot.NTSB ERA14FA288Accident · 1 fatalField investigationFinal reportPiper PA-46-500TP · White Plains, NYThe pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation (somatogravic illusion). Contributing to the accident was the pilot's self-induced pressure to depart and his decision to depart in low-ceiling and…NTSB ERA14CA291Accident · No injuriesData collectionFinal reportCessna 172B · Frankfort, KYThe pilot's failure to maintain directional control during landing in crosswind conditions, resulting in a loss of control and runway excursion.NTSB WPR14LA242Accident · No injuriesLimited investigationFinal reportAdams Dragonfly · Mesa, AZA partial loss of engine power due to a reduction in the No. 3 cylinder’s compression as a result of the exhaust valve not having consistent uniform contact with the cylinder head valve seat.NTSB CEN14LA287Accident · No injuriesLimited investigationFinal reportAir Tractor AT 301 · Pearsall, TXThe failure of the No. 1 cylinder rod at the link pin. Contributing to the accident was oil starvation to the rod bearing due to the improper flushing of the oil cooler, which allowed metal and other debris in the oil to clog the drain and the led to the…NTSB ERA14IA301Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Burlington, MAA loss of clamping load of the No. 5 cylinder crankcase through bolts due to maintenance personnel’s failure to properly torque the through bolts during recent maintenance, which resulted in displacement of the No. 2 bearing and the subsequent catastrophic…NTSB CEN14LA284Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Winner, SDThe pilot's improper decision to attempt a takeoff with a tailwind and his failure to achieve the proper airspeed for liftoff, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall shortly after liftoff.NTSB CEN14FA286Accident · 2 fatalField investigationFinal reportBell 206 L4 · South Timbalier PlatformThe pilot's loss of helicopter control for reasons that could not be determined based on the available information.NTSB ERA14FA283Accident · 2 fatalField investigationFinal reportCessna 172S · Daytona Beach, FLA partial loss of engine power during the initial climb after takeoff for reasons that could not be determined due to the postaccident condition of the wreckage. Contributing to the accident was the pilots' decision to turn back to the airport, which led to…NTSB ERA14FA282Accident · 2 fatalField investigationFinal reportLiberty Aerospace XL-2 · Merritt Island, FLThe failure of the pilots to maintain airspeed while maneuvering, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the loss of engine power for a reason that could…NTSB CEN14LA537Accident · Minor injuriesLimited investigationFinal reportHughes TH 55A · Hudson, WIThe nonhelicopter-rated pilot’s operation of the helicopter and its subsequent collision with trees during takeoff for reasons that could not be determined based on the available evidence.NTSB WPR14FA239Accident · 2 fatalField investigationFinal reportAmerican AA-1A · El Mirage, CAThe pilot's loss of airplane control while intentionally maneuvering close to the ground, which resulted in the airplane exceeding its critical angle of attack in a steep bank and entering an accelerated stall.NTSB ANC14LA040Accident · No injuriesLimited investigationFinal reportCessna U206C · Chitina, AKThe failure of the engine’s No. 1 piston connecting rod retaining bolts due to fatigue, which resulted in a total loss of engine power during cruise flight.NTSB WPR14LA237Accident · No injuriesLimited investigationFinal reportCraig W Sherman Super Glasair TT · Madera, CAThe loosening of a B-nut in the fuel system which resulted in a rapid, undetected fuel leak and subsequent fuel exhaustion.NTSB WPR14LA235Accident · No injuriesLimited investigationFinal reportCessna 172N · Page, AZThe pilot’s improper landing flare in gusting wind conditions, his inadequate recovery from the subsequent bounced landing, and his decision to perform a go-around with insufficient airspeed to climb.NTSB ERA14LA281Accident · Serious injuriesLimited investigationFinal reportBelew Marshall D II Steen Skybolt · Chapmansboro, TNThe pilot's failure to maintain airspeed while performing an emergency landing, which led to the airplane exceeding its critical angle-of-attack and experiencing a subsequent aerodynamic stall. Contributing to the accident was a partial loss of engine power…NTSB CEN14WA297Accident · No injuriesForeign investigationCessna F182 - Q · Monhoudou, FranceOn June 8, 2014, at 0800 UTC, a Cessna F182Q, French Registration F-GAQR, was destroyed during a runway excursion while landing at the Chateau de Monhoudou private airstrip (LK7255) near Monhoudou, France. The pilot and three passengers were not injured. The…NTSB CEN14FA288Accident · 2 fatalField investigationFinal reportSchrieber Robert L P 70 · Great Bend, KSThe pilot's improper preflight planning, which led to a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's loss of airplane control during the forced landing.NTSB WPR14LA233Accident · 1 fatalLimited investigationFinal reportNorth Wing Apache Sport · Polson, MTThe pilot’s loss of airplane control during initial climb due to his experiencing an incapacitating medical event.NTSB WPR14FA234Accident · 2 fatalField investigationFinal reportPiper J3C · Paso Robles, CAThe pilot's steep right turn shortly after takeoff, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB ERA14LA285Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Newport, VTThe pilot's failure to maintain adequate airspeed during an aborted landing, which resulted in an aerodynamic stall and collision with the ground. Contributing to the accident was the pilot's alcohol impairment.NTSB CEN14LA298Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Oneida, ARThe pilot’s inadequate fuel management, which resulted in a total loss of engine power at low altitude due to fuel exhaustion and a forced landing in a muddy field and subsequent nose-over.NTSB CEN14FA278Accident · 1 fatalField investigationFinal reportHermann Bjorn Lancair IV · Duluth, MNThe pilot's failure to maintain airplane control while operating in instrument flight rules (IFR) conditions, which was due to spatial disorientation resulting from erroneous heading and bank angle information shown on the primary flight display. Contributing…NTSB CEN14CA283Accident · No injuriesData collectionFinal reportAyres S2R T34 · Wilmont, ARPilot's failure to verify the amount of chemical load on the airplane prior to takeoff which resulted in the airplane being heavier than expected. Contributing to the accident was loading crew not following the pilot's instructions.NTSB ANC14LA039Accident · No injuriesLimited investigationFinal reportCessna 180H · Wasilla, AKThe pilot’s failure to maintain directional control during landing and an attempted go-around, which resulted in collision with terrain.NTSB WPR14LA232Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Ronan, MTA loss of engine power for reasons that could not be determined due to insufficient evidence.NTSB ERA14CA284Accident · No injuriesData collectionFinal reportPiper PA-28-201T · Defuniak Springs, FLThe pilot's failure to maintain directional control in gusty wind conditions during landing, which resulted in a runway excursion and collision with terrain.NTSB CEN14LA279Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Sauk Centre, MNThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s failure to retract the flaps after beginning the go-around.NTSB CEN14CA280Accident · Minor injuriesData collectionFinal reportSchempp-Hirth Nimbus 3/24.5 · Wallis, TXThe pilot's failure to maintain direction control of the glider during takeoff in gusty wind conditions.NTSB ANC14LA038Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Talkeetna, AKMaintenance personnel’s failure to perform required fuel system tests to ensure that the airplane met its original type certification basis after modifying the fuel system and the Federal Aviation Administration’s improper approval of the fuel tank…NTSB CEN14CA291Accident · No injuriesData collectionFinal reportJabiru USA Sport J230-SP · Middleton, WIThe pilot's failure to maintain directional control during takeoff.NTSB WPR14FA226Accident · 2 fatalField investigationFinal reportNorth American AT 6C · Buckley, WAThe loss of engine power during takeoff initial climb for reasons that could not be determined during a postaccident examination of the airplane.NTSB WPR14CA228Accident · No injuriesData collectionFinal reportPiper PA 18A 150 · Leeds, UTThe pilot's failure to confirm the flaps had been retracted during takeoff, which resulted in a loss of lift and subsequent collision with terrain.NTSB CEN14LA290Accident · Serious injuriesLimited investigationFinal reportTeunis Starduster TOO SA300 · Fort Worth, TXThe non-certificated pilot’s inadequate preflight planning, which resulted in a loss of engine power during takeoff due to fuel exhaustion.NTSB ANC14CA037Accident · No injuriesData collectionFinal reportCessna 170B · Fairbanks, AKThe airplane's encounter with a tailwind during takeoff from a short, narrow airstrip, which resulted in a loss of lift and collision with brush and small trees.NTSB CEN14LA273Accident · Serious injuriesLimited investigationFinal reportBeech H35 · Monroe, LAThe 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 ERA14CA277Accident · No injuriesData collectionFinal reportCessna 177B · Cartersville, GAThe pilot's failure to maintain directional control during a go-around after landing.NTSB CEN14LA267Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA20-C1 · Longmont, COA loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight inspection.NTSB CEN14FA266Accident · 1 fatalField investigationFinal reportYakovlev YAK-55M · Stevens Point, WIThe pilot's failure to maintain airplane control during the aerobatic flight, which resulted in the airplane exceeding its critical angle of attack and entering an accelerated stall at a low altitude.NTSB WPR14CA216Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · San Manuel, AZThe pilot's failure to maintain an adequate obstacle clearance altitude from phone wires while performing low-level operations.NTSB ERA14LA272Accident · Minor injuriesLimited investigationFinal reportLandrum Kelly T Vans RV6 · Suffolk, VAThe pilot/builder's decision to use a lubricant that was not designed for high-speed aviation applications, which resulted in the failure of the propeller needle thrust bearing due to the loss of lubrication from overheating, a total loss of aerodynamic…NTSB ERA14CA278Accident · Minor injuriesData collectionFinal reportCessna 172F · Mount Pleasant, PAThe pilot's incorrect takeoff procedures from the soft grass runway and his delay in aborting the takeoff after recognizing slow acceleration.