NTSB investigations, 2008

604 cases where NTSB found Physical environment.

Cases per year

20082026
NTSB investigations, 2008 per year, 2008–2026: 5,697 cases
2008604
2009361
2010303
2011244
2012265
2013274
2014379
2015332
2016421
2017457
2018431
2019396
2020251
2021221
2022198
2023186
2024172
2025129
202673

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\") = 2008
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0302'))
  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 ERA09FA116Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Pittstown, NJThe pilot's failure to maintain an adequate clearance from trees during the night landing approach and the flight instructor's inadequate remedial action.Dec 31, 2008 · N95156 · Substantial damageNTSB CEN09CA121Accident · No injuriesData collectionFinal reportCessna 150M · Greene, IAA loss of engine power due to undetermined reasons. Contributing to the accident was the rough, snow-covered terrain.Dec 31, 2008 · N899CB · Substantial damageNTSB WPR09CA093Accident · No injuriesData collectionFinal reportStemme S-10 · San Jose, CAThe pilot's failure to maintain clearance from an obstacle during taxi.Dec 30, 2008 · N8679 · Substantial damageNTSB ERA09LA114Accident · No injuriesLimited investigationFinal reportJohnson Barron T Lancair 360 · Owensboro, KYThe loss of engine power due to fuel starvation. Contributing to the accident was the failure of the fuel selector valve cotter pin and the inoperative main (center) fuel tank gauge.Dec 29, 2008 · N360AS · Substantial damageNTSB ERA09CA112Accident · No injuriesData collectionFinal reportMichael Muratore Vans · Bayport, NYThe pilot's failure to stop the airplane within the available runway after touchdown. Contributing to the accident were the failure of the flap system as reported by the pilot and the damp grass.Dec 29, 2008 · N307MM · Substantial damageNTSB ERA09CA129Accident · No injuriesData collectionFinal reportBuckeye Dream Machine · Grant, FLThe pilot's failure to maintain clearance from the wire.Dec 28, 2008 · N6068E · Substantial damageNTSB CEN09LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Santo Domingo Pueblo, NMA loss of engine power due a loss of oil pressure resulting in heat distress and mechanical failure of the engine. The reason for the loss of oil pressure was not determined.Dec 28, 2008 · N3064M · Substantial damageNTSB ANC09CA016Accident · No injuriesData collectionFinal reportCessna 172S · Girdwood, AKThe flight instructor's lack of action to correct a high and fast landing approach which resulted in a long landing, and subsequent collision with a snow berm at the end of the runway. Contributing to the accident was the student pilot's improper approach.Dec 28, 2008 · N453SP · Substantial damageNTSB WPR09CA067Accident · No injuriesData collectionFinal reportCessna 208B · Rock Springs, WYThe pilot's failure to maintain control of the airplane while taxiing. Contributing to the accident were the gusty winds.Dec 27, 2008 · N890FE · Substantial damageNTSB CEN09CA104Accident · No injuriesData collectionFinal reportMooney M20C · Edgewood, NMA total loss of engine power while at cruise altitude for undetermined reasons.Dec 26, 2008 · N1216X · Substantial damageNTSB CEN09CA112Accident · No injuriesData collectionFinal reportCessna 140 · Highmore, SDThe pilot's failure to maintain directional control during the flare while landing in deep snow.Dec 24, 2008 · N89418 · Substantial damageNTSB CEN09CA102Accident · Serious injuriesData collectionFinal reportBeech 95-B55 · Batesville, ARThe pilot's improper decision to land with a tailwind which resulted in the overrun landing. Factors contributing to the accident include the culvert and the tailwind.Dec 24, 2008 · N8775R · Substantial damageNTSB CEN09LA114Accident · No injuriesLimited investigationFinal reportBoeing 747-212B · Rockford, ILThe ground crew's failure to maintain clearance from the light pole while directing the airplane to parking.Dec 23, 2008 · N486EV · Substantial damageNTSB CEN09LA100Accident · No injuriesLimited investigationFinal reportBeechcraft 390 · Lewistown, MOThe pilot's loss of directional control during landing on an ice-contaminated runway.Dec 23, 2008 · N20NL · Substantial damageNTSB WPR09CA066Accident · No injuriesData collectionFinal reportPiper PA-46-350P · Idaho Falls, IDThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident were the icy runway conditions and a snow bank.Dec 22, 2008 · N379P · Substantial damageNTSB ERA09LA282Accident · No injuriesLimited investigationFinal reportDassault/Sud FAN JET · Jamestown, NYThe inability to stop the airplane on the remaining runway because of icy runway conditions. A factor was the failure of the drag chute to properly deploy.Dec 21, 2008 · N165TW · Substantial damageNTSB ANC09CA014Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Willow, AKA partial loss of engine power during takeoff, which prevented the airplane from reaching takeoff airspeed, resulting in an aborted takeoff, and an on-ground collision with a tree.Dec 20, 2008 · N4131Z · Substantial damageNTSB ERA09LA098Accident · Minor injuriesLimited investigationFinal reportHess John L Spezio II · Newville, PAA loss of engine power due to carburetor ice as a result of the pilot's delayed use of carburetor heat.Dec 18, 2008 · N66JH · Substantial damageNTSB CEN09CA109Accident · No injuriesData collectionFinal reportPiper PA28 · Ely, MNThe pilot's failure to maintain directional control during landing. Contributing to the accident were the reduced left main landing gear wheel rotation for undetermined reasons and the snow-covered runway.Dec 17, 2008 · N845D · Substantial damageNTSB WPR09CA064Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Dinuba, CAThe failure of maintenance personnel to properly install the engine's Py line correctly, which resulted in the total loss of engine power and subsequent force landing. Contributing to the accident was the lack of suitable terrain.Dec 16, 2008 · N1035F · Substantial damageNTSB CEN09IA096Incident · No injuriesIncident investigationFinal reportCessna 182 · Fort Worth, TXCollision with a hidden obstruction while taxiing through a grass field following a forced landing. Contributing to the accident was a loss of engine power due to the pilot's failure to turn on the carburetor heat.Dec 12, 2008 · N5495B · Minor damageNTSB WPR09LA056Accident · 1 fatalLimited investigationFinal reportCessna 172 · Lompoc, CAThe pilot's failure to maintain clearance from the power line. Contributing to the accident was the pilot's lack of recent experience.Dec 10, 2008 · N6461E · Substantial damageNTSB ERA09CA086Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Linden, NJThe unknown pilot's failure to maintain adequate clearance from the taxiway sign.Dec 6, 2008 · N2125J · Substantial damageNTSB CEN09CA092Accident · No injuriesData collectionFinal reportCessna 150 · Auxvasse, MOthe pilot's improper engine recovery procedures after a power-off stall which resulted in a loss of engine power. Contributing factors were the pilot's improper off-field landing procedures, and the lack of suitable terrain for the forced landing.Dec 5, 2008 · N1521Q · Substantial damageNTSB CEN09LA093Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-50 · Madison, WIThe collision between the tug and the airplane during towing as a result of sliding on the snow covered runway.Dec 3, 2008 · N782NC · Substantial damageNTSB WPR09CA051Accident · No injuriesData collectionFinal reportBeech B60 · Rock River, WYThe pilot's failure to maintain clearance from a power line due to the lack of forward visibility because of an ice-covered windshield. Contributing to the accident was the flight's encounter with icing weather conditions.Nov 29, 2008 · N6693A · Substantial damageNTSB CEN09CA089Accident · No injuriesData collectionFinal reportCessna 182 · Gillespie, ILThe pilot's decision to take off with a known obstacle on the runway.Nov 28, 2008 · N44LL · Substantial damageNTSB WPR09LA048Accident · No injuriesLimited investigationFinal reportHughes 369HS · Fillmore, UTThe loss of engine power due to fuel starvation as a result of a loose fuel filter upper drain cap, which was not properly secured by maintenance personnel.Nov 25, 2008 · N9154F · Substantial damageNTSB WPR09CA045Accident · Minor injuriesData collectionFinal reportPiper PA-30 · Kona, HIThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control during the landing roll. Contributing factors were the delayed remedial action by the check pilot, the crosswind condition, and the rough uneven…Nov 24, 2008 · N8010Y · Substantial damageNTSB WPR09LA043Accident · 1 fatalLimited investigationFinal reportCessna 170B · Hanna, UTThe flight's encounter with adverse tailwinds and downdrafts in mountainous terrain that exceeded the airplane's climb capability.Nov 21, 2008 · N8387N · Substantial damageNTSB ERA09LA064Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Groton, CTThe student pilot’s failure to maintain a proper descent profile to avoid trees during the night visual approach and the flight instructor’s inadequate oversight.Nov 19, 2008 · N2337F · Substantial damageNTSB ERA09CA059Accident · No injuriesData collectionFinal reportMooney M20R · Indian Head, MDThe pilot's failure to maintain directional control while landing in gusting winds.Nov 16, 2008 · N4157 · Substantial damageNTSB CEN09LA061Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Downers Grove, ILThe pilot's failure to maintain a proper glidepath while on final approach in night conditions, due to his impairment from recent use of alcohol, cocaine, and over-the-counter and prescription medications.Nov 16, 2008 · N759HF · Substantial damageNTSB ERA09LA055Accident · Serious injuriesLimited investigationFinal reportAmerican General Acft AG5B · Naples, FLA partial loss of engine power during takeoff for undetermined reasons.Nov 14, 2008 · N1191W · Substantial damageNTSB ERA09CA054Accident · No injuriesData collectionFinal reportSnow 600 · Nashville, TNThe failure of the propeller shaft seal in flight. Contributing to the accident was the lack of suitable terrain for a forced landing.Nov 14, 2008 · N1691S · Substantial damageNTSB CEN09LA054Accident · 1 fatalLimited investigationFinal reportCessna 177RG · Mena, ARThe pilot's failure to maintain clearance from rising terrain. Contributing to the accident was the pilot's continued flight into deteriorating weather conditions.Nov 11, 2008 · N2526V · Substantial damageNTSB WPR09FA034Accident · 4 fatalField investigationFinal reportPiper PA-32S-300 · Forest Falls, CAThe pilot's continued flight into instrument meteorological conditions and subsequent impact with mountainous terrain.Nov 9, 2008 · N312AG · DestroyedNTSB CEN09LA055Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Nacogdoches, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Nov 8, 2008 · N8485R · Substantial damageNTSB ANC09CA010Accident · No injuriesData collectionFinal reportCessna 172M · Girdwood, AKThe pilot's decision to attempt to take off on a snow-covered runway. Contributing to the accident was the snow-covered runway.Nov 8, 2008 · N9099H · Substantial damageNTSB ERA09CA038Accident · No injuriesData collectionFinal reportBeech 35-C33 · Atlanta, GAThe pilot’s failure to maintain a proper glide path during the final approach, resulting in a collision with the airport approach lights.Nov 5, 2008 · N5891J · Substantial damageNTSB CEN09CA053Accident · No injuriesData collectionFinal reportCessna 172F · Hutchinson, MNThe bird that the airplane struck while on final approach.Nov 5, 2008 · N5556R · Substantial damageNTSB CEN09CA049Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Blaine, MNThe deer impacting the airplane during takeoff roll.Nov 4, 2008 · N558SR · Substantial damageNTSB WPR09LA028Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Powder River, WYA flight control system malfunction while the helicopter was maneuvering at low altitude due to the failure/separation of the rotor blade control tube.Oct 30, 2008 · N61436 · Substantial damageNTSB WPR09FA027Accident · 2 fatalField investigationFinal reportCessna P206 · Estacada, ORThe pilot's failure to maintain clearance from trees while on approach to land at night. Contributing to the accident was the electrical system failure and the pilot's diverted attention.Oct 29, 2008 · N2570X · Substantial damageNTSB CEN09FA043Accident · 1 fatalField investigationFinal reportCessna 175 · Mt. Dora, NMThe pilot's failure to maintain clearance from rising terrain for undetermined reasons.Oct 29, 2008 · N175JG · DestroyedNTSB CEN09LA039Accident · Minor injuriesLimited investigationFinal reportChamberlin Victor Wayne Minimax · Winnsboro, LAThe pilot’s failure to maintain clearance from static wires while maneuvering to avoid another airplane.Oct 27, 2008 · N8637L · Substantial damageNTSB WPR09LA025Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Rialto, CAA total loss of engine power during initial climb due to an interruption in fuel flow through an improperly assembled carburetor.Oct 26, 2008 · N44848 · Substantial damageNTSB CEN09CA037Accident · Serious injuriesData collectionFinal reportCessna R172E · Palo Pinto, TXThe pilot's intentional low-level flight and failure to maintain a visual lookout.Oct 26, 2008 · N42FG · DestroyedNTSB WPR09LA022Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Concrete, WAThe loss of engine power during initial climb due to the pilot's improper exhaust system maintenance, which resulted in restriction of the carburetor's air intake.Oct 23, 2008 · N97946 · Substantial damageNTSB ERA09LA025Accident · 1 fatalLimited investigationFinal reportMoses Tim C Quicksilver · Wingate, NCA loss of engine power due to a fractured crankshaft.Oct 21, 2008 · N184GT · Substantial damage