NTSB investigations, 2014

180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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
NTSB investigations, 2014 per year, 1962–2026: 180,581 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,514
19843,405
19853,055
19862,831
19872,774
19882,685
19892,502
19902,479
19912,419
19922,328
19932,283
19942,229
19952,281
19962,150
19972,121
19982,195
19992,175
20002,183
20012,031
20022,000
20032,062
20041,930
20052,001
20061,826
20071,984
20081,882
20091,783
20101,786
20111,848
20121,834
20131,561
20141,534
20151,581
20161,662
20171,635
20181,687
20191,626
20201,396
20211,645
20221,700
20231,678
20241,693
20251,655
20261,342

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
  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 DCA15WA212Incident · No injuriesForeign investigationBoeing 737 · Lahore, PakistanThe Pakistan Civil Aviation Authority (PCAA) has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on December 30, 2014. The NTSB has appointed a U.S. Accredited Representative to assist PCAA's investigation under the provisions…Dec 30, 2014 · AP-BJN · Minor 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 WPR15WA075Accident · 2 fatalForeign investigationCessna 172 - S · Port Arthur, Australia, AustraliaOn December 29, 2014, at 1747 local, a Cessna 172S, VH-PFT, collided with water near Port Arthur, Australia during an aerial photography flight. The airplane was operating under the pertinent civil regulations of the government of Australia. The airplane was…Dec 29, 2014 · VH-PFT · 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 DCA15WA046Accident · 162 fatalForeign investigationAirbus A320 - 216 · Pangkalan Bun, IndonesiaThe National Transportation Safety Committee (NTSC) of Indonesia, has notified the NTSB of an accident involving an Airbus A320-216 that occurred on December 28, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the NTSC investigation…Dec 28, 2014 · PK-AXC · DestroyedNTSB ERA15WA098Accident · 5 fatalForeign investigationAerospatiale AS350B · Bertioga, BrazilOn December 27, 2014, about 1240 UTC, an Aerospatiale AS350B, Brazil registration PT-HNC, collided with trees near Rio-Santos, Bertioga, Brazil. The pilot and 4 passengers were fatally injured, and the helicopter was destroyed. The helicopter was registered…Dec 27, 2014 · PT-HNC · DestroyedNTSB 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 ENG15WA019Incident · No injuriesForeign investigationAirbus A330 - 201 · Athens, Greece, GreeceOn 12/26/2014 an Airbus A330 operated by XL Airways took off from La Réunion (Indian Ocean) to Marseille (France). The information provided by the three inertial reference systems became successively unavailable, leading autopilot + auto-thrust to disconnect,…Dec 26, 2014 · F-GRSQ · No 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 ERA15WA082Accident · 7 fatalForeign investigationCessna T207 - A · Piedecuesta, ColombiaOn December 24, 2014, about 1950 UTC, a Cessna T207A, HK4892, collided with mountainous terrain near Vereda Cabreras, Punto el Guanabanazo, Pescadero Piedecuesta, Santander, Colombia. The commercial pilot and six passengers were fatally injured. The airplane…Dec 24, 2014 · HK4892 · DestroyedNTSB CEN15WA096Accident · No injuriesForeign investigationPiper PA-32-260 · Lorrha, Tipperary, Ireland, IrelandOn December 24, 2014, at 1410 universal coordinated time (UTC), a Piper PA-32-260, United Kingdom registration G-OCTI, sustained substantial damage during an forced landing near Lorrha, Tipperary, Ireland, after experiencing an engine failure. There were no…Dec 24, 2014 · G-OCTI · 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 CEN15WA082Accident · 2 fatalForeign investigationGates Learjet 25D · Champoton, MexicoDec 19, 2014 · N265TW · Substantial 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 DCA15WA043Accident · No injuriesForeign investigationBoeing 737-800 · London, United KingdomThe United Kingdom's Air Accidents Investigations Branch (AAIB), has notified the NTSB of an accident involving a Boeing 737-800 that occurred on December 17, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…Dec 17, 2014 · EI-EBR · Substantial damageNTSB DCA15RA045Incident · No injuriesForeign investigationBoeing 757 - 236 · Warsaw, PolandThe State Commission on Aircraft Accident Investigation (SCAAI) of Poland has notified the NTSB of an incident involving a Boeing 757-236 that occurred on December 17, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the SCAAI of…Dec 17, 2014 · DALED · No 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 ENG15RA010Incident · No injuriesForeign investigationBombardier DHC-8-402 · Belfast, N Ireland, United KingdomOn December 16, 2014, about 1839 UTC, a DeHavilland DHC-8-400Q, powered by two Pratt & Whitney Canada (PWC) PW150A turboprop engines, experienced an engine casing burn-through and in-flight shutdown near Belfast International Airport. Belfast, N. Ireland.…Dec 16, 2014 · G-FLBCNTSB DCA15WA041Accident · Serious injuriesForeign investigationBoeing 777 223 · Ishikawa, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 777-200 that occurred on December 16, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO…Dec 16, 2014 · N751AN · No damageNTSB CEN15WA113Incident · No injuriesForeign investigationSaab-Scania Saab 2000 · Sumburgh, United KingdomOn December 15, 2014, about 1955 coordinated universal time, a SAAB-Scania SAAB 2000 airplane, G-LGNO, lost elevator control following a lightning strike on approach to Sumburgh Airport, Sumburgh, United Kingdom. The damage to the airplane is unknown. The…Dec 15, 2014 · G-LGNONTSB CEN15WA108Accident · 4 fatalForeign investigationAirbus Helicopter EC135T2+ · Lake Siutghiol, RomaniaOn December 14, 2014, about 1615 local time, an Airbus Helicopter EC135T2+ helicopter, Romanian registration number 348, impacted Lake Siutghiol, Romania. The four occupants, flight and medical crew, were all fatally injured. The helicopter sustained…Dec 15, 2014 · N348 · 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 damage