NTSB investigations

19,008 cases where NTSB found Personnel issues.

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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02'))
  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.

NTSB GAA15CA255Accident · No injuriesData collectionFinal reportAviat A-1C-200 · Irwin, IDThe pilot's failure to maintain obstacle clearance during low level flight, which resulted in the airplane striking a wire, impacting water, and nosing over.Aug 27, 2015 · N63BW · Substantial damageNTSB ERA15FA326Accident · 1 fatalField investigationFinal reportPiper PA44 · Houlton, METhe pilot's descent below the published minimum descent altitude in night instrument meteorological conditions without visual contact with the runway environment, which resulted in a collision with trees and terrain short of the runway. Contributing to the…Aug 27, 2015 · N553MD · DestroyedNTSB GAA15CA240Accident · No injuriesData collectionFinal reportPiper PA 28-180 · DeFuniak Springs, FLThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a runway excursion, and collision with a ditch.Aug 26, 2015 · N7215W · Substantial damageNTSB GAA15CA239Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Susanville, CAThe pilot's failure to maintain airspeed control during the landing in gusty wind conditions, resulting in an abnormal runway contact, and collision with terrain.Aug 26, 2015 · N1417X · Substantial damageNTSB ERA15FA325Accident · 1 fatalField investigationFinal reportCessna 310R · Titusville, FLThe pilot's continued flight into known convective weather conditions, which resulted in the airplane's encounter with thunderstorms and the pilot's subsequent loss of airplane control during a missed approach. Contributing to the accident was the failure of…Aug 26, 2015 · N90PS · DestroyedNTSB ERA15CA329Accident · No injuriesData collectionFinal reportCessna 195 · Lancaster, NYThe pilot's excessive application of brake pressure, which resulted in the airplane nosing over.Aug 26, 2015 · N1516D · Substantial damageNTSB CEN15LA399Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Hancock, WIThe in-flight failure of the left wing lower forward attach point under normal loading conditions due to corrosion and fatigue cracking in the center section hinge brackets. Contributing to the accident was the operator's inadequate maintenance and overweight…Aug 26, 2015 · N2005C · DestroyedNTSB CEN15LA384Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT 602 · Pine Bluff, ARThe pilot’s failure to maintain clearance from terrain during an aerial application flight.Aug 26, 2015 · N3026R · Substantial damageNTSB ERA15LA379Accident · No injuriesLimited investigationFinal reportEngineering & Research Ercoupe 415 · Atlanta, GAThe pilot's loss of airplane control, which resulted in a hard landing.Aug 25, 2015 · N87172 · Substantial damageNTSB CEN15LA382Accident · Serious injuriesLimited investigationFinal reportPiper PA 22-160 · Tyler, MNThe student pilot's failure to adequately ensure the carburetor was clear of ice before takeoff, which resulted in a partial loss of engine power during takeoff due to carburetor icing.Aug 25, 2015 · N2805Z · Substantial damageNTSB GAA15CA236Accident · No injuriesData collectionFinal reportCessna 182Q · Pineville, LAThe pilot's failure to land with sufficient runway remaining to safely stop the airplane, resulting in a runway over-run and collision with terrain.Aug 24, 2015 · N759TZ · Substantial damageNTSB GAA15CA237Accident · No injuriesData collectionFinal reportCessna 172 · Springfield, OHThe pilot's improper pitch control during landing, which resulted in a hard landing.Aug 23, 2015 · N691SP · Substantial damageNTSB CEN15LA381Accident · No injuriesLimited investigationFinal reportLuscombe 8 · Pontiac, MIThe pilot's failure to maintain airplane control while landing with a left quartering tailwind. Contributing to the accident was the pilot's inability to conduct a go-around because of a loss of engine power due to carburetor icing.Aug 23, 2015 · N1406K · Substantial damageNTSB CEN15LA376Accident · 1 fatalLimited investigationFinal reportSchleicher ASW 20 · Hempstead, TXThe pilot’s failure to maintain clearance from power lines during an attempted off-airport landing.Aug 23, 2015 · N878S · Substantial damageNTSB CEN15FA374Accident · 1 fatalField investigationFinal reportBeech 35 B33 · El Dorado, ARThe loss of engine power for reasons that could not be determined during postaccident examination of the accident site or based on the available information and the pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical…Aug 23, 2015 · N9704Y · DestroyedNTSB GAA15CA303Accident · No injuriesData collectionFinal reportMitsubishi MU 2B-25 · Arvin, CAThe pilot's failure to maintain clearance from trees while taxiing into position for takeoff on a narrow private airstrip, resulting in the left wing striking a tree.Aug 22, 2015 · N553T · Substantial damageNTSB ERA15CA327Accident · No injuriesData collectionFinal reportCessna 172 · Riviera Beach, FLThe pilot's failure to apply carburetor heat prior to descending in atmospheric conditions conducive to icing, which resulted in a total loss of power.Aug 22, 2015 · N8952B · Substantial damageNTSB CEN15LA375Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Carlos, TXThe pilot’s improper decision to turn the helicopter toward a tailwind during an out-of-ground-effect hover, which resulted in a loss of tail rotor effectiveness. Contributing to the accident was the accident and lead pilots’ inadequate preflight risk…Aug 22, 2015 · N445HS · Substantial damageNTSB ANC15CA065Accident · No injuriesData collectionFinal reportCessna 180 · Homer, AKThe pilot's loss of directional control during landing, resulting in a collision with terrain.Aug 22, 2015 · N9588B · Substantial damageNTSB GAA15CA254Accident · No injuriesData collectionFinal reportPiper PA 18-150 · LaBelle, FLThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over and impact with terrain.Aug 21, 2015 · N18LP · Substantial damageNTSB ERA15LA322Accident · Minor injuriesLimited investigationFinal reportEclipse EA500 · Danbury, CTThe pilot's failure to attain the proper touchdown point and exceedance of the target touchdown speed, which resulted in a runway overrun.Aug 21, 2015 · N120EA · Substantial damageNTSB CEN15LA383Accident · No injuriesLimited investigationFinal reportPiper PA 25-235 · Harvey, NDThe partial loss of engine power due to a failed magneto and two cylinders with low compression. Contributing to the accident was the pilot/owner’s decision to operate the airplane with an ongoing engine issue.Aug 21, 2015 · N4652Y · Substantial damageNTSB CEN15FA378Accident · 1 fatalField investigationFinal reportCessna 172 · Martinville, ILThe non-certificated pilot's failure to maintain clearance from terrain.Aug 21, 2015 · N8265B · Substantial damageNTSB WPR15FA247Accident · 2 fatalField investigationFinal reportCessna 172P · Townsend, MTThe non-instrument-rated pilot's decision to conduct a cross-country flight over a mountain range in dark night conditions with limited night flight experience, which resulted in a collision with mountainous terrain.Aug 20, 2015 · N62731 · Substantial damageNTSB GAA15CA249Accident · No injuriesData collectionFinal reportStinson L 5E · Tucson, AZThe pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion and a collision with an object.Aug 20, 2015 · N944LB · Substantial damageNTSB GAA15CA238Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Ronkonkoma, NYThe student pilot's loss of control during a hover, which resulted in ground contact and a dynamic rollover. Contributing to the accident was the flight instructor's lack of action to remediate the student pilot's control inputs and recover aircraft control.Aug 19, 2015 · N86EH · Substantial damageNTSB GAA15CA235Accident · No injuriesData collectionFinal reportCessna 172N · Kalispell, MTThe pilot's loss of directional control, which resulted in a runway excursion, and collision with runway and taxiway lights and terrain.Aug 19, 2015 · N733NH · Substantial damageNTSB GAA15CA233Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Prescott, AZThe flight instructor's decision to turn the helicopter downwind during a hover taxi which resulted in an uncontrolled descent and impact with terrain.Aug 18, 2015 · N5VH · Substantial damageNTSB CEN15LA369Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Bolivar, MOTotal electrical failure due to a failed voltage regulator and the pilot’s failure to maintain a proper airspeed during a precautionary landing, which resulted in a loss of directional control and a runway excursion.Aug 18, 2015 · N6KW · Substantial damageNTSB CEN15LA367Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-802A · Wiville, ARThe pilot's failure to maintain clearance from a utility pole while maneuvering during an agricultural application flight, which resulted in damage to the right aileron and a subsequent uncontrolled right roll at a low altitude.Aug 18, 2015 · N3070R · DestroyedNTSB WPR15LA246Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12 D · Libby, MTThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.Aug 17, 2015 · N43616 · Substantial damageNTSB WPR15IA244Incident · No injuriesIncident investigationFinal reportQuest Kodiac 100 · Page, AZThe pilot's inadvertent failure to engage the seat in the locked position before takeoff, which resulted in the seat sliding back during the takeoff roll and a subsequent loss of directional control. Contributing to the incident was the seat locking…Aug 17, 2015 · N771RT · Minor damageNTSB GAA15CA230Accident · Minor injuriesData collectionFinal reportBell 412 · Whittier, CAThe pilot's failure to appropriately monitor the helicopter's fuel supply, resulting in fuel exhaustion, loss of engine power, and an autorotation with a hard landing.Aug 17, 2015 · N412LA · Substantial damageNTSB CEN15FA362Accident · 2 fatalField investigationFinal reportZenair CH 2000 · McAllen, TXThe flight instructor's loss of airplane control while departing in gusting wind conditions that were conducive to low-level wind shear.Aug 17, 2015 · N26ZA · DestroyedNTSB WPR15MA243Accident · 5 fatalMajor investigationFinal reportCessna 172M · San Diego, CAThe local controller's (LC) failure to properly identify the aircraft in the pattern and to ensure control instructions provided to the intended Cessna on downwind were being performed before turning Eagle1 into its path for landing. Contributing to the LC's…Aug 16, 2015 · N1285U · 2 aircraft · DestroyedNTSB GAA15CA248Accident · No injuriesData collectionFinal reportCessna 177B · Los Angeles, CAThe pilot's failure to maintain pitch control during the landing, resulting in a hard landing.Aug 16, 2015 · N13HK · Substantial damageNTSB GAA15CA234Accident · Minor injuriesData collectionFinal reportBurton Dennis W Sonex · Wolcottville, INThe pilot's improper fuel planning, which resulted in fuel exhaustion, a forced off-airport landing, and nose over.Aug 16, 2015 · N683DB · Substantial damageNTSB GAA15CA231Accident · Minor injuriesData collectionFinal reportCessna 180H · Ione, ORThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with terrain.Aug 16, 2015 · N28RR · Substantial damageNTSB ERA15LA319Accident · Serious injuriesLimited investigationFinal reportHead AX9 118 · New Holland, PAThe pilot's failure to adequately secure the vent line, which resulted in the premature deflation of the balloon’s envelope and its subsequent contact with power lines. Contributing to the accident were the pilot's choice of an unsuitable landing area, which…Aug 16, 2015 · N40104 · Minor damageNTSB ERA15LA315Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-161 · Bristow, VAThe student pilot’s failure to maintain altitude during approach, which resulted in controlled flight into terrain. Contributing to the accident was the student’s distraction due to other traffic in the airport traffic pattern.Aug 16, 2015 · N82587 · Substantial damageNTSB ERA15FA313Accident · 1 fatalField investigationFinal reportBeech C35 · Hicksville, NYThe pilot's improper decision to delay turning toward a suitable runway once he realized that an engine failure had occurred, which resulted in his having inadequate altitude to glide to a suitable runway, and the New York terminal radar approach control…Aug 16, 2015 · N5946C · DestroyedNTSB CEN15LA403Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Big Piney, WYThe pilot's failure to maintain adequate altitude while operating over high mountainous terrain, which resulted in an emergency landing after the airplane's encounter with a downdraft.Aug 16, 2015 · XBYUH · Substantial damageNTSB CEN15IA365Incident · No injuriesIncident investigationFinal reportBeech V35 · Mount Vernon, OHThe loosening of the flyweight due to the installation of an improperly hardened flyweight carrier, which resulted in the overspeed of the propeller and engine and the subsequent in-flight separation of the propeller.Aug 16, 2015 · N2059W · No damageNTSB ANC15CA064Accident · No injuriesData collectionFinal reportChampion 7HC · Coldfoot, AKThe loss of engine power due to carburetor icing and the pilot's failure to recognize conditions favorable for carburetor icing and apply use of carburetor heat.Aug 16, 2015 · N8556E · DestroyedNTSB ERA15FA312Accident · 1 fatalField investigationFinal reportCessna T206H · West Caldwell, NJA loss of engine power due to a malfunction of the turbocharging system likely due to contaminated oil. Also causal were the pilot's decision to continue the takeoff although the airplane was not performing normally and his failure to maintain adequate…Aug 15, 2015 · N63TV · DestroyedNTSB ERA15CA321Accident · Serious injuriesData collectionFinal reportQuicksilver MXL II Sport · Pittsboro, NCThe pilot's failure to open the fuel shutoff valve during the preflight examination of the airplane which resulted in a total loss of engine power during initial climb after takeoff due to fuel starvation.Aug 15, 2015 · UNREG · Substantial damageNTSB ERA15CA320Accident · Minor injuriesData collectionFinal reportSanderson Herbert H SHA Glasair · Bladenboro, NCThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with a ditch.Aug 15, 2015 · N629HS · Substantial damageNTSB DCA15LA173Accident · No injuriesLimited investigationFinal reportAirbus A321 · Charlotte, NCan encounter with a small microburst on short final at low altitude that resulted in a loss of lift and a tail strike during the go-around. Contributing to the accident was the captain's decision to continue the approach without applying appropriate windshear…Aug 15, 2015 · N564UW · Substantial damageNTSB WPR15LA242Accident · 1 fatalLimited investigationFinal reportBartels Lancair · Pacific Ocean (Pacific Ocean)The pilot's incapacitation for reasons that could not be determined because the airplane was not recovered from the ocean.Aug 14, 2015 · N427LE · DestroyedNTSB WPR15LA240Accident · Minor injuriesLimited investigationFinal reportStinson SR 9B · Chula Vista, CAA total loss of engine power due to fuel exhaustion as a result of the pilot’s failure to verify the fuel quantity before the flight.Aug 14, 2015 · N17154 · Substantial damage