NTSB investigations, 2008
604 cases where NTSB found Physical environment.
Cases per year
| 2008 | 604 |
|---|---|
| 2009 | 361 |
| 2010 | 303 |
| 2011 | 244 |
| 2012 | 265 |
| 2013 | 274 |
| 2014 | 379 |
| 2015 | 332 |
| 2016 | 421 |
| 2017 | 457 |
| 2018 | 431 |
| 2019 | 396 |
| 2020 | 251 |
| 2021 | 221 |
| 2022 | 198 |
| 2023 | 186 |
| 2024 | 172 |
| 2025 | 129 |
| 2026 | 73 |
Where
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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB 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.NTSB WPR09CA093Accident · No injuriesData collectionFinal reportStemme S-10 · San Jose, CAThe pilot's failure to maintain clearance from an obstacle during taxi.NTSB 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.NTSB 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.NTSB ERA09CA129Accident · No injuriesData collectionFinal reportBuckeye Dream Machine · Grant, FLThe pilot's failure to maintain clearance from the wire.NTSB 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.NTSB 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.NTSB 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.NTSB CEN09CA104Accident · No injuriesData collectionFinal reportMooney M20C · Edgewood, NMA total loss of engine power while at cruise altitude for undetermined reasons.NTSB CEN09CA112Accident · No injuriesData collectionFinal reportCessna 140 · Highmore, SDThe pilot's failure to maintain directional control during the flare while landing in deep snow.NTSB 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.NTSB 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.NTSB CEN09LA100Accident · No injuriesLimited investigationFinal reportBeechcraft 390 · Lewistown, MOThe pilot's loss of directional control during landing on an ice-contaminated runway.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ERA09CA086Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Linden, NJThe unknown pilot's failure to maintain adequate clearance from the taxiway sign.NTSB 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.NTSB 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.NTSB 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.NTSB CEN09CA089Accident · No injuriesData collectionFinal reportCessna 182 · Gillespie, ILThe pilot's decision to take off with a known obstacle on the runway.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB ERA09CA059Accident · No injuriesData collectionFinal reportMooney M20R · Indian Head, MDThe pilot's failure to maintain directional control while landing in gusting winds.NTSB 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.NTSB ERA09LA055Accident · Serious injuriesLimited investigationFinal reportAmerican General Acft AG5B · Naples, FLA partial loss of engine power during takeoff for undetermined reasons.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CEN09CA053Accident · No injuriesData collectionFinal reportCessna 172F · Hutchinson, MNThe bird that the airplane struck while on final approach.NTSB CEN09CA049Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Blaine, MNThe deer impacting the airplane during takeoff roll.NTSB 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.NTSB 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.NTSB CEN09FA043Accident · 1 fatalField investigationFinal reportCessna 175 · Mt. Dora, NMThe pilot's failure to maintain clearance from rising terrain for undetermined reasons.NTSB 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.NTSB 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.NTSB CEN09CA037Accident · Serious injuriesData collectionFinal reportCessna R172E · Palo Pinto, TXThe pilot's intentional low-level flight and failure to maintain a visual lookout.NTSB 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.NTSB ERA09LA025Accident · 1 fatalLimited investigationFinal reportMoses Tim C Quicksilver · Wingate, NCA loss of engine power due to a fractured crankshaft.