NTSB investigations, 2013
156 cases where NTSB found Object/animal/substance.
Cases per year
| 2008 | 319 |
|---|---|
| 2009 | 188 |
| 2010 | 164 |
| 2011 | 116 |
| 2012 | 132 |
| 2013 | 156 |
| 2014 | 233 |
| 2015 | 224 |
| 2016 | 279 |
| 2017 | 319 |
| 2018 | 315 |
| 2019 | 253 |
| 2020 | 158 |
| 2021 | 140 |
| 2022 | 126 |
| 2023 | 115 |
| 2024 | 115 |
| 2025 | 81 |
| 2026 | 43 |
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\", '030220'))
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", '030220')) 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 WPR14LA080Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Pacoima, CAThe flight instructor’s inadequate compensation for the gusting crosswind conditions during landing, which resulted in a loss of airplane control.NTSB WPR14CA097Accident · No injuriesData collectionFinal reportCameron Balloons US A-400 · Napa, CAFailure to maintain clearance from obstacles during a descent that resulted in an inadvertent collision with a pole.NTSB CEN14CA095Accident · No injuriesData collectionFinal reportCessna 182N · Paradis, LAThe collision with a bird which resulted in substantial damage to the airplane.NTSB WPR14FA078Accident · 2 fatalField investigationFinal reportCessna 172K · Fresno, CAThe pilot’s failure to maintain adequate clearance from trees while on approach, which subsequently led to a loss of airplane control. Also causal was the pilot’s continued operation of the airplane at night with a diagnosed medical condition that degraded…NTSB WPR14CA075Accident · Serious injuriesData collectionFinal reportCessna 152 · St. Ignatius, MTThe non-certificated pilot's failure to maintain a stabilized approach for landing that resulted in a long landing and subsequent runway overrun.NTSB ENG14IA005Incident · No injuriesIncident investigationFinal reportBoeing 737 3H4 · St. Louis, MOThe initial damage to the fan blades was caused by the ingestion of two mallard ducks that caused one or more fan blades to fracture, striking the fan shroud, as well as other passing fan blades, producing various sized blades fragments that created a…NTSB WPR14CA070Accident · No injuriesData collectionFinal reportBellanca 7ECA · San Jose, CAThe flight instructor's failure to correct for the student pilot's loss of aircraft control in a timely manner during takeoff. Contributing to the accident was the instructor's inability to see the taxiway sign from the rear seat.NTSB CEN14CA088Accident · No injuriesData collectionFinal reportPiper PA 28R-200 · Bowling Green, OHA bird strike during takeoff.NTSB WPR14LA065Accident · No injuriesLimited investigationFinal reportAviat S 2C · Chandler, AZThe pilot’s failure to maintain airplane control during landing, which resulted in impact with a runway identifier sign, and the flight instructor’s delayed remedial action to take the controls and initiate a go-around.NTSB WPR14CA063Accident · No injuriesData collectionFinal reportBurkhart Grob G 103 Twin II · Bryon, CAThe pilot's failure to maintain adequate wing clearance from a runway sign while taxiing.NTSB ANC14CA010Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Soldotna, AKThe operation of the airplane by the uncertificated student pilot, his failure to recognize conditions conducive to structural icing, and subsequent decision to depart in conditions conducive to structural icing, resulting in a severe icing encounter and…NTSB ERA14CA061Accident · Minor injuriesData collectionFinal reportAero Commander 680E · Crescent City, FLThe pilot's failure to maintain directional control during takeoff.NTSB WPR14CA060Accident · No injuriesData collectionFinal reportBeech G35 · Placerville, CAThe airplane's collision with a deer on the runway during landing.NTSB ERA14LA057Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Elkmont, ALA stuck exhaust valve, which resulted in a total loss of engine power at low altitude. Contributing to the accident were the pilot’s decision to fly at a low altitude, which reduced his forced landing options when the loss of engine power occurred; and poor…NTSB WPR14CA058Accident · No injuriesData collectionFinal reportQuad City Ultralight Acft Challenger II · Kalispell, MTA loss of engine power due to the spark plug coming out of the cylinder head.NTSB DCA14CA031Accident · No injuriesData collectionFinal reportDe Havilland DHC8 - 102 · Philadelphia, PAan inadvertent encounter with several birds during approach that resulted in substantial damage to the airplane.NTSB CEN14CA070Accident · No injuriesData collectionFinal reportCessna 172 · New Orleans, LAThe pilot's failure to maintain aircraft control after starting the engine, which resulted in a collision with a building.NTSB CEN14CA063Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Burwell, NEAn inadvertent collision with a deer during landing.NTSB WPR14CA053Accident · No injuriesData collectionFinal reportCessna 152 · Livermore, CAThe student pilot's failure to maintain directional control during the landing roll.NTSB WPR14CA047Accident · Minor injuriesData collectionFinal reportAviat A 1B · LaGrange, WYThe pilot's decision to land on a rough surface with hidden obstructions (holes).NTSB ERA14CA040Accident · No injuriesData collectionFinal reportBeech E 55 · Blountville, TNThe pilot's delayed reaction and loss of directional control while performing a simulated engine failure during the takeoff roll. A factor in the accident was the CFI's delayed reaction to the loss of directional control.NTSB ERA14CA039Accident · No injuriesData collectionFinal reportTaylorcraft BC 65 · Fallston, MDThe pilot's failure to maintain directional control during landing resulting in collision with equipment off the side of the runway. Contributing to the accident was the pilot's intentional landing on a closed runway with a tailwind.NTSB WPR14CA052Accident · Serious injuriesData collectionFinal reportBell 206B · Milo, ORThe pilot's failure to see and avoid wires while maneuvering at a low-altitude, which resulted in the main rotor blades striking the wires.NTSB WPR14LA036Accident · No injuriesLimited investigationFinal reportCessna T210M · Scipio, UTA total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA14CA032Accident · No injuriesData collectionFinal reportBeech V35B · Palm Coast, FLAn inadvertent collision with a black vulture.NTSB ERA14CA009Accident · Minor injuriesData collectionFinal reportEurocopter AS 350 B2 · Madison, MSThe helicopter's collision with a black vulture during climb to cruise altitude.NTSB WPR14CA021Accident · No injuriesData collectionFinal reportPiper PA28 - 160 · Tucson, AZThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion and collison with a runway sign.NTSB WPR14CA019Accident · No injuriesData collectionFinal reportRobinson R44 - II · Sedro Woolley, WAThe non-instrument rated pilot's inadvertent encounter with instrument meteorological conditions during initial climb and his improper decision to continue flight, which resulted in an in-flight impact with a tree and an emergency descent that resulted in a…NTSB ERA14CA001Accident · No injuriesData collectionFinal reportCessna 172P · Christmas, FLAn inflight collision with a bird during cruise flight.NTSB WPR14CA016Accident · No injuriesData collectionFinal reportChampion 7ECA · Willows, CAThe pilot's failure to maintain sufficient altitude while flying low over a field which resulted in a loss of aircraft control and collision with terrain.NTSB CEN14LA053Accident · No injuriesLimited investigationFinal reportCessna 525A · Lincoln, NEThe airplane’s encounter with a flock of American White Pelicans, which resulted in one bird striking the right outboard wing during en route climb from the departure airport.NTSB CEN14LA007Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US V 77 · Rio Rancho, NMThe pilot's failure to maintain adequate clearance from power lines on approach to land, resulting in a collision with the wires, a spark, and a subsequent explosion and on-board fire.NTSB CEN14CA026Accident · No injuriesData collectionFinal reportCessna 310R · Onaway, MIAn inadvertent collision with a deer during landing.NTSB WPR14LA008Accident · 1 fatalLimited investigationFinal reportMcdonnell Douglas Heli 369 · Paducah, TXThe pilot’s failure to maintain clearance from a power transmission line tower while maneuvering to pick up a rope in gusting wind conditions.NTSB ERA14LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172 - F · Gainesville, FLA total loss of engine power for reasons that could not be determined because a postaccident engine examination and test run revealed no anomalies.NTSB WPR14LA005Accident · 4 fatalLimited investigationFinal reportCessna 340A · Paulden, AZThe pilot’s failure to maintain sufficient altitude to clear a radio tower while maneuvering at low altitude and his decision to make a high-speed, low pass over the gun club.NTSB WPR13FA430Accident · 4 fatalField investigationFinal reportCessna 525A · Santa Monica, CAThe pilot’s failure to adequately decrease the airplane’s ground speed or maintain directional control during the landing roll, which resulted in a runway excursion and collision with an airport sign and structure and a subsequent postcrash fire.NTSB ERA13CA435Accident · Minor injuriesData collectionFinal reportAeronca 65 CA · Thomaston, GAThe pilot's inadequate pre-flight planning and in-flight monitoring of the fuel level which resulted in a total loss of engine power due to fuel exhaustion.NTSB ANC13CA107Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Wasilla, AKThe pilot's improper preflight inspection, and failure to remove heavy frost from the airplane prior to attempting a takeoff.NTSB WPR13LA429Accident · Minor injuriesLimited investigationFinal reportTexas Helicopter OH-13E/M74 · Santa Maria, CAThe pilot's inadequate monitoring of the environment and failure to maintain clearance from transmission wires during a low-altitude maneuver.NTSB WPR13CA428Accident · Minor injuriesData collectionFinal reportCessna 182Q · Big Bear, CAThe pilot's failure to maintain a stabilized landing approach, which resulted in a collision with a fence short of the runway.NTSB WPR13CA427Accident · No injuriesData collectionFinal reportAviat A-1C-200 · Dell, MTThe pilot's failure to maintain directional control while taxiing in gusting wind conditions.NTSB WPR13LA420Accident · 1 fatalLimited investigationFinal reportMiller RV6 · Williams, CAThe pilot's improper decision to fly at a low altitude, which resulted in his failure to maintain clearance from power lines.NTSB WPR13LA419Accident · No injuriesLimited investigationFinal reportPiper PA60 602P · Sandpoint, IDThe pilot's failure to fly the approach at the appropriate landing speed and attain the correct touchdown point, which resulted in a runway overrun.NTSB WPR13CA426Accident · No injuriesData collectionFinal reportPiper PA28 - 161 · Lancaster, CAThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB ERA13CA425Accident · No injuriesData collectionFinal reportLennox Kenneth J Zodiac 601HDS · Salisbury, MDThe pilot's inadequate compensation for the wind conditions while landing.NTSB ERA13CA423Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · Ridgely, MDThe flight instructor's failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall and collision with terrain.NTSB WPR13LA407Accident · No injuriesLimited investigationFinal reportMooney M20J · Lund, NVThe pilot’s failure to monitor the environment, which led to a collision with power lines during climbout. Contributing to the accident was the loss of engine power during low-altitude flight for reasons that could not be determined because postaccident…NTSB ERA13CA417Accident · Serious injuriesData collectionFinal reportMiller/Culpepper Christen Eagle II · Blythe, GAThe pilot's failure to maintain aircraft control during takeoff which resulted in a stall and collision with terrain.NTSB CEN13CA550Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Princeton, MNAn in-flight collision with a bald eagle.