NTSB investigations, 2009

669 cases where NTSB found Environmental issues.

Cases per year

20082026
NTSB investigations, 2009 per year, 2008–2026: 10,307 cases
2008933
2009669
2010591
2011564
2012566
2013507
2014612
2015568
2016665
2017700
2018663
2019613
2020441
2021463
2022428
2023437
2024426
2025312
2026149

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
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03'))
  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 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 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 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 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 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 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 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 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 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 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 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 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 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 damageNTSB CEN10FA069Accident · 1 fatalField investigationFinal reportBeech A36 · Eagle Pass, TXThe pilot's decision to continue the approach below minimums without visual references, and subsequent collision with the perimeter fence/terrain.Dec 9, 2009 · N1105N · DestroyedNTSB WPR10LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Fresno, CAA total loss of engine power for undetermined reasons.Dec 8, 2009 · N2539D · Substantial damageNTSB ERA10FA091Accident · 4 fatalField investigationFinal reportCessna 172S · Kissimmee, FLThe pilot's decision to depart under special VFR flight at night when instrument meteorological conditions prevailed at the departure airport and along the route of flight and his continued VFR flight into instrument meteorological conditions, which resulted…Dec 8, 2009 · N5269X · DestroyedNTSB CEN10FA065Accident · 2 fatalField investigationFinal reportNew Piper PA-46-500TP · Mendoza, TX***This report was modified on May 22, 2014. Please see the docket for this accident to view the original report.*** The pilot's spatial disorientation, which resulted in his loss of airplane control. Contributing to the pilot's spatial disorientation was the…Dec 7, 2009 · N600YE · Substantial damageNTSB WPR10CA073Accident · No injuriesData collectionFinal reportCessna 172M · Diamond Point, WAThe pilot's inadequate compensation for the variable and unfavorable wind conditions.Dec 6, 2009 · N20186 · Substantial damageNTSB ERA10LA092Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Hatteras, NCThe pilot's inability to maintain directional control during an aborted takeoff for undetermined reasons.Dec 6, 2009 · N5319J · Substantial damageNTSB CEN10LA068Accident · No injuriesLimited investigationFinal reportBeech V35 · Dodge City, KSThe failure of the pitot heat system in icing conditions resulting in an inoperative airspeed indicator which led to an inadvertant stall while on final approach. Contributing to the accident was the pilot's decision to fly into known icing conditions.Dec 6, 2009 · N108L · Substantial damageNTSB WPR10LA072Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Clarksburg, CAThe pilot’s improper touchdown point and excessive airspeed during landing, which resulted in a runway overrun.Dec 4, 2009 · N6649M · Substantial damageNTSB ERA10CA090Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Patillas, PRThe pilot's inadequate visual lookout and failure to maintain clearance from a tree.Dec 2, 2009 · N2539K · Substantial damageNTSB WPR10CA077Accident · No injuriesData collectionFinal reportPilatus Britten-Norman BN-2B-26 · Pago Pago, AntarcticaThe pilot's action to maneuver the airplane to avoid a collision with a flock of birds while on final approach, resulting in a hard landing. Contributing to the accident were the birds.Nov 30, 2009 · N27BN · Substantial damageNTSB WPR10FA068Accident · 2 fatalField investigationFinal reportSchleicher ASW-27 · Middletown, CAThe failure of both pilots to see and avoid the other airplane. Contributing to the accident was the pilot's failure to yield right of way to the glider.Nov 28, 2009 · N127AL · 2 aircraft · Substantial damageNTSB WPR10CA071Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Stockton, CAThe pilot’s inadequate compensation for a crosswind condition.Nov 28, 2009 · N83516 · Substantial damageNTSB WPR10CA067Accident · Minor injuriesData collectionFinal reportPiper PA-25-260 · Llano, CAThe pilot's inadequate compensation for the gusting crosswind conditions and failure to maintain lateral and directional control.Nov 27, 2009 · N9600P · Substantial damageNTSB ERA10LA077Accident · No injuriesLimited investigationFinal reportCessna 170B · Durham, NCThe total loss of engine power in flight and a fire in the engine compartment for undetermined reasons.Nov 25, 2009 · N2758D · DestroyedNTSB ERA10WA416Accident · No injuriesForeign investigationEmbraer EMB-720 · Fazenida Liberdade, Brazil, BrazilOn November 23 18, 2009, about 1440 Universal Coordinated Time (UTC), an Embraer EMB-720D, Brazilian registration PT-VIF, operated by W.P.Comercio De Cereais LTDA, collided with a fence as a result of a force landing from a loss of engine power during cruise…Nov 23, 2009 · PT-VIF · Substantial damageNTSB ERA10FA088Accident · 1 fatalField investigationFinal reportPiper PA-30 · Raneille, WVThe pilot's improper decision to attempt visual flight into deteriorating night weather conditions, and his subsequent controlled flight into terrain.Nov 23, 2009 · N8923Y · Substantial damageNTSB CEN10FA057Accident · 1 fatalField investigationFinal reportCessna 182P · Kewanee, ILThe pilot's decision to initiate a visual night flight without recent night flight experience and his failure to maintain altitude during departure.Nov 23, 2009 · N1986M · Substantial damageNTSB WPR10CA062Accident · No injuriesData collectionFinal reportCessna 172 · Yucca Valley, CAThe pilot's inadequate compensation for the crosswind gusts and failure to maintain directional control of the airplane.Nov 21, 2009 · N8504B · Substantial damageNTSB WPR10LA059Accident · 1 fatalLimited investigationFinal reportCessna 182K · Susanville, CAThe pilot's decision to takeoff into weather conditions conducive to ice accumulation, which resulted in an inadvertent stall/spin while maneuvering in the initial climb. Contributing to the accident was the likely accumulation of snow and ice on the airborne…Nov 20, 2009 · N2650R · Substantial damageNTSB ERA10CA087Accident · Minor injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Ashland, VAThe pilot’s failure to maintain adequate clearance from trees during the landing approach.Nov 20, 2009 · N319UA · Substantial damageNTSB DCA10FA012Accident · Serious injuriesField investigationFinal reportBoeing 777-200 · New Market, VAThe flight crew’s inadvertent encounter with a small area of cumulous clouds at night that resulted in moderate to severe convectively induced turbulence.Nov 19, 2009 · N209UA · No damageNTSB WPR10FA056Accident · 1 fatalField investigationFinal reportBeech A36 · San Gabriel, CAFailure of the exhaust band V-clamp during cruise flight, which resulted in an in-flight fire and a subsequent forced landing.Nov 15, 2009 · N17803 · Substantial damageNTSB ERA10LA066Accident · 2 fatalLimited investigationFinal reportPiper PA-28-140 · Newcomb, NYThe pilot’s failure to maintain clearance from mountainous terrain during descent at night, with low clouds and fog.Nov 15, 2009 · N1723T · Substantial damageNTSB ERA10CA072Accident · Serious injuriesData collectionFinal reportAirframes Unlimited Coyote · Indian Trail, NCA loss of engine power due to carburetor icing.Nov 15, 2009 · N59748 · Substantial damageNTSB CEN10IA053Incident · No injuriesIncident investigationFinal reportAirbus A319-111 · Kansas City, MOThe in-flight engine ingestion of one or more Lesser Snow Geese (Chen caerulescens caerulescens).Nov 15, 2009 · N924FR · Minor damageNTSB WPR10FA055Accident · 3 fatalField investigationFinal reportAerospatiale AS350BA · Doyle, CAThe pilot became spatially disoriented while maneuvering on a dark night, which resulted in a loss of helicopter control.Nov 14, 2009 · N5793P · Substantial damageNTSB CEN10LA055Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Naytahwaush, MNThe non-instrument rated pilot's decision to continue the flight into known instrument meteorological conditions resulting in spatial disorientation and impact with terrain.Nov 14, 2009 · N7736N · DestroyedNTSB ANC10CA008Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's decision to land and attempt to takeoff from an unsuitable off-airport site.Nov 14, 2009 · N3797Z · Substantial damageNTSB ERA10CA061Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Clarksville, TNThe pilot’s failure to maintain directional control during the takeoff roll. Contributing to the accident was his decision to take off with a left quartering tailwind.Nov 12, 2009 · N315AC · Substantial damageNTSB WPR10CA058Accident · Serious injuriesData collectionFinal reportCameron Balloons US A-250 · Napa, CAThe pilot's encounter with variable winds which resulted in a hard landing and passenger injury.Nov 11, 2009 · N4062M · No damageNTSB CEN10LA046Accident · Serious injuriesLimited investigationFinal reportYounkin J R Mullicoupe · Siloam Springs, ARA loss of engine power due to fuel starvation for undetermined reasons.Nov 10, 2009 · N273X · Substantial damageNTSB WPR10LA051Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Tucson, AZA loss of engine power for undetermined reasons.Nov 8, 2009 · N2165M · Substantial damage