NTSB investigations, 2013
274 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\") = 2013
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") = 2013 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 CEN14CA096Accident · Minor injuriesData collectionFinal reportCessna 172K · Concordia, KSThe pilot's failure to maintain a proper glidepath during approach which resulted in the airplane landing long, and his decision to turn off of the runway during the landing roll which resulted in a collision with an earth berm.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 WPR14CA082Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Roberts, MTThe pilot's selection of unsuitable terrain during taxi, which resulted in a loss of directional control.NTSB CEN14CA095Accident · No injuriesData collectionFinal reportCessna 182N · Paradis, LAThe collision with a bird which resulted in substantial damage to the airplane.NTSB WPR14LA079Accident · No injuriesLimited investigationFinal reportStinson 108 1 · Lodi, CAThe fatigue failure of the crankshaft, which resulted in a total loss of engine power and subsequent forced landing.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 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 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 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 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 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 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 ANC14CA005Accident · No injuriesData collectionFinal reportCessna 172 · Juneau, AKThe pilot's decision to land on an unsuitable surface, which resulted in a nose over.NTSB WPR14CA048Accident · No injuriesData collectionFinal reportMaule MX 7-235 · San Ynez, CAThe pilot's failure to maintain terrain clearance while maneuvering at low altitude in hilly terrain.NTSB ERA14LA042Accident · No injuriesLimited investigationFinal reportPiper PA28 · Homestead, FLA total loss of engine power due to the in-flight separation of the No. 3 cylinder because of the fatigue cracking of its respective mounting studs and through bolts, which resulted from inadequate maintenance by unknown personnel.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 CEN14LA022Accident · No injuriesLimited investigationFinal reportBell OH-58C · Omaha, TXThe pilot’s failure to assess and compensate for the landing surface, which included high grass and loose dirt.NTSB CEN14LA015Accident · 2 fatalLimited investigationFinal reportNorth American P 51D · Galveston, TXThe pilot's loss of situational awareness while instructing the passenger, which resulted in the controlled flight of the airplane into the water.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 WPR14CA033Accident · No injuriesData collectionFinal reportTecnam P92 · Watsonville, CAThe pilot's failure to maintain directional control during landing.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 WPR14CA020Accident · No injuriesData collectionFinal reportL Goldner Zenith 701 · Milford, UTThe pilot's improper decision to execute a precautionary landing to unsuitable terrain.NTSB WPR14CA018Accident · No injuriesData collectionFinal reportPiper PA 28R-201 · Las Vegas, NVThe collapse of a main landing gear for reasons that could not be determined due to no postaccident examination of the airframe.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 WPR14CA015Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Rio Verde, AZThe pilot's failure to maintain directional control during the takeoff roll on a rough and rutted surface.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 WPR14CA013Accident · Serious injuriesData collectionFinal reportPiper PA 28-180 · Cody, WYA loss of engine power during climb to cruise for reasons that could not be determined due to no postaccident examination.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.