NTSB investigations, 2008
121 cases where NTSB found Runway/land/takeoff/taxi surface.
Cases per year
| 2008 | 121 |
|---|---|
| 2009 | 52 |
| 2010 | 51 |
| 2011 | 51 |
| 2012 | 47 |
| 2013 | 40 |
| 2014 | 50 |
| 2015 | 29 |
| 2016 | 74 |
| 2017 | 64 |
| 2018 | 43 |
| 2019 | 67 |
| 2020 | 50 |
| 2021 | 34 |
| 2022 | 34 |
| 2023 | 31 |
| 2024 | 28 |
| 2025 | 19 |
| 2026 | 14 |
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\", '030230'))
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", '030230')) 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 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 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 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 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 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 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 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 ANC09CA006Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Skwentna, AKThe pilot's selection of unsuitable terrain for landing.NTSB ERA09LA020Accident · No injuriesLimited investigationFinal reportSikorsky S-76C · New York, NYThe failure of the flightcrew to stabilize the helicopter over its confined landing area during a hovering left-pedal turn, resulting in tail rotor blade contact with a perimeter fence component and a subsequent loss of directional control. Contributing to…NTSB CEN09CA029Accident · No injuriesData collectionFinal reportCessna 172 · Van Wert, OHThe pilot's failure to maintain directional control of the airplane while taxiing on the wet grass.NTSB ERA09CA010Accident · No injuriesData collectionFinal reportCessna 172 · Naples, METhe pilot's failure to maintain directional control of the airplane during takeoff. Contributing to the accident was the wet condition of the grass runway.NTSB NYC08LA323Accident · No injuriesLimited investigationFinal reportBeech A200 · Bridgewater, VAThe pilot's decision to land with a tailwind on a short, wet runway, resulting in landing long and runway overrun. Contributing to the accident was the operator’s lack of standard operating procedures for test flights.NTSB ANC08CA128Accident · No injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot's selection of an unsuitable takeoff area. A Factor contributing to the accident was a short, rough and uneven takeoff site.NTSB ANC08CA123Accident · No injuriesData collectionFinal reportCessna 207 · Dillingham, AKThe pilot's inadequate evaluation of weather and runway conditions, and his improper decision to depart downwind, on a wet gravel runway, resulting in an in-flight collision with terrain after takeoff. Factors contributing to the accident were a tailwind, and…NTSB SEA08CA197Accident · No injuriesData collectionFinal reportCessna A185F · Lakeview, ORThe pilot's failure to maintain directional control. A contributing factor was the rough terrain.NTSB ANC08CA132Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Palmer, AKThe pilot's selection of unsuitable terrain for landing.NTSB ANC08CA115Accident · No injuriesData collectionFinal reportPiper PA-22 · Fairbanks, AKThe pilot's selection of an unsuitable landing site, resulting in a main landing gear collapse during the landing roll.NTSB ANC08CA116Accident · No injuriesData collectionFinal reportde Havilland DHC-2 · Talkeetna, AKThe pilot's selection of an unsuitable takeoff site, resulting in an on ground collision with tall brush.NTSB NYC08CA297Accident · No injuriesData collectionFinal reportErcoupe 415-C · Sebring, FLA bird strike which substantially damaged the propeller and required the engine to be secured. Contributing to the accident was the damaged propeller.NTSB ANC08LA111Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Kongiganak, AKThe pilot's decision to attempt to takeoff on a short, wet runway with a heavily loaded airplane, and his failure to abort the takeoff before it became impracticable.NTSB DFW08CA216Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Wisner, LAThe loss of engine power for undetermined reasons.NTSB LAX08LA281Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Groveland, CAThe pilot's failure to ensure that the landing gear was retracted prior to the water landing.NTSB CHI08CA260Accident · No injuriesData collectionFinal reportCessna A188B · Camanche, IAThe pilot took off on an unsuitable airstrip which resulted in the airplane becoming prematurely airborne with inadequate airspeed after it contacted a rise in the terrain.NTSB LAX08LA269Accident · No injuriesLimited investigationFinal reportCessna TU206F · Glendale, AZA loose fuel line fitting that resulted in a partial loss of engine power during the initial takeoff climb. Contributing to the accident was inadequate maintenance installation of the fitting.NTSB SEA08CA189Accident · No injuriesData collectionFinal reportAeros Venture · Maricopa, AZThe pilot's selection of unsuitable terrain for a precautionary landing and subsequent takeoff attempt, and his misjudging of the required takeoff distance. The soft terrain was a factor.NTSB CHI08CA213Accident · No injuriesData collectionFinal reportAir Tractor AT-401 · Ida Grove, IAA failure of the turbocharger blower which resulted in the partial loss of power. Factors associated with the accident were the low altitude of the airplane and the embankment.NTSB NYC08CA275Accident · Serious injuriesData collectionFinal reportI.C.A.-Brasov IS-26B2 · Fincastle, VAThe pilot's geographic disorientation, which resulted in an off-airport landing. Contributing to the accident was the pilot's selection of an inadequate landing site.NTSB CHI08CA250Accident · No injuriesData collectionFinal reportPiper J-3 · North Branch, MNThe loss of engine power as a result of oil starvation to the number one rod bearing and number one connecting rod. Contributing to the accident was the rough terrain.NTSB CHI08CA246Accident · No injuriesData collectionFinal reportAir Tractor AT-802A · Turton, SDThe failure of the starter generator which resulted in the subsequent loss of engine power. Contributing to the accident were the low altitude at which the airplane was operating, the tall grass, and the ditch.NTSB LAX08CA262Accident · Minor injuriesData collectionFinal reportLet Blanik L-13 · Bend, ORThe pilot's misjudged distance/altitude which resulted in an undershoot while on final approach to land. Factors contributing to the accident were the lack of thermal lift (sinking air), and the lack of suitable terrain for the off-airport landing.NTSB ANC08CA109Accident · No injuriesData collectionFinal reportPiper PA-20/22 · Talkeetna, AKThe pilot's failure to maintain clearance from brush during the landing roll.NTSB ANC08LA101Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKThe pilot's excessive speed and excessive application of brakes during the landing roll on soft, sandy terrain.NTSB CHI08CA231Accident · No injuriesData collectionFinal reportWeatherly 201B · Creston, ILThe pilot's selection of the unsuitable terrain next to the runway to avoid the landing traffic. Contributing to the accident was the hill in the middle of the runway that blocked the pilot's view of the other traffic and the high vegetation near the runway.NTSB CHI08CA227Accident · No injuriesData collectionFinal reportHead Balloons AX9-118 · Cook, MNThe pilot's decision to land in a confined area. Contributing to the accident were the hidden power transmission lines and the confined landing site.NTSB LAX08CA248Accident · No injuriesData collectionFinal reportBristol Titan Tornado II · Green River, UTThe encounter with rough terrain during an off-field precautionary landing.NTSB CHI08CA217Accident · No injuriesData collectionFinal reportGrumman G-164A · Veedersburg, INThe oil filler cap not reinstalled by the pilot prior to the aerial application flight and the total loss of engine oil during an aerial application. Additional causes were the low altitude of the operation and the unsuitable terrain encountered by the pilot…NTSB CHI08LA214Accident · Minor injuriesLimited investigationFinal reportBolenbaugh Phillip William Rans S-6ES · Oshkosh, WIThe pilot's improper landing flare, which resulted in a hard landing and subsequent collapse of the nose landing gear.NTSB CHI08CA203Accident · No injuriesData collectionFinal reportEnstrom F28F · Amberg, WIThe unsuitable terrain encountered by the pilot during a forced landing following a loss of engine power due to a cylinder head separation. Contributing to the accident was the tree.NTSB ANC08LA088Accident · No injuriesLimited investigationFinal reportCessna 150 · Manley Hot Spgs, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a collision with a ditch during the takeoff roll. Factors contributing to the accident were low light conditions at dusk, and soft terrain.NTSB CHI08CA184Accident · No injuriesData collectionFinal reportHuebner RV6-A · Jerseyville, ILThe muddy, unsuitable terrain encountered during the landing.NTSB ANC08CA086Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Pilot Point, AKThe pilot's selection of unsuitable terrain for takeoff.NTSB SEA08LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · East Carbon, UTThe pilot's inadequate in-flight planning and decision to continue flight into a canyon area with questionable aircraft performance. Contributing to the accident was the lack of suitable terrain for the precautionary landing and a high density altitude…NTSB LAX08CA215Accident · Minor injuriesData collectionFinal reportCessna 150J · Seal Beach, CAFuel starvation due to the pilot's improper fuel management procedures and failure to select a tank containing fuel. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB CHI08CA183Accident · No injuriesData collectionFinal reportChallenger II · Williamsfield, ILThe loss of engine power for undertermined reasons and the unsuitable landing area encountered during the forced landing. Contributing to the accident were the trees and the residence.NTSB CHI08CA188Accident · No injuriesData collectionFinal reportCessna 177A · Rhinelander, WIThe loss of engine power for an undetermined reason. A factor was the berm encountered during the forced landing.NTSB SEA08LA155Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Oakland, CAA loss of engine power due to oil starvation. The oil starvation event was due to the failure of maintenance personnel to tighten the mounting bolts for the newly installed vacuum pump.NTSB ANC08CA084Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Anchorage, AKThe pilot's selection of an unsuitable landing area.NTSB ANC08CA080Accident · No injuriesData collectionFinal reportPiper PA-12 · Wasilla, AKThe pilot's selection of an unsuitable landing area.