NTSB investigations

19,222 cases where NTSB found Aircraft.

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\", '01'))
  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 ANC15CA068Accident · No injuriesData collectionFinal reportCessna 180B · Skwentna, AKThe pilot's excessive use of brakes during the landing roll, which resulted in a nose over.Aug 30, 2015 · N59180 · Substantial damageNTSB GAA15CA253Accident · Minor injuriesData collectionFinal reportAir Creation USA Skypper · Stow, MAThe student pilot's improper directional control inputs during the takeoff roll, resulting in a roll over and collision with terrain.Aug 29, 2015 · N534AC · Substantial damageNTSB GAA15CA242Accident · No injuriesData collectionFinal reportCessna 305A · Midlothian, TXThe failure of the brake line tubing for the right main landing gear brake, due to a non-standard method used to secure the brake line, which resulted in a loss of control during landing, and a ground loop.Aug 29, 2015 · N5255G · Substantial damageNTSB WPR15LA253Accident · No injuriesLimited investigationFinal reportBeech C90 · Las Vegas, NVThe jet flight crew's use of an inappropriate checklist to resolve a parking brake hydraulic system pressure anomaly, which resulted in the airplane rolling down a slight incline and colliding with a parked twin-engine turboprop airplane. Contributing to the…Aug 28, 2015 · N959MC · 2 aircraft · Substantial damageNTSB WPR15LA251Accident · No injuriesLimited investigationFinal reportDova DV-1 · San Carlos, CAA partial loss of engine power due to fuel vapor lock. Contributing to the accident was the absence of a fuel return line.Aug 28, 2015 · N919E · Substantial damageNTSB GAA15CA250Accident · No injuriesData collectionFinal reportGrumman American Avn. G 164A · Welsh, LAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and a ground loop.Aug 28, 2015 · N8761H · Substantial damageNTSB ERA15LA333Accident · No injuriesLimited investigationFinal reportBeech E 90 · Fayetteville, TNA total loss of electrical power for reasons that could not be determined and the pilot's subsequent failure to properly follow the manual landing gear extension procedures, which resulted in the landing gear not extending.Aug 28, 2015 · N891PC · Substantial damageNTSB ERA15FA331Accident · 1 fatalField investigationFinal reportCornell W F/Sahakian J A JR Giles 202 (G202) · Newburgh, NYSeparation of the vertical and horizontal stabilizers from the fuselage due to a fracture that initiated at the bond between the left horizontal stabilizer and the flange that attached the horizontal stabilizer to the fuselage skin. The failure was likely…Aug 28, 2015 · N18FJ · DestroyedNTSB CEN15LA387Accident · Serious injuriesLimited investigationFinal reportRobinson R44 II · Cheyenne, WYThe pilot's improper preflight performance planning, which resulted in a hard landing due to low rotor rpm while operating near maximum gross weight in high density altitude conditions.Aug 28, 2015 · N440SA · Substantial damageNTSB CEN15FA386Accident · 1 fatalField investigationFinal reportBarrow Ted A ONE Easy · Battle Creek, MIThe pilot’s loss of airplane control due to his diverted attention to the canopy opening in flight.Aug 28, 2015 · N227TB · DestroyedNTSB WPR15IA252Incident · No injuriesIncident investigationFinal reportCirrus SR22 · Scottsdale, AZThe failure of the nose landing gear due to unanticipated fatigue loads.Aug 27, 2015 · N915TD · Minor 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 CEN15IA385Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Joliet, ILA bird strike.Aug 27, 2015 · N900AM · Minor damageNTSB 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 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 CEN15LA379Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Ketchum, OKThe separation of the tail rotor gearbox from the tailboom aft bulkhead due to overstress loads imposed by a blade imbalance from an in-flight impact with an undetermined object.Aug 25, 2015 · N444KD · 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 WPR15LA249Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C - Undesignat · Mesa, AZThe disbondment of a main rotor damper, which resulted in the degradation of its damping action and led to excessive main rotor vibrations and oscillations that caused substantial damage to the helicopter in flight and led to a hard landing.Aug 23, 2015 · N315TV · 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 DCA15CA176Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · Oakland, CAinadvertent jet blast, resulting in debris striking ground operations personnel.Aug 23, 2015 · N232WN · No 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 ERA15LA323Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Dorado, PRA short circuit of unknown origin, which resulted in electrical arcing in the engine compartment and smoke in the cockpit, which necessitated a precautionary landing to a field.Aug 22, 2015 · N4057V · 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 CEN15LA396Accident · No injuriesLimited investigationFinal reportBurns Mini 500 · Butler, MOThe pilot's failure to attain a proper landing flare following an autorotation for reasons that could not be determined based on available information.Aug 21, 2015 · UNREG · Substantial damageNTSB CEN15LA395Accident · No injuriesLimited investigationFinal reportBell Helicopter Textron Canada 429 · Port O'Connor, TXThe fatigue failure of the tail rotor pitch change link spherical bearing housing as a result of corrosion pitting.Aug 21, 2015 · N429AR · 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 WPR15LA248Accident · Minor injuriesLimited investigationFinal reportSikorsky S 61A · Ironside, ORA loss of power to the No. 2 engine due to the failure of the accessory gearbox drivetrain. Also causal was the pilot’s inability to release the external longline due to the use of a safety wire across the coupling of the quick-disconnect mechanism, which…Aug 20, 2015 · N1043T · 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 CEN15LA370Accident · No injuriesLimited investigationFinal reportBell 206B · Cresco, IAThe loss of engine power due to the high-cycle fatigue failure of the third-stage turbine wheel.Aug 18, 2015 · N5743W · 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 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 damage