NTSB investigations, 2018
1,065 cases where NTSB found Aircraft.
Cases per year
| 1979 | 1 |
|---|---|
| 2008 | 1,297 |
| 2009 | 1,286 |
| 2010 | 1,161 |
| 2011 | 1,213 |
| 2012 | 1,206 |
| 2013 | 1,003 |
| 2014 | 1,047 |
| 2015 | 1,034 |
| 2016 | 1,075 |
| 2017 | 1,060 |
| 2018 | 1,065 |
| 2019 | 1,048 |
| 2020 | 921 |
| 2021 | 950 |
| 2022 | 1,010 |
| 2023 | 975 |
| 2024 | 933 |
| 2025 | 639 |
| 2026 | 294 |
Where
Open the mapLatest 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\") = 2018
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01'))
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") = 2018 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01')) 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 ERA19LA081Accident · No injuriesLimited investigationFinal reportCessna LC41 · Apopka, FLA partial loss of engine power during a go-around for reasons that could not be determined based on the available information, which resulted in a forced landing.NTSB CEN19LA051Accident · 1 fatalLimited investigationFinal reportPiper PA 23 · Beaver Island, MIThe pilot's failure to maintain a positive rate of climb after takeoff which resulted in an impact with trees and terrain. Contributing to the accident was the pilot's inability to see a visible horizon due to the dark night lighting conditions and limited…NTSB WPR19LA060Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · San Diego, CALoss of directional control during the landing roll for reasons that could not be determined based on the available information.NTSB GAA19CA106Accident · No injuriesData collectionFinal reportCessna 172 · Caldwell, NJThe student pilot's failure to maintain directional control during the takeoff roll.NTSB GAA19CA111Accident · Minor injuriesData collectionFinal reportCessna 180 · Bend, ORThe pilot's failure to maintain directional control in gusting crosswind conditions.NTSB CEN19LA064Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Horseshoe Bay, TXThe pilot's inadequate preflight and in-flight fuel planning, which resulted in the total loss of engine power due to fuel exhaustion.NTSB GAA19CA119Accident · No injuriesData collectionFinal reportCessna 172 · Sugar Land, TXThe student pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with a sign.NTSB ENG19IA008IncidentClass 3 · IncidentFinal reportAirbus A220 · Busan, South KoreaThe manufacturer’s inadequate cleaning of the crucible before melting the nickel alloy used in casting the low pressure turbine stage 3 blades that resulted in a casting anomaly from where an intergranular crack occurred became the origin of a fatigue crack…NTSB CEN19TA075Accident · Minor injuriesFinal reportMBB BK117 · Strum, WIThe pilot's failure to maintain clearance from the fire truck.NTSB CEN19LA049Accident · 2 fatalClass 2 · LimitedFinal reportBeech 58 · Sioux Falls, SDThe pilot's failure to maintain adequate airspeed during the instrument approach which led to an aerodynamic stall.NTSB CEN19LA048Accident · No injuriesClass 3 · LimitedFinal reportVans RV 6 · Watkins, COThe pilot’s failure to apply adequate torque to a fuel line during recent maintenance, which allowed the line to loosen in flight and fuel to enter the hot engine compartment and resulted in an in-flight fire that consumed the airplane.NTSB ERA19LA079Accident · No injuriesLimited investigationFinal reportCessna 172 · Fort Lauderdale, FLA total loss of engine power due to the fatigue fracture of the No. 2 exhaust rocker arm stud.NTSB WPR19LA050Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Santa Ana, CAA total loss of engine power due to a loose carburetor bowl.NTSB ERA19LA091Accident · Serious injuriesLimited investigationFinal reportCzech Sport Sportcruiser · Naples, FLCollision with a bird in flight, which resulted in damage to the engine, a fuel leak, and a subsequent total loss of engine power due to fuel exhaustion.NTSB ERA19LA078Accident · 1 fatalLimited investigationFinal reportBRM Aero Bristell S-LSA · Lakeland, FLThe student pilot's exceedance of the airplane's critical angle of attack during the initial climb, resulting in an aerodynamic stall from which the pilot did not recover.NTSB WPR19LA049Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft L 2M · Walla Walla, WAThe pilot's improper preflight planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA19CA129Accident · No injuriesData collectionFinal reportCessna 182 · Marshall, TXThe pilot's failure to maintain directional control during landing.NTSB CEN19LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Abilene, TXThe pilot's failure to see and avoid a cell tower wire during a pipeline patrol flight. Contributing to the accident was the pilot's distraction due to writing down observations about the pipeline while flying.NTSB GAA19CA123Accident · Minor injuriesData collectionFinal reportCessna 172 · Center, TXThe pilot's exceedance of the airplane's critical angle of attack during landing in gusting crosswind conditions, which resulted in an aerodynamic stall.NTSB ERA19LA072Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA46 · Mayport, FLAn in-flight loss of control following an encounter with supercooled large droplet icing conditions, which ultimately resulted in an uncontrolled descent and subsequent inflight breakup. Also causal was the pilot’s failure to maintain an appropriate airspeed…NTSB ERA19FA071Accident · 4 fatalField investigationFinal reportCessna 560 · Atlanta, GAThe pilot's loss of airplane control due to spatial disorientation during initial climb in instrument meteorological conditions.NTSB ERA19FA070Accident · 3 fatalField investigationFinal reportPiper PA28 · Blairsville, GAThe pilot's failure to maintain clearance from trees during a visual approach for landing in night visual meteorological conditions. Contributing to the accident was the pilot's lack of recent experience flying at night.NTSB GAA19CA102Accident · No injuriesData collectionFinal reportBeech 36 · Sedona, AZThe pilot's failure to maintain the proper airspeed during landing, which resulted in the airplane landing too fast and too far down the runway to safely stop it.NTSB ERA19LA074Accident · Minor injuriesClass 3 · LimitedFinal reportDiamond DA20 · McCormick, SCA partial loss of engine power due to debris obstructing the metering plug orifice in the throttle and metering unit.NTSB ERA19FA068Accident · 1 fatalClass 2 · FieldFinal reportSaberwing Saberwing · Adel, GAThe in-flight failure of the fuselage, as a result of the pilot conducting maneuvers that exceeded the structural capabilities of the airplane.NTSB WPR19FA042Accident · 1 fatalClass 2 · FieldFinal reportPiper PA-24-250 · Aberdeen, IDThe pilot's diverted attention during the takeoff climb due to a loss of engine power, which resulted in the airplane’s exceedance of the critical angle of attack and subsequent stall/spin.NTSB ERA19LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Bell Glade, FLA partial loss of engine power due to the No. 1 cylinder's valve keeper becoming dislodged, which ultimately resulted in the intake valve becoming stuck in the valve guide and in the loss of compression to the cylinder.NTSB GAA19CA098Accident · No injuriesData collectionFinal reportCessna 170 · Riggins, IDThe pilot's improper preflight performance planning and his subsequent failure to attain sufficient speed for the airplane to climb with a tailwind.NTSB CEN19LA047Accident · No injuriesLimited investigationFinal reportRans S12 · McClure, OHThe cold seizure of the cylinder/piston due to the pilot’s failure to adequately warm the engine before takeoff, which resulted in a loss of engine power during a departure climb.NTSB GAA19CA101Accident · No injuriesData collectionFinal reportClifford E Massey AR-1 · Anahuac, TXThe pilot's improper landing flare in gusting crosswind conditions.NTSB ERA19LA073Accident · No injuriesClass 3 · LimitedFinal reportLearjet 35 · Key West, FLThe flight crew’s encounter with windshear during the landing flare, which resulted in a hard landing.NTSB CEN19LA046Accident · No injuriesLimited investigationFinal reportCessna 120 · Beaumont, KSThe right brake being locked during the landing roll on the turf runway for reasons that could not be determined during postaccident examinations, which resulted in a noseover.NTSB CEN19LA045Accident · Serious injuriesLimited investigationFinal reportBrandt Sonex · Lodi, WIThe pilot's failure to maintain proper alignment with the runway during final approach, which resulted in impact with a tree.NTSB GAA19CA100Accident · No injuriesData collectionFinal reportCessna A185 · Tacoma, WAThe pilot's loss of directional control during the landing roll and his subsequent overapplication of left rudder, which resulted in the right wing impacting the runway.NTSB ERA19FA066Accident · 1 fatalField investigationFinal reportEipper Quicksilver · Fredericksburg, VAThe pilot's exceedance of the airplane's critical angle of attack, which led to an aerodynamic stall while turning in the traffic pattern at low altitude.NTSB ERA19LA065Accident · Minor injuriesClass 3 · LimitedFinal reportCzech Sport Piper Sport · Punta Gorda, FLA total loss of engine power due to an interruption of fuel flow.NTSB CEN19FA044Accident · 1 fatalField investigationFinal reportPiper PA24 · Valparaiso, INThe pilot's failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall and spin.NTSB GAA19CA096Accident · No injuriesData collectionFinal reportBeech 36 · Hartford, WIThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and impact with terrain during landing in icing conditions.NTSB GAA19CA095Accident · No injuriesData collectionFinal reportPiper PA28 · Chino, CAThe flight instructor's failure to maintain directional control during landing.NTSB ERA19LA062Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Paramus, NJMaintenance personnel's improper assembly of the engine during overhaul, which resulted in lubrication restriction due to a bearing shift and the subsequent engine failure.NTSB GAA19CA090Accident · Minor injuriesData collectionFinal reportZenair CH 750 Cruzer · Hesperia, CAThe pilot's improper landing flare, which resulted in hard, bounced landing, runway excursion, and impact with a hangar.NTSB ERA19LA061Accident · Serious injuriesClass 3 · LimitedFinal reportCessna P210 · Myerstown, PAA total loss of engine power due to fuel starvation.NTSB GAA19CA088Accident · No injuriesData collectionFinal reportPiper PA28 · Cornelia, GAThe flight instructor's failure to maintain the runway heading during an attempted takeoff in gusting crosswind conditions, which resulted in a collision with trees.NTSB ERA19LA063Accident · No injuriesClass 3 · LimitedFinal reportLancair LC41 · Moscow, PAA total loss of engine power and catastrophic engine failure due to the failure of the left turbocharger, which resulted in oil loss and oil starvation. Contributing to the accident was the failure of maintenance personnel to overhaul the turbocharger in…NTSB GAA19CA087Accident · No injuriesData collectionFinal reportCessna 172 · Monroe, NCThe student pilot's improper landing flare, which resulted in a hard, bounced landing and nose landing gear collapse.NTSB ERA19FA060Accident · 2 fatalClass 2 · FieldFinal reportCessna 335 · Fort Lauderdale, FLThe pilot's improper decision to fly the unairworthy airplane and his failure to feather the left propeller following a partial loss of power from the left engine after takeoff. Also causal was the partial loss of power to the left engine due to detonation.NTSB GAA19CA089Accident · No injuriesData collectionFinal reportPiper J4 · Forest, VAThe student pilot's improper landing flare and subsequent failure to maintain directional control during landing.NTSB ERA19FA059Accident · 1 fatalField investigationFinal reportCessna 210 · Apalachicola, FLThe pilot's controlled flight into terrain as a result of his spatial disorientation during departure in dark nighttime conditions.NTSB CEN19LA039Accident · Minor injuriesLimited investigationFinal reportCessna 550 · Fargo, NDThe pilot's failure to lower the flaps during the approach and maintain sufficient airspeed while flying in instrument meteorological and icing conditions and the accumulation of ice on the wings’ leading edges, which resulted in the exceedance of the…NTSB GAA19CA080Accident · No injuriesData collectionFinal reportPiper PA 12 · Burlington, WAThe pilot's failure to maintain directional control while landing in crosswind conditions.