NTSB investigations, 2009

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, 2009 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\") = 2009
  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 ANC10LA011Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Willow, AKThe pilot’s failure to ensure that the airplane’s fuel selector valve was on before takeoff, resulting in a loss of engine power due to fuel starvation, and his subsequent decision to attempt a low altitude turn towards the departure airport, resulting in an…Dec 31, 2009 · N146T · Substantial damageNTSB WPR10RA093Accident · 6 fatalClass 5 · ForeignCessna 185 · Baindoang, PNG, Papua New GuineaOn December 30, 2009, about 0618 UTC (coordinated universal time), a Papua New Guinea (PNG) registered Cessna 185E, P2-MJL, made a forced emergency landing on mountainous terrain following a loss of oil pressure, about 1 nautical mile southwest of a remote…Dec 30, 2009 · P2-MJL · DestroyedNTSB ERA10WA106Accident · 1 fatalForeign investigationHughes 369 · Pitalito, ColombiaOn December 29, 2009, about 1655 universal coordinated time (1155 local time), a Hughes 369D, Colombian registration HK4177, operated by Sociedad Aerea de Ibague, was substantially damaged during a forced landing in Pitalito, Huila, Colombia. The Colombian…Dec 29, 2009 · HK4177 · Substantial damageNTSB CEN10CA086Accident · No injuriesData collectionFinal reportHoover Frank RV-8 · Houma, LAThe pilot's failure to maintain directional control during the landing roll.Dec 29, 2009 · N17325 · Substantial damageNTSB CEN10CA089Accident · Minor injuriesData collectionFinal reportLyman Randall/Scott David Avid Flyer · Eldon, MOThe pilot's inability to climb or maintain proper airspeed due to the improper pitch setting of the propeller.Dec 28, 2009 · N491DS · Substantial damageNTSB ENG10WA007Incident · No injuriesForeign investigationBogota, ColombiaOn December 27, 2009, an Embraer EMB-190 operated by Aero Republica, a Colombian-certificated air carrier, experienced a fire in the left engine, a General Electric CF34-10E, after takeoff from El Dorado International Airport, Bogotá, Colombia. The airplane…Dec 27, 2009 · Minor damageNTSB CEN10LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Alexandria, LAA loss of engine power for undetermined reasons.Dec 27, 2009 · N7230W · Substantial damageNTSB CEN10IA084Incident · No injuriesIncident investigationFinal reportATR ATR72 · Dallas, TXA fatigue failure of an elevator stop bracket, which resulted in a partial jam of the elevator control. Contributing to the failure was the improper installation of shim stacks, poor alignment of the brackets, and cyclic stresses acting on the lower stop,…Dec 26, 2009 · N494AE · Minor damageNTSB ERA10LA102Accident · 1 fatalLimited investigationFinal reportDavis Michael J Longez · Dexter, KYThe loss of engine power due to the chaffing and grounding of the single magneto's ignition lead.Dec 25, 2009 · N499CM · DestroyedNTSB ERA10FA099Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Heflin, ALThe student pilot's failure to maintain adequate airspeed during night, adverse weather conditions, which resulted in an aerodynamic stall/spin. Contributing to the accident was the student pilot's decision to attempt a flight that he was not qualified for…Dec 25, 2009 · N1277T · Substantial damageNTSB CEN10LA085Accident · No injuriesLimited investigationFinal reportCessna 210A · Robert Lee, TXThe collapse of the right main landing gear during landing for unknown reasons.Dec 25, 2009 · N9499X · Substantial damageNTSB CEN10LA083Accident · No injuriesLimited investigationFinal reportBeech B35 · Santa Fe, NMAn engine overpressure condition that resulted in oil getting on the exhaust and producing smoke which entered the cockpit. Contributing to the accident was the pilot's obscured vision due to smoke.Dec 25, 2009 · N8828A · Substantial damageNTSB CEN10LA078Accident · Serious injuriesLimited investigationFinal reportBell Helicopter Textron Canada 407 · Decatur, TXThe pilot's inadequate preflight inspection and the momentary loss of engine power due to snow or ice ingestion.Dec 25, 2009 · N600CE · Substantial damageNTSB CEN10CA081Accident · Minor injuriesData collectionFinal reportCessna 182P · Bowie, TXA total loss of engine power due to fuel exhaustion as a result of the pilot's failure to properly secure the right wing fuel cap and monitor the available fuel supply.Dec 25, 2009 · N21177 · Substantial damageNTSB WPR10CA089Accident · No injuriesData collectionFinal reportCessna 172M · Albion, IDThe pilot's failure to maintain clearance from mountainous terrain while maneuvering in gusting winds.Dec 24, 2009 · N1883V · Substantial damageNTSB ERA10LA101Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · St. Petersburg, FLA loss of engine power for undetermined reasons.Dec 24, 2009 · N8634V · Substantial damageNTSB CEN10FA079Accident · No injuriesField investigationFinal reportSikorsky S-76C++ · Gulf of Mexico (Gulf of Mexico)The pilot's failure to fully land the helicopter prior to entering a turn in strong, crosswind conditions, which resulted in a dynamic rollover.Dec 24, 2009 · N798P · Substantial damageNTSB WPR10WA110Accident · Serious injuriesForeign investigationGarlick TH1F · Canowindra, AustraliaOn December 23, 2009, at 1850 local time, a Garlick TH-1F helicopter (modified Bell 204), Australian registry VH-UHD, registered to and operated by Coloundra Helicopter Center Pty, Ltd., collided with trees and terrain while maneuvering during an aerial fire…Dec 23, 2009 · VH-UHD · No damageNTSB WPR10LA092Accident · No injuriesLimited investigationFinal reportCessna 402C · Moab, UTThe pilot's decision to depart on a snow covered runway, which resulted in a loss of control and encounter with terrain. Contributing to the accident was the airport manager's failure to adhere to the Airport Certification Manual and close the runway due to…Dec 23, 2009 · N520NE · Substantial damageNTSB WPR10CA096Accident · No injuriesData collectionFinal reportStinson SR-8B · Auburn, WAThe pilot’s failure to maintain directional control during the landing roll.Dec 23, 2009 · N17119 · Substantial damageNTSB ERA10LA100Accident · No injuriesLimited investigationFinal reportFpna A-22 Valor · Hunting Island, SCMaintenance personnel's inadequate inspection of the oil system's fittings during a routine oil servicing, which resulted in oil starvation due to a loose and/or detached oil line B-nut fitting that led to the engine seizing while in flight.Dec 23, 2009 · N721FP · Substantial damageNTSB DCA10RA017Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Kingston, JamaicaDec 23, 2009 · N977AN · Substantial damageNTSB WPR10LA091Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Camas, WAThe left magneto's broken p-lead, which led to the engine inadvertently starting while the pilot was turning the propeller by hand.Dec 22, 2009 · N973WP · Substantial damageNTSB ERA10LA098Accident · Serious injuriesLimited investigationFinal reportCzech Aircraft Works Sportcruiser · Suffolk, VAThe pilot's inadequate recovery from a stall and inadvertent spin. Contributing to the accident was the improperly marked airspeed indicator and the airplane manufacturer's improper airspeed information. Also contributing was the instructor's inadequate…Dec 21, 2009 · N524SC · Substantial damageNTSB ENG10RA017Incident · No injuriesForeign investigationBombardier DHC-8 · London, United KingdomOn 12/21/2009 a Bombardier DHC-8-402 (G-JEDI) suffered a loss of AC electrical power on departure from London Gatwick Airport. The crew returned to London Gatwick for an uneventful landing. Subsequent maintenance revealed heat damage to a wiring loom in the…Dec 21, 2009 · G-JEDI · Minor damageNTSB WPR10CA088Accident · No injuriesData collectionFinal reportAviat A1-A · West Jordon, UTThe pilot's failure to maintain directional control of the airplane during the landing roll in gusting wind conditions.Dec 19, 2009 · N17HY · Substantial damageNTSB ERA10RA097Accident · 2 fatalForeign investigationDassault/Sud Falcon 20 · Matthew Town, BahamasOn December 17, 2009, about 1922 eastern standard time, a Dassault Falcon 20, N28RK, crashed in a remote area approximately 12 miles east of Matthew Town, Inagua, Bahamas. The 2 pilots were killed and the airplane was destroyed. Night, visual meteorological…Dec 18, 2009 · N28RK · DestroyedNTSB DCA10CA018Accident · Minor injuriesData collectionFinal reportBombardier CL600 2C10 · Dallas, TXThe fueler's falling asleep in the fueling truck with the truck in neutral and without the parking brake set, which allowed the truck to roll until it impacted the airplane.Dec 18, 2009 · N515AE · Substantial damageNTSB CEN10CA082Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Abilene, TXThe pilot's failure to maintain directional control during the air taxi with shifting winds.Dec 18, 2009 · N442RS · Substantial damageNTSB CEN10CA077Accident · No injuriesData collectionFinal reportCessna 172P · Ames, IAThe pilot's failure to maintain directional control while attempting a takeoff on an ice-covered runway.Dec 18, 2009 · N99930 · Substantial damageNTSB ANC10CA010Accident · No injuriesData collectionFinal reportStinson 108-1 · Selawik, AKThe pilot's failure to maintain a proper descent rate during landing, resulting in a hard landing.Dec 18, 2009 · N136SP · Substantial damageNTSB WPR10LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Corona, CAA loss of engine power for undetermined reasons.Dec 17, 2009 · N8520U · Substantial damageNTSB ENG10RA009Incident · No injuriesForeign investigationBoeing 747 · Changi Airport, SingaporeOn December 17, 2009, a Boeing B747-200F airplane, Reg. 9V-JEB, operated by Jett8 Cargo, experienced a commanded engine in-flight shutdown and air turn back to Changi Airport, Singapore,following an uncontained LPT failure of its No. 4 GE CF6-50 engine, at…Dec 17, 2009 · JV-JEB · Minor damageNTSB DCA10WA028Accident · No injuriesForeign investigationBoeing 727 · Manaus, BrazilOn December 17, 2009, a TAF Cargo B727, Brazilian registration PR-MTL, struck trees on approach to the Manaus Airport. The airplane went around and diverted. The airplane had damage to the leading edge, slats, and landing gear. This accident is being…Dec 17, 2009 · PR-MTL · Minor damageNTSB WPR10WA148Accident · Serious injuriesForeign investigationRobinson R-44 · Montreal, Canada, CanadaOn December 16, 2009, at 0720 eastern standard time, a Robinson R-44, Canadian registered C-GDSF, executed an emergency landing near the Bonaventure Highway, in Montreal, Canada. The pilot and passenger were seriously injured, and the helicopter was…Dec 16, 2009 · C-GDSF · Substantial damageNTSB WPR10FA085Accident · Serious injuriesField investigationFinal reportEurocopter AS350BA (FX2) · Hana, Maui, HIAn uncommanded engine shutdown due to an improperly calibrated fuel control unit (FCU) and power turbine governor (PTG). Also causal was the operator’s inadequate maintenance practices and procedures that failed to properly assess and correct the FCU and PTG…Dec 16, 2009 · N87EW · Substantial damageNTSB WPR10LA083Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · San Jose, CAA total loss of engine power due to water contamination in the fuel system as a result of the pilot's inadequate preflight inspection.Dec 15, 2009 · N9547D · Substantial damageNTSB ERA10FAMS1Accident · 1 fatalMissing aircraftFinal reportCirrus SR22 · Gulf of MexicoUndetermined (airplane and pilot missing).Dec 15, 2009 · N723LJ · DestroyedNTSB WPR10LA082Accident · Minor injuriesLimited investigationFinal reportEADS Socata TBM 700 · Truckee, CAThe pilot’s failure to maintain an adequate airspeed and clearance from terrain during an attempted go-around. Contributing to the accident was the pilot's decision to land on a partially obscured runway.Dec 14, 2009 · N850MT · Substantial damageNTSB DCA10IA015Incident · No injuriesIncident investigationFinal reportBoeing MD · Charlotte, NCThe Captain's failure to initiate a go-around from a Category III approach when satisfactory tracking performance was not maintained below the required altitude resulting in excessive bank angle maneuvers at low altitude. Factors contributing to the incident…Dec 14, 2009 · N483A · Minor damageNTSB ERA10WA312Accident · 5 fatalForeign investigationBeech 58 · Guarico, VenezuelaOn December 13, 2009, about 2040 UTC, a Beech 58, of Venezuelan registration, YV2473, registered to and operated by Aeronaves Baron, C.A., impacted terrain during takeoff from the Mata de Juajua Airport (SVCS), near Estatdo Guárico, Venezuela. Visual…Dec 13, 2009 · YV2473 · Substantial damageNTSB CEN10LA074Accident · Serious injuriesLimited investigationFinal reportGibson Mark Manta 503 · Magnolia, TXThe pilot's failure to maintain clearance from a static wire while maneuvering and his improper decision to fly with a low overcast sky.Dec 13, 2009 · N193AW · Substantial damageNTSB CEN10FA071Accident · 1 fatalField investigationFinal reportCessna 310R · Alva, OKThe pilot's impairment due to medication use, a migraine headache, or both, and his decision to continue the approach below minimums without the proper visual references, resulting in the subsequent collision with terrain. Contributing to the accident was the…Dec 13, 2009 · N310CR · Substantial damageNTSB WPR10LA090Accident · No injuriesLimited investigationFinal reportCessna 310 · Pasco, WAThe failure of the right main landing gear up-lock.Dec 12, 2009 · N2640C · Substantial damageNTSB ERA10WA096Accident · 1 fatalForeign investigationHuber Hartmut Express · Berry Island, BahamasOn December 12, 2009, at 1300 UTC, an experimental, amateur-built Harmut Huber Express, N93HE, operated by a private individual, crashed into the water on short final approach to Chub Cay Airport (MYBC), Berry Island, Bahamas. The pilot was killed and the…Dec 12, 2009 · N93HE · Substantial damageNTSB WPR10CA081Accident · No injuriesData collectionFinal reportCessna 182P · Payson, AZThe pilot's improper landing flare, which resulted in a hard landing.Dec 11, 2009 · N11PG · Substantial damageNTSB CEN10LA076Accident · No injuriesLimited investigationFinal reportBeech 200 · St. Louis, MOThe pilot's failure to properly follow the manual landing gear extension procedure, resulting in a gear-up landing.Dec 11, 2009 · N411BL · Substantial damageNTSB CEN10FA070Accident · 2 fatalField investigationFinal reportPiper PA-30 · Port Mansfield, TXThe pilot’s failure to maintain clearance with the water while on approach (VFR) to land.Dec 11, 2009 · N7781Y · DestroyedNTSB CEN10CA075Accident · No injuriesData collectionFinal reportCessna 172 · Pearland, TXThe student pilot's failure to control the airplane's descent rate during the short-field landing, resulting in a hard landing. Contributing to the accident was the flight examiner's delayed response.Dec 11, 2009 · N172BJ · Substantial damageNTSB WPR10FA078Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Ojai, CAAirspeed was not maintained, which resulted in a loss of control and the airplane entering into a stall/spin to the ground. Contributing to the accident was a loss of engine power due to carburetor icing.Dec 10, 2009 · N2463K · Substantial damage