NTSB investigations, 2023
975 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 | 643 |
| 2026 | 294 |
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\") = 2023
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") = 2023 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 ERA24LA084Accident · No injuriesClass 4 · LimitedFinal reportGolden Avio S R L F30 Brio · Midland, VAThe pilot’s improper recovery from a bounced landing, which resulted in damage to, and the separation of the nose wheel and fork bracket assembly, and subsequent collapse of the nose landing gear assembly.NTSB ERA24FA078Accident · 1 fatalClass 3 · FieldFinal reportPiper PA46R-350T · Mooresville, NCA missing induction clamp, which allowed the induction hose to the left side intercooler to become disconnected, resulting in a total loss of engine power due to an overly rich fuel/air mixture.NTSB CEN24LA079Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22T · Davenport, IAThe fatigue failure of the No. 5 cylinder head, which resulted in a total loss of engine power. Contributing to the accident was the maintenance which did not fully blend to the depth necessary to preclude the failure.NTSB CEN24LA077Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 17-30A · Washington, MOFuel starvation and a total loss of engine power due to an obstructed fuel vapor return path. Contributing to the accident was the pilot’s inadvertent aerodynamic stall/spin, which likely increased the severity of the ground impact.NTSB CEN24LA081Accident · No injuriesClass 4 · LimitedFinal reportMaule M-6-235 · Beaumont, TXThe pilot’s failure to maintain directional control during landing in crosswind conditions, which resulted in a ground loop on the runway.NTSB CEN24LA076Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18A 150 · Vermillion, SDThe pilot’s encounter with carburetor icing during landing final approach which resulted in fuel starvation, a total loss of engine power, and impact with terrain.NTSB ERA24LA076Accident · No injuriesClass 3 · LimitedFinal reportBell Helicopter Textron 206L-1 · Walland, TNThe improper installation of the No. 8 bearing spanner nut, which resulted in the No. 8 bearing’s failure, and the subsequent total loss of engine power.NTSB CEN24FA073Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Canton, TXThe pilot’s failure to attain the runway while landing at night, which resulted in an impact with trees.NTSB WPR24LA061Accident · No injuriesClass 3 · LimitedFinal reportGlasair SH2 · Prescott, AZLoss of directional control during landing due to an improperly constructed and maintained tailwheel locking assembly.NTSB CEN24LA074Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Ponca City, OKThe pilot’s loss of directional control during landing in gusty crosswind conditions.NTSB ANC24LA009Accident · Minor injuriesClass 4 · LimitedFinal reportAirbus Helicopters AS350B3 · Palmer, AKThe pilot's failure to maintain clearance from snow-covered terrain during the landing approach in flat light conditions.NTSB WPR24LA067Accident · No injuriesClass 3 · LimitedFinal reportBell 206B · El Centro, CAAn in-flight failure of the engine-to-transmission driveshaft due to a fatigue fracture of the forward-most flex plate in the forward KAflex coupling that resulted from a loose bolt attachment between the flex plate and the forward driveshaft coupling.…NTSB CEN24LA078Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 210M · Gulfport, MSThe pilot’s failure to maintain directional control during the go-around with a crosswind.NTSB ANC24LA011Accident · No injuriesClass 3 · LimitedFinal reportCessna 172P · Kahului, HIA partial loss of engine power due to the formation of carburetor ice, which resulted in the inability to maintain altitude in the traffic pattern. Contributing to the outcome was the pilot’s delayed use of carburetor heat in conditions conducive to the…NTSB WPR24LA064Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Spanish Fork, UTMaintenance personnel’s improper installation of the left magneto, which resulted in oil starvation to the engine and a subsequent total loss of engine power.NTSB WPR24LA060Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20J · Carlin, NVImproper spacing of the magneto’s breaker point contact assemblies, which led to a loss of engine ignition during cruise flight and resulted in a total loss of engine power.NTSB ERA24FA072Accident · 1 fatalClass 3 · FieldFinal reportHawker Beechcraft G36 · Buford, GAA loss of engine power for reasons that could not be determined due to significant thermal damage from postimpact fire.NTSB ERA24FA069Accident · 2 fatalClass 3 · FieldFinal reportAmerican Eurocopter AS350B2 · Hammonton, NJThe helicopter’s gradual descent and impact with terrain for reasons that could not be determined.NTSB DCA24LA330IncidentClass 2 · LimitedFinal reportBoeing 737-8 · Kenner, LAA partial loss of engine power due to bird ingestion in the No. 1 (left) engine, which resulted in the activation of the load reduction device to prevent vibration. The load reduction device activation resulted in smoke and fumes entering the cockpit.NTSB ERA24LA070Accident · No injuriesClass 3 · LimitedFinal reportBeech A24 · Miami, FLA partial loss of engine power during initial climb for undetermined reasons, resulting in a forced landing.NTSB ERA24LA068Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Pahokee, FLThe flight instructor’s failure to maintain control of the airplane after encountering a wind gust during landing.NTSB CEN24LA069Accident · Minor injuriesClass 4 · LimitedFinal reportAero Commander 100 · Texarkana, ARThe pilot’s improper decision to attempt a go-around with full flaps extended, which resulted in decreased climb performance and led to a collision with trees.NTSB CEN24LA068Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-23-250 · Forney, TXThe pilot's inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR24FA057Accident · 3 fatalClass 3 · FieldFinal reportCessna 172G · Independence, ORThe pilot’s decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in collision with an obstacle while landing.NTSB CEN24LA071Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Stephenville, TXThe pilot’s failure to maintain directional control during landing that resulted in an impact with terrain.NTSB CEN24LA065Accident · Serious injuriesClass 3 · LimitedFinal reportBeech B36TC · Burnet, TXThe loss of engine power due an overly rich mixture from an improper adjustment of the fuel pump, which resulted in a forced landing and impact with a car and terrain.NTSB WPR24FA056Accident · 1 fatalClass 3 · FieldFinal reportVans RV8 · Corona, CAFuel contamination from the pilot’s improper application of a sealant to the fuel tank, which resulted in a partial loss of engine power on takeoff.NTSB ERA24LA083Accident · No injuriesClass 4 · LimitedFinal reportRabe Richard Exec 162F · Tuscumbia, ALThe pilot’s failure to maintain control of the helicopter, which resulted in the right skid contacting the ground and a subsequent rollover.NTSB ERA24LA066Accident · Serious injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Asheville, NCFatigue failure of the No. 4 inner main bearing cap screw and connecting rod bolts, which resulted in a total loss of engine power. Contributing to the failure were the low material strength of the inner main bearing cap screw and the increased loads on the…NTSB CEN24FA064Accident · 2 fatalClass 3 · FieldFinal reportPilatus PC-12/45 · Christoval, TXThe instrument-rated pilot and a passenger departed on an instrument flight rules (IFR) flight. After about 4.5 hours, while approaching the first planned fuel stop, the airplane was in instrument meteorological conditions (IMC). According to air traffic…NTSB CEN24LA063Accident · No injuriesClass 3 · LimitedFinal reportCessna T210 · Sapulpa, OKThe total loss of engine power due to the failure of the left magneto and subsequent damage to a lead for the right magneto.NTSB ERA24LA064Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Sidney, OHThe pilots’ improper landing flare, which resulted in a hard landing, runway excursion, and subsequent impact with a terminal sign and taxi light.NTSB CEN24LA066Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV6 · Searcy, ARThe pilot-rated passenger’s reported failure to maintain control during the landing.NTSB CEN24LA062Accident · No injuriesClass 4 · LimitedFinal reportCessna 340A · New Orleans, LAThe improper maintenance of the main landing gear, which resulted in a collapse and overstress failure of the left main landing gear during landing.NTSB CEN24LA060Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-24-260 · Anthony, KSA failure of the airplane’s alternator, which resulted in a loss of electrical power, and the pilot’s failure to use the emergency gear extension procedure during the initial landing approach, which led to a gear-up landing.NTSB ANC24LA010Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kapolei, HIThe first pilot’s failure to maintain a stabilized approach, in gusty crosswind conditions, in an environment favoring wake turbulence.NTSB WPR24FA054Accident · 1 fatalClass 3 · FieldFinal reportBeech A36 · Topock, AZThe failure of the No. 4 connecting rod due to oil starvation, which resulted in a loss of engine power, inflight fire, and a subsequent off-airport emergency landing on rough desert terrain. Contributing to the accident was the pilot’s decision to attempt a…NTSB CEN24LA059Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Lubbock, TXThe pilot’s failure to maintain directional control during the landing that resulted in a runway excursion, an impact with a runway sign, and a nose gear collapse.NTSB CEN24LA058Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46-500TP · Ann Arbor, MIThe airplane’s encounter with unexpected wind shear during final approach, which resulted in a hard landing short of the runway.NTSB CEN24FA057Accident · 2 fatalClass 3 · FieldFinal reportBeech A23-24 · Oklahoma City, OKA total loss of engine power due to multiple connecting rod failures from oil starvation associated with an extensive before takeoff oil system leak, the source of which could not be identified due to postaccident fire damage.NTSB WPR24FA053Accident · 1 fatalClass 3 · FieldFinal reportBeauchamp Norm Kitfox · Eloy, AZThe separation of a propeller blade during the initial climb due to insufficient blade retention forces. Contributing to the accident was the propeller blade retention design, manufacturing defects that prevented the propeller from achieving adequate grip…NTSB ERA24LA060Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Mount Vernon, ALThe pilot’s decision to operate the airplane at a low altitude over a river, and his failure to maintain clearance from the river while maneuvering.NTSB CEN24LA103Accident · No injuriesClass 4 · LimitedFinal reportVans RV6 · Bremen, INThe collapse of the nose landing gear after it contacted soft terrain during the landing roll.NTSB CEN24LA061Accident · No injuriesClass 3 · LimitedFinal reportCessna 421C · McGregor, TXThe failure of the spring pin in the right propeller governor, which precluded the pilot from controlling the propeller pitch to maintain engine rpm, resulting in a loss of engine thrust, excessive drag, and the subsequent forced landing to a field.NTSB ANC24FA008Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-18-150 · Anchor Point, AKAn impact to the left wing, at an undetermined time, for reasons that could not be determined, which partially separated the left wing and rendered the airplane uncontrollable.NTSB ERA24LA059Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Zephyrhills, FLAn aerodynamic stall from which the pilots did not recover while maneuvering in the airport traffic pattern.NTSB ERA24FA058Accident · 2 fatalClass 3 · FieldFinal reportBeech 35-C33 · Pulaski, TNThe pilot’s failure to maintain airplane control, which resulted in pilot-induced oscillations and a subsequent loss of control and impact with terrain.NTSB WPR24FA052Accident · Serious injuriesClass 3 · FieldFinal reportRemos Remos GX · Taylor, AZThe pilot’s decision to attempt takeoff with frost covering the airplane’s wings, which led to an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB CEN24LA055Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Alamosa, COThe pilot’s failure to maintain directional control during landing with an excessive touchdown speed that resulted in a loss of control and impact with terrain.NTSB WPR24LA051Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Mesa, AZA failure of the engine cowling right side latch pin and fasteners, which resulted in the partial separation of the engine cowling during flight.