NTSB investigations, 2013
40 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\") = 2013
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") = 2013 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 CEN14LA080Accident · No injuriesLimited investigationFinal reportPiper PA46 500TP · Albuquerque, NMThe pilot’s loss of directional control during landing due to his inadequate compensation for the tailwind.NTSB CEN14CA078Accident · No injuriesData collectionFinal reportCessna 152 · Columbia Station, OHThe pilot's inadequate flight planning and decision to land on the soft grass/turf runway which resulted in a nose over.NTSB CEN14LA076Accident · No injuriesLimited investigationFinal reportCessna T210L · Lake Providence, LAThe pilot's mismanagement of available fuel and incorrect use of the fuel boost pump which resulted in a total loss of engine power at a low altitude.NTSB ANC14CA009Accident · No injuriesData collectionFinal reportCessna A185F · Nenana, AKThe pilot's failure to maintain directional control of the airplane, which resulted in a collision with terrain.NTSB ANC14CA005Accident · No injuriesData collectionFinal reportCessna 172 · Juneau, AKThe pilot's decision to land on an unsuitable surface, which resulted in a nose over.NTSB WPR14CA047Accident · Minor injuriesData collectionFinal reportAviat A 1B · LaGrange, WYThe pilot's decision to land on a rough surface with hidden obstructions (holes).NTSB CEN14CA016Accident · No injuriesData collectionFinal reportAmerican Eurocopter AS350B3 · Eagle Pass, TXThe abnormal contact of the helicopter's skids with the landing surface, which resulted in a rollover.NTSB ANC14CA004Accident · No injuriesData collectionFinal reportPiper J3C 65 · Talkeetna, AKThe pilot's decision to make contact with an unsuitable landing surface, resulting in a nose over.NTSB WPR14CA009Accident · Serious injuriesData collectionFinal reportBeech A36 · Tilden, TXThe pilot's decision to continue the takeoff from a wet and soft airstrip which resulted in his failure to maintain adequate airspeed and aircraft control during the takeoff initial climb.NTSB ANC13CA105Accident · No injuriesData collectionFinal reportPiper PA 18 · Big Lake, AKThe pilot's selection of unsuitable terrain for landing, resulting in abnormal contact with terrain.NTSB ANC13CA104Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Delta Junction, AKThe pilot's inadequate takeoff planning and judgment that did not consider the reduced acceleration due to snow-covered terrain, which resulted in an aborted takeoff and collision with terrain.NTSB WPR13CA394Accident · No injuriesData collectionFinal reportHenderson Michael E Glastar · Sequim, WAThe pilot's improper soft field landing technique, and failure to maintain aircraft control during the landing.NTSB ERA13CA394Accident · No injuriesData collectionFinal reportHoskins Samuel R Quickie Q2 · Zelienople, PAThe pilot's loss of directional control during takeoff due to right main landing gear contact with a pool of standing water on the runway which resulted in a runway excursion.NTSB ERA13LA365Accident · No injuriesLimited investigationFinal reportFetterman Lanny R Firestar II · Numidia, PAA fatigue failure of the right main landing gear wheel axle attachment bracket, which resulted in a nose-over during a precautionary landing.NTSB ANC13LA079Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Paxson, AKThe partial loss of engine power due to a loose throttle cable clamp.NTSB CEN13CA453Accident · No injuriesData collectionFinal reportLuscombe 8A · Ellinwood, KSThe pilot failed to maintain directional control during takeoff.NTSB ANC13CA069Accident · No injuriesData collectionFinal reportCessna A185E · Kotzebue, AKThe pilot's lack of situational awareness and failure to maintain adequate clearance from terrain during takeoff. Factors contributing to the accident was the check airmen’s inadequate supervision.NTSB ANC13CA070Accident · No injuriesData collectionFinal reportPiper PA-18-135 · Fairbanks, AKThe pilot's inadequate evaluation of his landing area, which resulted in contact with terrain.NTSB CEN13CA386Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Climax Springs, MOThe pilot’s inadequate planning and poor decision to attempt to take off on a runway from which the airplane could not obtain flight.NTSB ERA13CA298Accident · No injuriesData collectionFinal reportBellanca 7KCAB · East Aurora, NYThe pilot's failure to maintain aircraft control during a rejected takeoff on a soft turf runway with a gusty wind, resulting in the airplane nosing over.NTSB WPR13CA271Accident · No injuriesData collectionFinal reportCessna T210N · Salmon, IDThe pilot's decision to land on a wet grass airstrip, which resulted in a main landing gear collapse after a collision with rough terrain.NTSB ERA13LA264Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1B · Williamson, SCThe pilot’s decision to takeoff with a quartering tailwind at high density altitude, close to gross takeoff weight, on a short turf runway with trees at the departure end.NTSB ANC13CA052Accident · No injuriesData collectionFinal reportCessna U206A · Fairbanks, AKThe pilot’s inadequate flare, which resulted in a nose-low impact with glassy water and a subsequent nose-over.NTSB ANC13CA053Accident · No injuriesData collectionFinal reportCessna U206G · King Salmon, AKThe pilot's inadequate airspeed control during a glassy water landing, which resulted in an excessive sink rate, and a hard landing.NTSB WPR13CA225Accident · No injuriesData collectionFinal reportCessna 172N · Newcastle, WYThe student pilot's failure to attain the proper touchdown point, which resulted in an undershoot of the runway.NTSB ERA13CA231Accident · No injuriesData collectionFinal reportCessna 182G · Arcadia, NYThe pilot's improper decision to continue a high approach with a tailwind, rather than perform a go-around, which resulted in an overrun on a wet, down-sloping, grassy runway.NTSB ERA13FA225Accident · 1 fatalField investigationFinal reportGrumman G-44 · Catskill, NYThe pilot’s misjudgment of the airplane’s altitude above the water and early flare for a landing on water with a glassy condition, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB CEN13CA251Accident · No injuriesData collectionFinal reportAlexander Duane A RV-8 · Cortland, OHThe pilot’s failure to maintain control of the airplane after encountering an unexpected soft spot in the runway during landing.NTSB ANC13CA039Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Seward, AKThe pilot’s decision to land on an unsuitable landing surface, which resulted in a nose over.NTSB ANC13CA046Accident · No injuriesData collectionFinal reportCessna U206G · Nenana, AKIce accretion in the right main landing gear wheel brake during departure, which prevented the right main landing gear from rotating on landing and resulted in a runway excursion and subsequent impact with a snow bank.NTSB ANC13CA037Accident · No injuriesData collectionFinal reportDehavilland DHC-2 MK. I(L20A) · Anchorage, AKThe pilot’s failure to maintain directional control of the airplane while taxiing on a snow-covered taxiway.NTSB ANC13CA034Accident · No injuriesData collectionFinal reportPiper PA-16 · Big Lake, AKThe pilot's decision to land on unsuitable terrain.NTSB ANC13LA032Accident · No injuriesLimited investigationFinal reportCessna A185F · Talkeetna, AKThe overstress fracture and failure of the right wheel/ski arm while taxiing in snow and water-overflow terrain conditions, which resulted in a noseover.NTSB ANC13CA031Accident · Minor injuriesData collectionFinal reportNelson Larry L WAG Aero 2+2 · Chickaloon, AKThe pilot's delayed decision to abort the landing.NTSB WPR13CA140Accident · Minor injuriesData collectionFinal reportWeston SEA-ERA · Bellevue, WAThe pilot’s failure to maintain control during takeoff on choppy water conditions.NTSB ANC13CA023Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Dutch Harbor, AKThe pilot's decision to land in wind conditions that exceeded the airplane's demonstrated crosswind capability, which resulted in a loss of airplane control during the landing roll.NTSB CEN13CA206Accident · No injuriesData collectionFinal reportCessna T206H · Sabinal, TXThe pilot’s failure to properly identify the airstrip, which resulted in him landing the airplane off of the airstrip in soft soil causing the nose over.NTSB CEN13CA161Accident · No injuriesData collectionFinal reportCessna 172M · Jenison, MIThe pilot's failure to maintain directional control while landing on an ice- and snow-covered runway in crosswind conditions.NTSB CEN13CA129Accident · No injuriesData collectionFinal reportBeech 65-B80 · Alexandria, MNThe pilot’s failure to stop the airplane on the downsloping, ice-contaminated runway after landing with a tailwind. Contributing to the accident was the pilot’s failure to account for the wind conditions and failure to obtain runway conditions.NTSB WPR13CA079Accident · No injuriesData collectionFinal reportCessna 182P · Chiloquin, ORThe flight instructor’s failure to maintain airplane control during a landing on a snow-covered runway.