NTSB investigations, 2018
208 cases where the sequence of events included Attempted remediation/recovery.
Cases per year
| 2008 | 22 |
|---|---|
| 2009 | 36 |
| 2010 | 33 |
| 2011 | 24 |
| 2012 | 41 |
| 2013 | 41 |
| 2014 | 36 |
| 2015 | 88 |
| 2016 | 115 |
| 2017 | 163 |
| 2018 | 208 |
| 2019 | 148 |
| 2020 | 89 |
| 2021 | 49 |
| 2022 | 61 |
| 2023 | 71 |
| 2024 | 89 |
| 2025 | 67 |
| 2026 | 48 |
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '060' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '060' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 GAA19CA106Accident · No injuriesData collectionFinal reportCessna 172 · Caldwell, NJThe student pilot's failure to maintain directional control during the takeoff roll.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 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 CEN19LA061Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Norwood, COThe partial loss of engine power for undetermined reasons.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 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 GAA19CA101Accident · No injuriesData collectionFinal reportClifford E Massey AR-1 · Anahuac, TXThe pilot's improper landing flare in gusting crosswind conditions.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 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 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 GAA19CA080Accident · No injuriesData collectionFinal reportPiper PA 12 · Burlington, WAThe pilot's failure to maintain directional control while landing in crosswind conditions.NTSB GAA19CA085Accident · Minor injuriesData collectionFinal reportCessna 172 · St. Petersburg, FLThe pilot's failure to remove the gust lock before flight, which resulted in the airplane’s inability to rotate and a subsequent runway overrun. Contributing to the accident was the pilot’s failure to follow the preflight checklist.NTSB GAA19CA083Accident · No injuriesData collectionFinal reportSmith AEROSTAR601 · Rock Hill, SCThe pilot's improper decision to fly with an air cast boot on his foot, which led him to rely on the passenger to apply brakes and rudder, which was performed improperly and led to a loss of directional control.NTSB GAA19CA072Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Benson, AZThe pilot's overcorrection during the landing, which resulted in a loss of directional control.NTSB GAA19CA076Accident · No injuriesData collectionFinal reportCessna 172 · Ogden, UTThe student pilot's improper landing flare, which resulted in a bounced landing.NTSB GAA19CA077Accident · No injuriesData collectionFinal reportScott Taylor Eclipse 10 · Kanab, UTThe pilot's failure to maintain directional control during takeoff from an unimproved dirt road.NTSB GAA19CA067Accident · No injuriesData collectionFinal reportJabiru J230-SP · Center, TXThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB GAA19CA069Accident · No injuriesData collectionFinal reportPiper PA32R · Versailles, OHThe pilot's improper landing flare, which resulted in landing on the landing gear first and a subsequent loss of directional control, a runway excursion, and impact with a tree and a fence during an attempted go-around.NTSB ERA19LA050Accident · Minor injuriesClass 3 · LimitedFinal reportUltralite Sro Stingsport · Clermont, FLAn inflight failure of the airplane’s horizontal stabilizer.NTSB ERA19TA051Accident · Minor injuriesFinal reportCessna E162 · Franklin, NCThe pilot's delay in applying carburetor heat, which resulted in a total loss of engine power during descent due to carburetor icing.NTSB GAA19CA060Accident · Minor injuriesData collectionFinal reportBeech 36 · Williams, AZThe pilot's failure to attain a sufficient climb rate during initial climb in high-density altitude conditions with the airplane near its forward center of gravity and maximum gross weight limits, which resulted in an impact with trees.NTSB GAA19CA059Accident · No injuriesData collectionFinal reportEugene Wells Dragon Fly-B · Kailua/Kona, HIThe pilot's failure to maintain directional control during landing in a crosswind. Contributing to the accident was the pilot’s lack of experience in tailwheel airplanes for which he did not have an endorsement.NTSB GAA19CA081Accident · No injuriesData collectionFinal reportCessna 172 · Inverness, FLThe pilot receiving instruction's failure to maintain directional control during landing.NTSB GAA19CA055Accident · No injuriesData collectionFinal reportCessna A185 · Reardan, WAThe pilot receiving instruction's improper approach and landing flare in crosswind conditions, which resulted in a bounced landing and subsequent loss of directional control. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB GAA19CA053Accident · Minor injuriesData collectionFinal reportPiper PA24 · Texico, NMThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB GAA19CA047Accident · No injuriesData collectionFinal reportPoberezny Acro Sport II · Culpeper, VAThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB GAA19CA061Accident · No injuriesData collectionFinal reportSocata TBM 700 · Corvallis, ORThe pilot's failure to maintain lateral control of the airplane during landing, which resulted in a wing strike.NTSB GAA19CA046Accident · No injuriesData collectionFinal reportBeech 55 · Gainesville, FLThe pilot's inadvertent landing gear retraction during the landing roll, which resulted in a canted left main landing gear and the wing dragging during the subsequent landing following a go-around.NTSB ERA19LA029Accident · No injuriesLimited investigationFinal reportDiamond DA20 · Mountain Rest, SCA partial loss of engine power due to multiple discrepancies of the engine's ignition system.NTSB GAA19CA044Accident · No injuriesData collectionFinal reportStoddard Hamilton Glasair II · Laramie, WYThe pilot's failure to maintain a proper pitch attitude during landing at night, which resulted in a porpoised landing.NTSB CEN19LA016Accident · No injuriesClass 3 · LimitedFinal reportRotorway 162 · Passaic, MOThe electrical short in the main rotor rpm indicating unit which provided an inaccurate indication to the student pilot and resulted in substantial damage during the precautionary autorotation.NTSB CEN19LA015Accident · No injuriesLimited investigationFinal reportCessna 172 · Houston, TXThe pilot's failure to apply carburetor heat while operating in an area conducive to carburetor icing, which resulted in a total loss of engine power on approach and subsequent forced landing into a creek.NTSB GAA19CA042Accident · No injuriesData collectionFinal reportCessna 172 · Salina, KSThe student pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB ERA19LA024Accident · Minor injuriesLimited investigationFinal reportBeech 35 · State College, PAThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN19LA013Accident · No injuriesLimited investigationFinal reportSorrell Sorrell SNS 7 · Middletown, OHThe pilot's loss of directional control during the landing rollout for reasons that could not be determined based on the available evidence, which resulted in the right wing striking the ground.NTSB GAA19CA037Accident · No injuriesData collectionFinal reportZenith CH601 · Junction City, KSThe pilot's failure to secure the canopy latch before takeoff, which resulted in the canopy opening in flight and the subsequent loss of airplane control.NTSB GAA19CA050Accident · No injuriesData collectionFinal reportPiper PA28 · East Moriches, NYThe pilot’s delayed initiation of a go-around and his subsequent use of the improper go-around procedure, which resulted in a landing area overshoot.NTSB ERA19LA022Accident · No injuriesLimited investigationFinal reportPiper PA22 · Brownstown, INThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation. Contributing to the outcome was the student…NTSB GAA19CA032Accident · No injuriesData collectionFinal reportPiper PA24 · Madras, ORThe pilot’s failure to extend the landing gear, which resulted in an attempted go-around and subsequent pitchdown and impact with the runway.NTSB GAA19CA029Accident · No injuriesData collectionFinal reportCapital Holdings 226 CCX-2000 · Dahlonga, GAThe pilot's improper landing flare, which resulted in a bounced landing and his subsequent failure to maintain directional control. Also causal to the accident was the pilot’s failure to retract the flaps during the aborted landing, which resulted in the…NTSB GAA19CA026Accident · No injuriesData collectionFinal reportCessna 140 · Denver, COThe pilot’s inadvertent brake application, which resulted in a loss of directional control and a subsequent nose-over.NTSB GAA19CA027Accident · No injuriesData collectionFinal reportPiper J3C · Camas, WAThe student pilot’s failure to maintain directional control during the landing roll.NTSB ERA19TA011Accident · No injuriesFinal reportBeech F33 · Reidsville, GAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a taxiway sign.NTSB ANC19CA003Accident · No injuriesData collectionFinal reportCessna 207 · Anchorage, AKThe pilot's inadequate in-flight fuel management, which resulted in fuel starvation and the subsequent loss of engine power, and her subsequent failure to maintain clearance from trees during the approach to land at a nearby airstrip.NTSB GAA19CA012Accident · No injuriesData collectionFinal reportBearden Biplane Sopwith Camel · Bolivar, MOThe pilot's failure to maintain directional control during landing.NTSB GAA19CA009Accident · No injuriesData collectionFinal reportStearman A75N1(PT17) · New Orleans, LAThe pilot’s failure to maintain directional control during a crosswind landing.NTSB GAA19CA007Accident · No injuriesData collectionFinal reportMaule M7 · Medford, ORThe pilot’s failure to maintain directional control during landing.NTSB GAA19CA006Accident · No injuriesData collectionFinal reportZenair CH 2000 · Topeka, KSThe pilot's improper landing flare, which resulted in a hard, bounced landing and a subsequent runway excursion.NTSB GAA19CA014Accident · No injuriesData collectionFinal reportCessna 172 · Stockton, CAThe student pilot's failure to maintain directional control during takeoff.