Final NTSB investigations, 2014

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19622026
Final NTSB investigations, 2014 per year, 1962–2026: 171,584 cases
196272
196378
19645,253
19655,377
19665,912
19676,339
19685,199
19695,027
19704,915
19714,825
19724,430
19734,398
19744,565
19754,403
19764,314
19774,412
19784,624
19794,165
19803,921
19813,836
19823,545
19833,511
19843,403
19853,051
19862,824
19872,757
19882,651
19892,478
19902,451
19912,391
19922,293
19932,244
19942,190
19952,216
19962,091
19972,038
19982,061
19992,069
20002,026
20011,876
20021,868
20031,928
20041,776
20051,826
20061,644
20071,809
20081,714
20091,613
20101,561
20111,612
20121,578
20131,317
20141,321
20151,317
20161,344
20171,334
20181,354
20191,309
20201,141
20211,216
20221,272
20231,216
20241,139
2025779
2026365

Latest cases

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.\"completionStatus\" = 'Completed'
  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 WPR15TA071Accident · Serious injuriesFinal reportMD Helicopter 369FF · Las Vegas, NVA total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination and testing did not reveal any anomalies that would have precluded normal operation.Dec 31, 2014 · N530KK · Substantial damageNTSB WPR15IA080Incident · No injuriesIncident investigationFinal reportRobinson Helicopter R22 Beta II · Phoenix, AZThe failure of the fanshaft due to fatigue.Dec 30, 2014 · N7041X · No damageNTSB ERA15LA087Accident · No injuriesLimited investigationFinal reportMDS Fying Zenith Zodiac CH 650 · Fort Pierce, FLThe inadequate modification of the airplane’s canopy latching mechanism, which resulted in the inadvertent opening of the canopy while on final approach to land and a subsequent loss of pitch control.Dec 30, 2014 · N419PE · Substantial damageNTSB CEN15LA091Accident · No injuriesLimited investigationFinal reportCessna 208B · Roswell, NMThe pilot's failure to maintain adequate airspeed to compensate for icing on the airplane's wings and control surfaces during a circling approach, which resulted in an aerodynamic stall and impact with terrain.Dec 30, 2014 · N950FE · Substantial damageNTSB CEN15FA092Accident · 2 fatalField investigationFinal reportPiper PA 28-181 · Vaughn, NMThe noninstrument-rated pilot’s continued flight into night instrument meteorological conditions, which resulted in his failure to maintain clearance from terrain.Dec 30, 2014 · N2558M · Substantial damageNTSB CEN15FA090Accident · 1 fatalField investigationFinal reportCessna 404 · Englewood, COThe loss of power to the right engine for reasons that could not be determined during postaccident examination and teardown and the pilot’s failure to properly configure the airplane for single-engine flight.Dec 30, 2014 · N404MG · Substantial damageNTSB ERA15FA085Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Lake Worth, FLA main rotor stall due to low rotor rpm, which resulted in an uncontrolled descent into terrain. Contributing to the accident was the flight instructor’s delayed remedial action.Dec 29, 2014 · N771MM · Substantial damageNTSB CEN15FA088Accident · 1 fatalField investigationFinal reportPiper PA 23-160 · Port Clinton, OHThe pilot's loss of control following a loss of left engine power for reasons that could not be determined because an examination of the airframe and engine did not reveal any preimpact abnormalities.Dec 29, 2014 · N222CP · DestroyedNTSB CEN15CA093Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Horseshoe Bay, TXThe helicopter's contact with the landing pad during a rejected landing.Dec 29, 2014 · N174CD · Substantial damageNTSB ERA15CA086Accident · No injuriesData collectionFinal reportCessna 310N · Liberty, NCThe pilot's improper landing flare, which resulted in a hard landing and collapse of the left main landing gear.Dec 28, 2014 · N177JD · Substantial damageNTSB ERA15LA084Accident · Serious injuriesLimited investigationFinal reportAerotek Pitts Special S-1S · Westminster, MDThe pilot’s failure to see and avoid the other airplane, which resulted in a midair collision while both airplanes were on final approach to land.Dec 27, 2014 · N49294 · 2 aircraft · Substantial damageNTSB ERA15CA083Accident · No injuriesData collectionFinal reportCessna 182P · Nashville, TNThe pilot's inadequate control of the airplane during the landing roll, which resulted in a runway excursion.Dec 26, 2014 · N6063F · Substantial damageNTSB WPR15FA070Accident · 2 fatalField investigationFinal reportCessna 172 · Sutter Creek, CAThe noninstrument-rated pilot's encounter with instrument meteorological conditions (IMC) while maneuvering, which resulted in a loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot's decision to attempt to…Dec 24, 2014 · N8518B · Substantial damageNTSB CEN15FA087Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Port Huron, MIThe pilot’s decision to continue flight below the minimum descent altitude without visually acquiring the runway and his delayed and improperly executed missed approach procedure in instrument meteorological conditions.Dec 24, 2014 · N38884 · DestroyedNTSB ERA15LA091Accident · Minor injuriesLimited investigationFinal reportCessna 172M · South Bimini, BahamasThe total loss of engine power for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation, which resulted in a subsequent ditching in the ocean.Dec 22, 2014 · N12182 · Substantial damageNTSB ERA15CA079Accident · No injuriesData collectionFinal reportRobinson Helicopter R66 · Henniker, NHThe pilot's failure to maintain aircraft control while landing, which resulted in a collision with a snow bank. Contributing to the accident was ice that covered the landing surface.Dec 22, 2014 · N64HF · Substantial damageNTSB CEN15FA083Accident · 1 fatalField investigationFinal reportCessna 172M · Odessa, TXThe pilot’s failure to maintain adequate airspeed while maneuvering at an excessive bank angle at a low altitude, which resulted in an accelerated stall and spin with insufficient altitude for a recovery.Dec 22, 2014 · N9922V · DestroyedNTSB WPR15LA067Accident · Serious injuriesLimited investigationFinal reportFarthing James W II Beaver · Perris, CAThe partial loss of engine power during takeoff due to an improperly configured carburetor and fuel supply system. Contributing to the accident was the pilot's loss of airplane control during the off-field landing, which resulted in an aerodynamic stall.Dec 21, 2014 · N105JF · Substantial damageNTSB ERA15CA081Accident · No injuriesData collectionFinal reportBell 430 · Miami Gardens, FLThe pilot's misjudgment of his helicopter's position relative to a parked helicopter during a pedal turn.Dec 21, 2014 · N430WH · Substantial damageNTSB WPR15CA066Accident · No injuriesData collectionFinal reportFerdon Thorp T 18 · San Rafael, CAThe pilot's delayed decision to abort the takeoff. Contributing to the accident are an inadequate modification to the seat position, and the pilot's failure to check flight controls for freedom and correct movement.Dec 20, 2014 · N25VP · Substantial damageNTSB ERA15CA080Accident · No injuriesData collectionFinal reportBauer Thomas G Kitfox III · Bumpass, VAThe pilot's improper flare during a water landing.Dec 20, 2014 · N573TB · Substantial damageNTSB ANC15IA006Incident · No injuriesIncident investigationFinal reportCessna 180J · Nome, AKThe disengagement and subsequent binding of the right tailwheel steering cable, which disabled the rudder system.Dec 20, 2014 · N393B · Minor damageNTSB CEN15FA081Accident · 1 fatalField investigationFinal reportBeech V35A · Seagoville, TXThe pilot’s loss of control and subsequent impact with terrain in instrument meteorological conditions.Dec 19, 2014 · N555SF · DestroyedNTSB CEN15LA089Accident · No injuriesLimited investigationFinal reportCessna 310J · San Antonio, TXThe retraction of the left main landing gear after landing for reasons that could not be determined during postaccident examinations.Dec 18, 2014 · N700MA · Substantial damageNTSB WPR15FA062Accident · 1 fatalField investigationFinal reportPiper PA 18-150 · Ronan, MTThe pilot’s failure to maintain clearance from terrain while performing an intentional, abrupt low-level maneuver.Dec 16, 2014 · N5989Z · Substantial damageNTSB WPR15CA063Accident · No injuriesData collectionFinal reportEurocopter AS 350 B2 Ecureuil · Bicknell, UTThe pilot's failure to prevent the helicopter from settling with power while maneuvering at a low altitude, which resulted in a loss of control and subsequent hard landing.Dec 16, 2014 · N352SL · Substantial damageNTSB CEN15LA078Accident · No injuriesLimited investigationFinal reportPiper PA 46 350P · Houston, TXThe nose landing gear collapse as a result of the fracture of the engine mount at the nose gear actuator attachment point in an area that a service bulletin (SB) recommended for inspection. Contributing to the accident was maintenance personnel’s inadequate…Dec 15, 2014 · N224JJ · Substantial damageNTSB ERA15FA076Accident · 1 fatalField investigationFinal reportTitan Tornado II · Catlett, VAThe pilot’s failure to maintain airspeed while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.Dec 14, 2014 · N50402 · Substantial damageNTSB ERA15LA077Accident · No injuriesLimited investigationFinal reportThomas R Wade Revelation · Ellisville, MSThe failure of the uncertified engine's front connecting rod needle bearing, which resulted in damage to the front piston and a subsequent loss of engine power. Contributing to the accident was the pilot’s decision to operate the airplane with the uncertified…Dec 13, 2014 · N783QJ · Substantial damageNTSB ERA15LA075Accident · 1 fatalLimited investigationFinal reportJohnson David Earl Renegade Spirit · Brunswick, GAThe pilot's decision to fly the airplane with known engine deficiencies and his subsequent exceedance of the airplane's critical angle of attack following a loss of engine power, which resulted in an aerodynamic stall and loss of control after takeoff.Dec 13, 2014 · N955R · Substantial damageNTSB DCA15CA037Accident · No injuriesData collectionFinal reportBoeing 737 · Baltimore, MDan inadvertent encounter with birds during approach to land that resulted in substantial damage.Dec 13, 2014 · N7710A · Substantial damageNTSB WPR15CA059Accident · Serious injuriesData collectionFinal reportCessna 182T · Wendover, UTThe pilot's failure to maintain situational awareness during a turn which resulted in a loss of airplane control.Dec 12, 2014 · N961GW · Substantial damageNTSB CEN15LA077Accident · Serious injuriesLimited investigationFinal reportNew Piper PA 32R-301T · Springfield, MOThe pilot’s decision to descend below the recommended altitude during approach for landing in night visual meteorological conditions, and his failure to see and avoid a lighted tower, which resulted in collision with the tower and a subsequent total loss of…Dec 12, 2014 · N3127R · Substantial damageNTSB CEN15IA085Incident · No injuriesIncident investigationFinal reportDassault/Sud FAN JET Falcon · Shreveport, LAA short in the trim system’s wires and connector, which resulted in the elevator trim being in a full nose-down position.Dec 12, 2014 · N827AA · No damageNTSB CEN15IA079Incident · No injuriesIncident investigationFinal reportCessna T182T · Cahokia, ILThe mechanic’s improper installation of the elevator trim actuator, which resulted in reversed elevator trim control, and his subsequent failure to detect the misrigging of the elevator cables during the postmaintenance inspection.Dec 12, 2014 · N93CL · No damageNTSB DCA15CA050Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · San Jose, CAan inadvertent encounter with convective turbulence during descent.Dec 11, 2014 · N481WN · No damageNTSB WPR15LA058Accident · No injuriesLimited investigationFinal reportMcholland Glastar · Sheridan, WYA loss of engine power while maneuvering at low altitude for reasons that could not be determined during postaccident examination.Dec 10, 2014 · N16XP · Substantial damageNTSB CEN15IA076Incident · No injuriesIncident investigationFinal reportCessna 182S · Springfield, ILThe improper installation of a doubler patch, which prevented the right flap from actuating and moving properly and led to the subsequent interference with the aileron.Dec 10, 2014 · N661SP · Minor damageNTSB WPR15CA057Accident · Minor injuriesData collectionFinal reportCessna P210 - N · Jeffrey, WYThe pilot's inadequate approach and excessive airspeed, which resulted in a long landing, the subsequent runway overrun, and impact with terrain. Contributing to the accident was the pilot's delay in aborting the landing.Dec 9, 2014 · N4881K · Substantial damageNTSB DCA15MA029Accident · 6 fatalClass 1 · MajorFinal reportEmbraer EMB-500 · Gaithersburg, MDthe pilot's conduct of an approach in structural icing conditions without turning on the airplane's wing and horizontal stabilizer deice system, leading to ice accumulation on those surfaces, and without using the appropriate landing performance speeds for…Dec 8, 2014 · N100EQ · DestroyedNTSB CEN15LA084Accident · Minor injuriesLimited investigationFinal reportEnstrom 280FX · Fort Lupton, COThe loss of engine power during cruise flight for reasons that could not be determined based on the available information.Dec 8, 2014 · N409LH · Substantial damageNTSB CEN15CA095Accident · No injuriesData collectionFinal reportCessna 152 · Mount Pleasant, TXThe pilot's decision to maneuver the airplane at low altitude resulting in the airplane impacting power lines.Dec 8, 2014 · N787PB · DestroyedNTSB WPR15CA056Accident · No injuriesData collectionFinal reportTaylorcraft BL 65 · Everett, WAThe pilot's failure to maintain directional control during the landing roll resulting in a runway excursion and collision with hangars.Dec 7, 2014 · N27580 · Substantial damageNTSB CEN15CA071Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Minocqua, WIThe pilot did not maintain directional control of the airplane during the landing flare when a sudden wind shift occurred.Dec 7, 2014 · N41594 · Substantial damageNTSB WPR15LA055Accident · No injuriesLimited investigationFinal reportFouga CM 170R Magister · Lake Havasu City, AZA total loss of engine power to both engines during descent due to fuel starvation as a result of an interruption of the fuel flow, which resulted in a forced landing to a short strip and a subsequent overrun.Dec 6, 2014 · N300FM · Substantial damageNTSB CEN15CA073Accident · No injuriesData collectionFinal reportCessna 152 · Berrien Springs, MIThe pilot's failure to maintain aircraft control during the landing and his poor decision not to abort the landing before the airplane traveled off the end of the airstrip.Dec 6, 2014 · N25979 · Substantial damageNTSB CEN15CA072Accident · Minor injuriesData collectionFinal reportCubcrafters CC11-160 · Middleton, WIThe pilot's failure to maintain control of the airplane while braking during landing rollout.Dec 6, 2014 · N471LS · Substantial damageNTSB ERA15LA072Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Brookline, NHThe student pilot’s failure to maintain clearance from a wire during an off-airport landing following a partial loss of engine power for reasons that could not be determined during postaccident examination.Dec 5, 2014 · N50709 · Substantial damageNTSB CEN15LA069Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR20 · Fort Collins, COThe student pilot’s failure to comprehend the significance of the wake turbulence that a preceding helicopter would generate during departure, which resulted in a loss of airplane control during landing. Contributing to the accident was the lack of Federal…Dec 5, 2014 · N407ND · Substantial damageNTSB ERA15LA071Accident · Minor injuriesLimited investigationFinal reportCessna 210 5(205) · Sussex, NJMaintenance personnel’s inadequate inspection of the No. 2 cylinder valve area during the most recent annual inspection, which resulted in the in-flight failure of the intake valve springs due to rust on the spring surfaces and subsequent fatigue cracking.Dec 4, 2014 · N8296Z · Substantial damage