NTSB investigations
19,008 cases where NTSB found Personnel issues.
Cases, newest first
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 c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02')) 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 c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '02')) 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 WPR24FA040Accident · 3 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Mertzon, TXThe non-instrument-rated pilot’s continued visual flight into night instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of control. Contributing to the accident was the pilot’s overconfidence.NTSB ERA24LA049Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Valdosta, GAThe pilot’s failure to extend the landing gear before landing.NTSB CEN24FA046Accident · 2 fatalClass 3 · FieldFinal reportSocata TBM 700 · Ludington, MIThe pilot’s decision to take off with ice/snow contamination on the airplane’s wings, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA24LA047Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20F · Meridianville, ALThe pilot’s exceedance of the airplane’s critical angle of attack while on final approach to land, which resulted in an aerodynamic stall, a loss of airplane control, and impact with terrain.NTSB CEN24LA044Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 7AC · DeWitt, ARThe pilot’s loss of airplane directional control while landing.NTSB CEN24FA045Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22T · Fairland, INBoth pilots’ failure to maintain adequate airspeed during departure from the airport, which led to the airplane exceeding its critical angle of attack, entering an aerodynamic stall, and impacting terrain.NTSB WPR24LA041Accident · No injuriesClass 3 · LimitedFinal reportBell OH-58A · Brawley, CAA total loss of engine power due to the failure of the No. 8 bearing and the subsequent failure of the scavenge oil pump.NTSB CEN24LA043Accident · No injuriesClass 4 · LimitedFinal reportBearhawk Four · Eau Claire, WIThe pilot’s failure to maintain directional control during landing.NTSB CEN24FA042Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Plano, TXThe pilot’s exceedance of the airplane’s critical angle of attack during a climbing turn during a go-around, which resulted in an aerodynamic stall and loss of control.NTSB ANC24LA003Accident · No injuriesClass 4 · LimitedFinal reportCessna 180H · McCarthy, AKThe pilot’s loss of directional control after touchdown which resulted in substantial damage to the right wing.NTSB ERA24LA048Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Blairstown, NJThe student pilot’s improper control inputs and the flight instructor’s delayed remedial action, which resulted in a loss of control during an attempted go-around.NTSB ERA24LA044Accident · Minor injuriesClass 4 · LimitedFinal reportAero Commander 112 · Saluda, SCThe pilot’s failure to maintain directional control of the airplane during an aborted landing in crosswind conditions. Contributing to the accident was the flight instructor’s inadequate remedial action.NTSB WPR24LA048Accident · Minor injuriesClass 4 · LimitedFinal reportFlight Design Ctls · Hungry Horse, MTThe 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 WPR24LA039Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Woodland, WAThe flight instructor’s inadequate preflight planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA24LA042Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Ogdensburg, NYThe loss of control of the helicopter during taxi, which resulted in rollover.NTSB CEN24LA047Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Barataria, LAA recreational boat crossed in front of the airplane’s path during landing on the water which resulted in the airplane colliding with the boat.NTSB ANC24LA006Accident · No injuriesClass 4 · LimitedFinal reportCharles J Kase Kase KUB · Big Lake, AKThe pilot’s selection of an unsuitable landing site that was covered in deep snow.NTSB WPR24LA044Accident · No injuriesClass 4 · LimitedFinal reportTheodore C Kalman ELA Eclipse 10 · Yuma, AZThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB CEN24LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C · Buffalo, MNThe pilot's failure to maintain directional control during the landing roll with a quartering headwind.NTSB CEN24LA040Accident · No injuriesClass 4 · LimitedFinal reportICP Savannah S · Mountain View, ARThe sport pilot’s poor decision to allow a noncertificated pilot to land the airplane which resulted in a loss of control during landing.NTSB WPR24FA037Accident · 1 fatalClass 3 · FieldFinal reportCessna P210N · San Diego, CAA total loss of engine power due to fuel exhaustion. Contributing to the accident were the pilot’s inadequate flight and fuel planning and his decision to fly in night instrument meteorological conditions despite his lack of recent instrument flight.NTSB ERA24LA045Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Chesterfield, VAA hard landing, which resulted in a main rotor strike of the left vertical stablizer.NTSB WPR24LA036Accident · No injuriesClass 4 · LimitedFinal reportBell OH-58A · Estacada, ORThe pilot’s failure to maintain helicopter control during an external load operation, which resulted in the helicopter’s main rotor blades impacting the tail boom.NTSB ERA24FA038Accident · 2 fatalClass 3 · FieldFinal reportXtremeair XA42 · Union City, TNThe pilot receiving instruction’s loss of airplane control while performing aerobatics, which resulted in a stall/spin at an altitude too low for recovery. Contributing to the accident was the flight instructor’s inadequate supervision.NTSB WPR24FA035Accident · 2 fatalClass 3 · FieldFinal reportCessna 172G · Provo, UTThe pilot's exceedance of the airplane's critical angle of attack during a chandelle maneuver, which resulted in an aerodynamic stall and descent into trees and terrain. Contributing to the accident was the pilot’s decision to maneuver into a canyon and…NTSB ERA24FA036Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Micanopy, FLThe non-instrument-rated pilot’s improper inflight decision making and his flight into instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident were the pilot’s…NTSB CEN24LA038Accident · Minor injuriesClass 3 · LimitedFinal reportBede BD-4 · Lowell, INFatigue cracking of the propeller blade root, which resulted in the in-flight separation of the propeller blade from its root. Contributing to the accident was the improper machining of the blade root threads, which resulted in chatter/ratchet marks that…NTSB WPR24LA034Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 310 · Hayden, IDThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in a loss of control and subsequent stall during a precautionary landing. Contributing to the accident was the improper maintenance…NTSB ERA24LA037Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Frederick, MDA failure of a hydraulic filter, which preluded normal extension of the landing gear. Also causal was the pilot’s failure to confirm that he landing gear was extended before landing, which resulted in a gear up landing.NTSB ANC24LA004Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-22 · Anchorage, AKThe loss of engine power during final approach due to fuel exhaustion, which resulted from the pilot’s inadequate preflight.NTSB ERA24LA041Accident · No injuriesClass 3 · LimitedFinal reportCessna 421 · Lake City, FLA landing gear collapse following an aborted takeoff due to degraded climb performance for reasons that could not be determined.NTSB CEN24LA037Accident · Minor injuriesClass 3 · LimitedFinal reportCharles L. Hayes Lancair IVP Turbine · McKinney, TXThe pilot’s failure to attain the proper touchdown point during landing, which resulted in a runway excursion and collision with terrain and a vehicle.NTSB WPR24LA031Accident · No injuriesClass 4 · LimitedFinal reportAmazon.Com Services MK27-2 · Pendleton, ORThe operator’s use of an insufficiently charged battery that resulted in a total loss of engine power and subsequent impact with terrain.NTSB WPR24LA033Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Baker City, ORThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN24LA036Accident · No injuriesClass 3 · LimitedFinal reportTextron 172S · Erie, COA partial loss of engine power while maneuvering at a low altitude due to a stuck exhaust valve.NTSB ERA24LA034Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32R · Florala, ALThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the flight instructor’s inadequate supervision of the flight.NTSB CEN24LA070Accident · No injuriesClass 4 · LimitedFinal reportHelicopteres Guimbal Cabri G2 · Claremore, OKThe flight instructor’s failure to maintain sufficient rotor speed during a practice autorotation which resulted in a hard landing.NTSB CEN24LA034Accident · No injuriesClass 4 · LimitedFinal reportGrumman American Avn. AA-5 · Fort Worth, TXThe distraction of the pilot during the taxi, resulting in a ground collision.NTSB ERA24LA039Accident · No injuriesClass 4 · LimitedFinal reportGaulden William D Vans RV-4 · London, KYThe pilot’s inadvertent application of nose down pitch trim during the attempted aborted landing, which resulted in abnormal contact with the runway.NTSB CEN24LA033Accident · No injuriesClass 3 · LimitedFinal reportAero Commander 500-B · Jackson, MIA loss of engine power to both engines as a result of the pilot’s improper fuel management. Contributing was the inoperative fuel quantity sending unit.NTSB WPR24LA028Accident · No injuriesClass 4 · LimitedFinal reportMD Helicopters 369FF · Mesa, AZThe pilot’s failure to maintain a proper autorotation profile during deceleration that resulted in the tail rotor assembly impacting the ground.NTSB CEN24LA032Accident · Minor injuriesClass 4 · LimitedFinal reportTom Hodgson 29 · Kokomo, INThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR24LA029Accident · Serious injuriesClass 3 · LimitedFinal reportAerostar International RX 8 · Page, AZA hard landing after both burner pilot lights extinguished during the landing approach for undetermined reasons. Contributing to the accident was the pilot's inability to relight the burner pilot lights.NTSB WPR24LA027Accident · No injuriesClass 4 · LimitedFinal reportKitfox S5 · Ririe, IDThe pilot’s inadvertent excessive use of brakes which resulted in a nose-over.NTSB ERA24LA035Accident · No injuriesClass 4 · LimitedFinal reportPiper PA18 · Tompkinsville, KYThe pilot's failure to maintain adequate airspeed during the approach, which resulted in a hard landing.NTSB ANC24LA002Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Wasilla, AKThe instructor pilot’s delayed action and over application of brakes which resulted in a nose-over.NTSB ERA24LA030Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Pembroke Pines, FLThe pilot’s loss of airplane control and descent into terrain due to spatial disorientation during a solo night cross country flight. Contributing to the accident was the pilot’s self-reported fatigue.NTSB CEN24LA030Accident · No injuriesClass 4 · LimitedFinal reportMooney M20K · Lamar, COThe 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 CEN24FA028Accident · 1 fatalClass 3 · FieldFinal reportPiper PA46 · McCook, NEThe pilot exceeded the airplane’s critical angle of attack during the initial climb, resulting in an aerodynamic stall from which he could not recover. Contributing to the accident was the pilot’s decision to take off with the airplane well above its maximum…NTSB ERA24LA046Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-39 · Highgate, VTThe pilot’s inadvertent retraction of the landing gear during landing rollout, which resulted in a landing gear collapse.