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 CEN24LA297Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Castroville, TXThe pilot’s inadequate recovery from a bounced landing and his failure to maintain proper airplane pitch control and airspeed during the go-around, which resulted in the airplane exceeding its critical angle-of-attack and an aerodynamic stall at a low…NTSB CEN24FA295Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Irene, SDThe pilot’s poor decision to continue the flight into deteriorating weather conditions and his failure to maintain a safe altitude, which resulted in controlled flight into trees and terrain.NTSB ERA24LA337Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-301T · North Myrtle Beach, SCThe pilot’s failure to use the emergency landing gear extension system, resulting in a gear-up landing. Contributing to the accident was an alternator belt failure.NTSB CEN24LA293Accident · No injuriesClass 4 · LimitedFinal reportBeech F33A · Lincoln, NEThe pilot’s failure to maintain directional control during the landing roll with a crosswind.NTSB ERA24LA330Accident · No injuriesClass 3 · LimitedFinal reportRaytheon A36 · Naples, FLContamination of the airplane’s fuel system with debris, which resulted in restricted fuel flow through multiple fuel injectors and the subsequent partial loss of engine power.NTSB CEN24LA289Accident · No injuriesClass 3 · LimitedFinal reportEvektor Aerotechnik EV97 · Midland, TXThe pilot’s failure to maintain directional control during taxi due to strong wind gusts.NTSB ANC24LA071Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Huntsville, UTThe pilot's failure to navigate in hazy conditions, which resulted in a forced landing in a field and a collision with a pole.NTSB ERA24LA336Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Immokalee, FLThe student pilot’s (of the high wing airplane) inadequate visual lookout, which resulted in a ground collision with another airplane while taxiing.NTSB ERA24LA332Accident · No injuriesClass 4 · LimitedFinal reportBucker Jungmann C.A.S.A. 1.131 · Red Hook, NYThe Great Lakes pilot's failure to maintain adequate clearance from the Bucker Jungmann while maneuvering during an air show, which resulted in a midair collision, the inability of the Bucker Jungmann to maintain altitude, and its subsequent forced landing.NTSB CEN24LA292Accident · Minor injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Lewisville, TXThe pilot’s failure to maintain sufficient airspeed during a go-around, which resulted in an aerodynamic stall and impact with water. Contributing to the accident were crosswind gusts.NTSB CEN24LA286Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Radisson, WIThe non-certificated mechanic’s failure to properly tighten and torque the fuel system pressure test port cap, which resulted in a total loss of engine power, and a subsequent forced landing.NTSB ERA24LA329Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Moultonborough, NHThe student pilot’s improper remedial response to a bounced landing, which resulted in a hard landing.NTSB ERA24LA328Accident · Minor injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Groveland, FLThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA24LA327Accident · No injuriesClass 4 · LimitedFinal reportEnstrom 280FX · Russellville, KYThe flight instructor’s failure to maintain sufficient rotor rpm while maneuvering the helicopter low to the ground, which resulted in a loss of control.NTSB DCA24LA245Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737 · Salt Lake City, UTDelta Air Lines flight 2046 flight crew's incorrect evaluation of the clearance between their airplane and Delta Air Lines flight 2046 as they turned onto a perpendicular taxiway.NTSB CEN24LA290Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Fort Worth, TXThe pilot’s decision to allow a non-rated passenger to manipulate the flight controls during the takeoff which resulted in a loss of directional control during the takeoff.NTSB CEN24LA288Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-180 · Ft. Atkinson, WIThe pilot’s failure to extend the landing gear before landing due to distractions and his failure to conduct the Before Landing checklist.NTSB ANC24LA070Accident · No injuriesClass 4 · LimitedFinal reportRoberts Jeff Super RV8 · Carter, WYThe pilots encounter with a shifting winds during takeoff, which resulted in a loss of control and runway excursion.NTSB WPR24LA256Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Oshkosh, WIThe pilot’s failure to maintain control during an approach to land, which resulted in a hard landing.NTSB WPR24FA257Accident · 7 fatalClass 3 · FieldFinal reportPilatus PC-12/47E · Recluse, WYThe pilot’s loss of control due to spatial disorientation while operating in instrument meteorological conditions, which resulted in an in-flight breakup. Contributing to the accident was the pilot’s distraction from the autopilot disconnecting due to an…NTSB WPR24FA255Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802A · Izee, ORThe pilot’s controlled flight into terrain while maneuvering through an area of low visibility due to wildfire smoke and haze.NTSB WPR24LA258Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Camarillo, CAThe pilot’s loss of directional control during landing, which resulted in a nose over.NTSB WPR24LA253Accident · No injuriesClass 4 · LimitedFinal reportCanadian Car & Foundry Harvard MK IV · Oshkosh, WIThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB ERA24LA324Accident · No injuriesClass 4 · LimitedFinal reportLake LA4 · Catskill, NYThe pilot’s failure to maintain control of the airplane during a takeoff from water in gusting wind conditions.NTSB ERA24FA323Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Trenton, METhe pilot’s aggressive pitch and power control inputs while executing a missed approach, which resulted in his spatial disorientation and a loss of airplane control.NTSB WPR24LA262Accident · No injuriesClass 4 · LimitedFinal reportHiller UH-12E · Bonners Ferry, IDThe pilot’s improper selection of a landing site, which resulted in a main rotor strike. Contributing to the accident was the pilot’s improper performance planning and altitude selection over water, which resulted in an rpm droop.NTSB WPR24LA254Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-34-220T · Roy, UTThe flight instructor’s decision to shut down an engine on an extended leg of the airport traffic pattern, which led to a loss of performance and inability to maintain altitude.NTSB CEN24LA294Incident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Appleton, WIThe pilot’s failure to maintain adequate wingtip clearance while taxiing. Contributing to the accident was the ambiguous nonstandard parking at the time of the incident.NTSB CEN24LA285Accident · Serious injuriesClass 4 · LimitedFinal reportCessna A188B · Sumner, NEThe pilot’s failure to maintain clearance from a power line during the spray pass.NTSB WPR24LA260Accident · No injuriesClass 3 · LimitedFinal reportKitfox Series V · La Grande, ORSeparation of the propeller blades from progressive damage at the blade roots due to overtightening of the hub bolts.NTSB WPR24FA252Accident · 2 fatalClass 3 · FieldFinal reportTextron T206H · Kneeland, CAThe pilot’s delayed decision to perform a go-around after an unstabilized approach, which resulted in a loss of control, runway overrun, and impact with terrain.NTSB ERA24FA318Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Ronkonkoma, NYA loss of engine power during initial climb for undetermined reasons. Contributing to the outcome was the pilot's failure to maintain control of the airplane following the loss of engine power and his decision to perform an intersection takeoff which, reduced…NTSB CEN24FA278Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-602 · Oxford, INThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain adequate airspeed while maneuvering during an agricultural flight, which resulted in an aerodynamic stall and a loss of control at too low of an altitude to recover.…NTSB CEN24FA277Accident · 2 fatalClass 3 · FieldFinal reportLancair ES · Oshkosh, WIThe pilot’s failure to maintain adequate airspeed which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall while maneuvering for traffic spacing.NTSB ERA24LA311Accident · Serious injuriesClass 3 · LimitedFinal reportChampion 7ECA · Beaufort, NCThe pilot’s inadequate fuel planning and preflight inspection, which resulted in fuel exhaustion, a total loss of engine power, and a forced landing.NTSB CEN24LA279Accident · Serious injuriesClass 4 · LimitedFinal reportEvolution Revolt · Rochelle, ILThe pilot’s failure to maintain terrain clearance during a low-level turn, that resulted in an impact with the ground.NTSB CEN24LA276Accident · No injuriesClass 4 · LimitedFinal reportBell 206 · Cornland, ILThe pilot was unable to see a wire due to the setting sun and the helicopter subsequently struck the wire.NTSB CEN24LA275Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206B · Cuba City, WIThe pilot’s failure to maintain clearance from a wire during an agricultural application pass.NTSB ERA24FA309Accident · 1 fatalClass 3 · FieldFinal reportCessna 208 · Youngstown, NYThe pilot’s loss of control in flight which resulted in the airplane impacting the ground at a high rate of speed and descent.NTSB CEN24LA328Accident · No injuriesClass 3 · LimitedFinal reportHawker Beechcraft Hawker 900XP · Telluride, COThe flight crew’s failure to properly configure the airplane for takeoff in a high-density altitude environment, which resulted in a loss of control and a subsequent runway excursion. Contributing to the accident was the flight crew’s failure to use…NTSB CEN24LA281Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver GT-400 · Mansfield, MOThe pilot’s failure to maintain control after takeoff, which resulted in an aerodynamic stall.NTSB ANC24LA069Accident · 3 fatalClass 3 · LimitedFinal reportBeech A35 · Gustavus, AKThe pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB ANC24LA068Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver U-6A · Pedro Bay, AKThe pilot’s failure to maintain directional control of the airplane during takeoff. Contributing to the accident was sun glare.NTSB ERA24LA352Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Danville, KYThe pilot’s failure to maintain control of the airplane while landing and his inadequate communication to the pilot-rated passenger of her role during the flight.NTSB ERA24LA316Accident · 1 fatalClass 3 · LimitedFinal reportSheaffer Leroy B Kitfox Model IV · Palmyra, PAThe pilot’s failure to maintain directional control of the tailwheel airplane during takeoff from a narrow runway with a crosswind, which resulted in a runway excursion and collision with terrain.NTSB ERA24FA308Accident · 3 fatalClass 3 · FieldFinal reportBeech B-60 · Vienna Center, OHThe pilot’s loss of airplane control during a single-engine go-around. Also contributing to the accident was fuel system contamination, which resulted in detonation and a total loss of left engine power.NTSB CEN24LA280Accident · No injuriesClass 4 · LimitedFinal reportCessna 195A · Greenville, MIThe pilot’s loss of directional control during landing which led to a ground-loop.NTSB WPR24LA251Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Carlsbad, CAThe pilot’s failure to maintain lateral control of the helicopter while departing with a crosswind, which resulted in a dynamic rollover.NTSB WPR24LA250Accident · No injuriesClass 4 · LimitedFinal reportBoeing B75N1/N2S-3 · Hollister, CAThe pilot’s loss of directional control on landing, which resulted in a nose over.NTSB ERA24LA320Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Port St. Lucie, FLThe pilot’s failure to correctly identify the airport runway, which resulted in a landing on a road and contact with a power line. Contributing to the outcome was the sun glare.