NTSB investigations, 2019
148 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\") = 2019
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") = 2019 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 WPR20CA053Accident · No injuriesData collectionFinal reportCessna 170 · Missoula, MTThe pilot receiving instruction's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and ground-loop, and the flight instructor’s failure to adequately monitor the pilot.NTSB ERA20CA058Accident · Minor injuriesData collectionFinal reportCessna P210 · Gainesville, FLThe airplane's impact by a bird during the initial climb.NTSB CEN20CA039Accident · Minor injuriesData collectionFinal reportFlight Design Ctsw · Delaware, OHThe student pilot’s failure to maintain yaw control during takeoff, which resulted in an aborted takeoff and subsequent landing on grassy terrain, during which the airplane bounced and then nosed over.NTSB ANC20CA037Accident · No injuriesData collectionFinal reportCessna 207 · Kwigillingok, AKThe pilot's improper decision to depart from an ice-covered runway with a strong crosswind, which resulted in a loss of directional control, runway excursion, and impact with a ditch.NTSB WPR20CA041Accident · No injuriesData collectionFinal reportCessna 182 · Camas, WAThe student pilot's improper landing flare, which resulted in a bounced landing, and the flight instructor’s delayed remedial action and the student’s failure to relinquish control, which resulted in a runway overrun and impact with a fence.NTSB CEN20LA029Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8A · Baldwin City, KSThe pilot's failure to maintain directional control during takeoff, and the flight instructor's delayed remedial action, which resulted in a runway excursion and nose over.NTSB CEN20CA027Accident · No injuriesData collectionFinal reportSkystar Kitfox · Williamston, MIThe pilot's improper decision to continue taxiing the airplane on unsuitable terrain, which resulted in a nose-over.NTSB WPR20CA058Accident · No injuriesData collectionFinal reportAeronca 11AC · San Diego, CAThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind, which resulted in a collision with an airport sign and subsequent ground-loop.NTSB CEN20CA026Accident · No injuriesData collectionFinal reportBellanca 1730 · Clear Lake, MNThe pilot's focus inside the cockpit during the base turn and final approach, which led to a high sink rate developing and a subsequent hard landing short of the runway.NTSB WPR20LA024Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28R · Ogden, UTThe flight instructor’s failure to raise the landing gear using the alternate system, which resulted in a reduced climb rate and impact with an obstacle. Contributing to the accident was the flight instructor’s lack of understanding of the backup landing gear…NTSB GAA20CA069Accident · No injuriesData collectionFinal reportCessna 180 · Tyler, TXThe pilot's improper wind correction while taking off with a tailwind, which resulted in a runway excursion and subsequent nose-over.NTSB ERA20TA030Accident · No injuriesClass 3Final reportBeech 76 · Doral, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of power to both engines.NTSB GAA20CA053Accident · No injuriesData collectionFinal reportZenair CH701 · Salem, ORThe pilot's failure to maintain lateral control during takeoff, which resulted in impact with terrain. Contributing to the accident was the pilot’s improper decision to make his first flight in an airplane he unfamiliar with before waiting for calm winds.NTSB GAA20CA082Accident · No injuriesData collectionFinal reportCessna 170 · Albuquerque, NMThe pilot receiving instruction's failure to maintain directional control and his inadvertent left brake pedal application during the landing roll, which resulted in a runway excursion and ground-loop.NTSB GAA20CA050Accident · No injuriesData collectionFinal reportPiper PA 30 · Opa Locka, FLThe pilot receiving instruction's failure to relinquish the flight controls to the flight instructor during a simulated engine failure during takeoff, which resulted in the airplane touching down in a left banking attitude and the landing gear collapsing.NTSB WPR20LA012Accident · No injuriesClass 3 · LimitedFinal reportCzech Sport Sportcruiser · Holden, UTThe fatigue failure of the No. 2 cylinder intake valve spring retainer due to air trapped in the lubrication system, which resulted in a total loss of engine power. Contributing to the severity of the damage was the improper deployment of the ballistic…NTSB GAA20CA041Accident · No injuriesData collectionFinal reportMaule MX7 · Nantucket, MAThe pilot's failure to maintain directional control during landing on a grass runway in gusting wind conditions, which resulted in impact with a large bush.NTSB GAA20CA028Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Lebanon, NHThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a ditch.NTSB GAA20CA015Accident · No injuriesData collectionFinal reportTaylorcraft BC12 · Goddard, KSThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB ANC20LA002Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Palmer, AKThe pilot's delayed application of carburetor heat in weather conditions conducive to carburetor icing, which resulted in a partial loss of engine power, a precautionary landing, and impact with terrain.NTSB GAA20CA009Accident · No injuriesData collectionFinal reportAeronca 7AC · Waynesburg, PAThe student pilot's failure to maintain directional control during the landing roll due to his foot slipping off the right pedal and becoming stuck between the pedal and fuselage frame, which resulted in a runway excursion and impact with a ditch.NTSB GAA19CA586Accident · No injuriesData collectionFinal reportPiper PA 12 · Williams, CAThe pilot's over application of power during recovery from a runway excursion, which resulted in a ground loop and nose over.NTSB GAA19CA587Accident · No injuriesData collectionFinal reportBeech 36 · Lubbock, TXThe pilot's improper pitch trim setting during takeoff in a left quartering tailwind, which resulted in the airplane abruptly pitching up and subsequently experiencing an aerodynamic stall. Contributing to the accident was the pilot's failure to follow a…NTSB GAA19CA550Accident · No injuriesData collectionFinal reportPzl Okecie PZL104 · Reno, NVThe pilot's failure to maintain bank control during takeoff in gusting crosswind conditions, resulting in a loss of control in flight and subsequent impact with terrain.NTSB GAA19CA543Accident · No injuriesData collectionFinal reportCessna 150 · Memphis, TNThe student pilot's improper landing flare and the flight instructor's delayed remedial action during landing, which resulted in a loss of airplane control and impact with terrain.NTSB GAA19CA528Accident · Minor injuriesData collectionFinal reportSiai-Marchetti SM 1019 · Lakeport, CAThe pilot's exceedance of the airplane's critical angle of attack during takeoff in gusting, variable wind conditions, which resulted in a loss of airplane control and subsequent impact with water.NTSB GAA19CA521Accident · No injuriesData collectionFinal reportPiper PA18 · Beluga, AKThe pilot's failure to maintain an adequate climb rate during takeoff in gusting wind conditions, which resulted in an uncontrolled descent.NTSB CEN19LA319Accident · Minor injuriesClass 3 · LimitedFinal reportLancair LC41-550FG · Branson, MOA total loss of engine power after takeoff for undetermined reasons.NTSB GAA19CA524Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Manchester, NHThe student pilot's failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with approach lights.NTSB CEN19LA299Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Conroe, TXA partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB ANC19CA057Accident · Minor injuriesData collectionFinal reportPiper PA22 · Arctic Village, AKThe pilot's failure to maintain adequate airspeed while maneuvering to avoid mountainous terrain, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.NTSB WPR19TA245Accident · No injuriesClass 3Final reportBell 47G · North Las Vegas, NVThe noncertificated passenger’s loss of control during attempted hover operations.NTSB GAA19CA515Accident · No injuriesData collectionFinal reportPiper PA18 · Kenai, AKThe pilot's improper landing flare, which resulted in a hard landing and the subsequent loss of directional control and impact with a tree.NTSB GAA19CA511Accident · No injuriesData collectionFinal reportPiper PA28 · Cottonwood, AZThe student pilot's improper pitch and lateral control during a soft-field takeoff, which resulted in impact with terrain. Contributing to the accident was the student pilot's failure to relinquish control of the airplane to the instructor.NTSB GAA19CA507Accident · No injuriesData collectionFinal reportMaule M5 · Anchorage, AKThe pilot's excessive braking during landing on a dry lakebed, which resulted in a nose-over.NTSB GAA19CA499Accident · Minor injuriesData collectionFinal reportVans RV7 · Ocracoke, NCThe pilot's failure to maintain lateral control during an attempted aborted landing, which resulted in impact with trees.NTSB ANC19LA046Accident · No injuriesClass 3 · LimitedFinal reportCessna 208B · Lahaina, HIThe pilots’ failure to maintain a proper approach speed and their decision to continue the approach for landing, which resulted in the airplane landing long and a subsequent runway overrun.NTSB CEN19LA269Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Blair, NEThe loss of main rotor rpm for reasons that could not be determined based on the available evidence, which resulted in a hard landing.NTSB GAA19CA493Accident · No injuriesData collectionFinal reportNorth American AT 6D · Chino, CAThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA19CA490Accident · No injuriesData collectionFinal reportDiamond DA20 · Pueblo, COThe student pilot's failure to maintain the runway heading during an attempted aborted landing, which resulted in a runway excursion onto rough terrain.NTSB GAA19CA503Accident · No injuriesData collectionFinal reportCessna 172 · Ocean City, MDThe student pilot's improper landing flare with a tailwind, which resulted in a hard, bounced landing.NTSB CEN19LA250Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Lyons, NEThe engine's low cylinder compression, which resulted in low rotor rpm and a subsequent dynamic rollover following landing on soft terrain.NTSB GAA19CA470Accident · No injuriesData collectionFinal reportCessna 177 · Placerville, CAThe pilot's exceedance of the airplane's critical angle of attack during a go-around, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR19LA204Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 162 · Vernal, UTThe flight instructor's abrupt maneuver at an altitude too low for recovery, which resulted in impact with the runway.NTSB GAA19CA463Accident · No injuriesData collectionFinal reportHughes 269A · Springfield, TNThe pilot’s failure to maintain helicopter control and a loss of tail rotor effectiveness while hover-taxiing and turning toward a taxiway in gusting crosswind conditions, which resulted in a dynamic rollover.NTSB CEN19CA237Accident · No injuriesData collectionFinal reportNorth American AT 6F · Oshkosh, WIThe pilot's loss of directional control during landing with a quartering tailwind, which resulted in a runway excursion and subsequent substantial damage.NTSB CEN19LA230Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson R44 · Ida Grove, IAA total loss of engine power during an aerial application flight for undetermined reasons.NTSB GAA19CA450Accident · No injuriesData collectionFinal reportRockwell 112A · Cove, ORThe pilot's delayed decision to abort the takeoff from a grass runway, which resulted in a runway overrun and subsequent impact with a pole.NTSB ANC19LA036Accident · Serious injuriesClass 3 · LimitedFinal reportStoddard Hamilton Glasair II · Chattanooga, TNThe pilot's failure to switch to the secondary electrical system after the primary electrical system failed for unknown reasons.NTSB GAA19CA409Accident · No injuriesData collectionFinal reportDiamond DA 40 · Denver, COThe pilot receiving instruction's failure to maintain the runway heading and bank control during landing in crosswind conditions, which resulted in a go-around and subsequent collision with a runway light.