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.

NTSB WPR11LA056Accident · No injuriesLimited investigationFinal reportBell 407 · Riverdale, UTThe pilot's failure to maintain clearance from a highway marker sign while maneuvering.Nov 22, 2010 · N408UH · Substantial damageNTSB WPR11FA054Accident · 3 fatalField investigationFinal reportBeech 19A · Newport Beach, CAThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Nov 22, 2010 · N6064N · Substantial damageNTSB ERA11CA069Accident · No injuriesData collectionFinal reportCessna 172G · Winter Haven, FLThe pilot's inadequate preflight/inflight fuel planning resulting in fuel exhaustion and total loss of engine power.Nov 21, 2010 · N3700L · Substantial damageNTSB CEN11FA079Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Norfolk, NEThe pilot’s decision to continue the flight into instrumental meteorological conditions which resulted in a collision with a tree.Nov 21, 2010 · N8675P · Substantial damageNTSB ERA11CA076Accident · No injuriesData collectionFinal reportBeech 95-C55 · Williston, FLThe pilot's failure to properly configure and confirm the position of the landing gear prior to landing.Nov 19, 2010 · N677Z · Substantial damageNTSB CEN11LA078Accident · No injuriesLimited investigationFinal reportSwiezy Glasair SHA · North Little Rock, ARThe pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall and hard landing.Nov 19, 2010 · N729RS · Substantial damageNTSB WPR11FA061Accident · 1 fatalField investigationFinal reportAmerican Champion 8GCBC · Bremerton, WAThe pilot did not maintain clearance from terrain for undetermined reasons. Contributing to the accident were the pilot’s use of oxycodone and his severe coronary artery disease.Nov 18, 2010 · N273MA · Substantial damageNTSB CEN11FA075Accident · 1 fatalField investigationFinal reportHawker-Beechcraft A36 · Oklahoma City, OKThe pilot’s loss of control of the airplane during night instrument meteorological conditions, likely due to spatial disorientation.Nov 18, 2010 · N314DP · Substantial damageNTSB WPR11FA052Accident · No injuriesField investigationFinal reportGates Lear Jet 25B · Portland, ORThe failure of the flight crew to stop the airplane on the runway due to the flying pilot’s failure to attain the proper touchdown point. Contributing to the accident was an anti-skid system that was not performing optimally, which allowed the airplane to…Nov 17, 2010 · N25PJ · Substantial damageNTSB WPR11FA050Accident · 2 fatalField investigationFinal reportDiamond Aircraft Ind DA20-C1 · Payson, UTThe pilots' failure to maintain adequate airspeed during a slow flight maneuver that resulted in a stall and spin, and the flight instructor’s delayed or improper remedial actions to recover from the spin. Contributing to the accident was the flight school’s…Nov 17, 2010 · N978CT · Substantial damageNTSB WPR11LA048Accident · Serious injuriesLimited investigationFinal reportMD Helicopter 369D · Salem, ORThe pilot’s failure to maintain clearance between the longline and trees, which resulted in the longline snagging a tree and then recoiling into the main rotor blades and a subsequent loss of helicopter control.Nov 15, 2010 · N155PH · Substantial damageNTSB CEN11LA073Accident · Serious injuriesLimited investigationFinal reportCessna 172K · San Antonio, TXThe pilot's failure to maintain aircraft control, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to land with a tailwind.Nov 15, 2010 · N7183G · Substantial damageNTSB WPR11FA047Accident · 1 fatalField investigationFinal reportBeech C35 · Enterprise, ORThe noninstrumented pilot’s inadequate weather planning, which resulted in his failure to maintain visual flight while maneuvering under low ceilings in rainy and foggy conditions and his subsequent failure to maintain clearance from mountainous terrain.Nov 14, 2010 · N747MT · Substantial damageNTSB WPR11FA046Accident · 1 fatalField investigationFinal reportCessna 150J · Tucson, AZThe pilot's inability to maintain airplane control while on final approach due to undiagnosed cardiac disease, which caused a medical emergency and subsequent pilot incapacitation.Nov 14, 2010 · N60858 · Substantial damageNTSB CEN11CA068Accident · No injuriesData collectionFinal reportSchweizer 300C · Broomfield, COThe pilot’s inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's improper execution of an autorotation, which resulted in a hard landing.Nov 14, 2010 · N299RJ · Substantial damageNTSB ERA11LA056Accident · 1 fatalLimited investigationFinal reportCarlo Robert Quicksilver SPT 2S · Lajas, PRThe pilot’s failure to maintain adequate airspeed, which resulted in an aerodynamic stall and entry into a spin.Nov 13, 2010 · N5593F · Substantial damageNTSB WPR11FA045Accident · No injuriesField investigationFinal reportEurocopter AS350B2 · Pacoima, CAThe contamination of a spool bearing in the power turbine governor during manufacture, which led to the bearing’s failure in flight, a subsequent loss of engine power during departure, and the resultant hard landing.Nov 12, 2010 · N1231A · Substantial damageNTSB ERA11CA062Accident · No injuriesData collectionFinal reportCessna 182 · Sevierville, TNThe pilot's inadequate landing flare, which resulted in a bounced landing.Nov 12, 2010 · N1992D · Substantial damageNTSB ERA11CA057Accident · Serious injuriesData collectionFinal reportAeronca O58B · Livingston, NYThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Nov 12, 2010 · N46014 · Substantial damageNTSB WPR11LA049Accident · No injuriesLimited investigationFinal reportMooney M20B · Marana, AZThe pilot did not secure the manual landing gear operating handle, which resulted in the landing gear collapse during the landing roll.Nov 11, 2010 · C-GFRP · Substantial damageNTSB OPS11IA101Incident · No injuriesIncident investigationFinal reportBoeing 737-832 · 66 NM East of Hobe Sound, FLAir traffic controllers did not maintain required awareness of available flight data and aircraft positions, resulting in issuance of an incorrect altitude clearance that caused a loss of standard instrument flight rules separation between the two aircraft.Nov 11, 2010 · N3742C · 2 aircraft · No damageNTSB ERA11FA055Accident · 2 fatalField investigationFinal reportMooney M20F · Copake, NYThe pilot's failure to monitor and maintain clearance from mountainous terrain during a visual descent to the destination airport at night, which resulted in controlled flight into terrain.Nov 11, 2010 · N6878V · Substantial damageNTSB ERA11FA054Accident · 4 fatalField investigationFinal reportPiper PA-44-180 · West Palm Beach, FLThe failure of both the pilot and the certified flight instructor to ensure that the left fuel selector was in the on position for takeoff and their failure to follow the proper procedures when the left engine lost power shortly after takeoff, resulting in an…Nov 11, 2010 · N883FT · Substantial damageNTSB WPR11LA044Accident · No injuriesLimited investigationFinal reportPiper PA30 · Tucson, AZThe pilot's impairment by an undiagnosed medical condition, which resulted in a loss of directional control and subsequent collision with a building during the landing roll. Contributing to the accident was the pilot's decision to fly when he was not feeling…Nov 10, 2010 · N628R · Substantial damageNTSB ERA11LA063Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Merritt Island, FLThe pilot's failure to maintain directional control while landing, which resulted in a main landing gear collapse and subsequent runway excursion.Nov 10, 2010 · N82934 · Substantial damageNTSB CEN11TA064Accident · Minor injuriesFinal reportPartenavia P.68 · Anthony, NMThe pilot's decision to conduct a low-level flight in mountainous terrain in an area where downdrafts were prevalent, resulting in the inadvertent loss of control and the collision with the terrain.Nov 10, 2010 · N44956 · DestroyedNTSB CEN11LA066Accident · 1 fatalLimited investigationFinal reportGearn Geary D Swearingen SX300 · Milford, IAA loss of control for undetermined reasons.Nov 10, 2010 · N3ZX · Substantial damageNTSB CEN11CA062Accident · No injuriesData collectionFinal reportCessna 172 · Pineville, LAThe pilot/mechanic’s improper inspection of the airplane following the engine installation.Nov 9, 2010 · N9747L · Substantial damageNTSB CEN11CA060Accident · Minor injuriesData collectionFinal reportPiper PA-22-160 · Watertown, SDThe pilot's inadvertent and premature use of the brakes during the landing roll, which resulted in a nose-over.Nov 8, 2010 · N3029Z · Substantial damageNTSB ERA11WA086Accident · 1 fatalForeign investigationEurocopter AS 350 B2 · Taltal, ChileOn November 6, 2010, at 2330 universal coordinated time, a Eurocopter, AS 350 B2 helicopter, Chilean registration CC-AAN, collided with terrain while in low level cruise flight near Taltal, Chile. The flight was operated by Servicios y Transporte Aereos…Nov 6, 2010 · CC-AAN · DestroyedNTSB ERA11LA049Accident · Serious injuriesLimited investigationFinal reportAirborne Classic · Stow, MAThe operator's inadequate engine maintenance, which resulted in a total loss of engine power. Contributing to the accident was the pilot's decision to conduct a downwind takeoff.Nov 6, 2010 · N582YA · Substantial damageNTSB ERA11CA053Accident · No injuriesData collectionFinal reportLuscombe 8A · Hot Springs, VAThe pilot's inadequate compensation for the crosswind during landing.Nov 6, 2010 · N71102 · Substantial damageNTSB ERA11LA048Accident · 2 fatalLimited investigationFinal reportBean R E/R B Weld Glasair III · Winchester, TNThe pilot's inadvertent climb and entry into instrument meteorological conditions during a course reversal, which resulted in spatial disorientation and a loss of control.Nov 5, 2010 · N7SY · DestroyedNTSB CEN11LA061Accident · Serious injuriesLimited investigationFinal reportSiai-Marchetti S.205/22R · Fruitvale, TXA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Nov 5, 2010 · N971WA · Substantial damageNTSB WPR11CA037Accident · No injuriesData collectionFinal reportCessna 172S · Port Townsend, WAThe pilot's improper flare/touchdown while landing, resulting in a loss of directional control and a runway excursion.Nov 4, 2010 · N14511 · Substantial damageNTSB CEN11CA056Accident · Minor injuriesData collectionFinal reportCessna 150H · Kenmare, NDThe pilot's inadequate landing flare and recovery from a bounced landing.Nov 4, 2010 · N23099 · Substantial damageNTSB WPR11CA040Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Carnation, WAThe pilot's failure to attain the proper touchdown point during a practice off-airport landing.Nov 3, 2010 · N4389Z · Substantial damageNTSB CEN11FA053Accident · 1 fatalField investigationFinal reportBell 206 · Meeker, COThe pilot's failure to maintain clearance from electrical power lines during the low-altitude flight.Nov 3, 2010 · N8533F · Substantial damageNTSB CEN11CA065Accident · No injuriesData collectionFinal reportWelch Thomas RV9 · Sac City, IAThe pilot's loss of directional control while landing with a gusting wind.Nov 3, 2010 · N475TW · Substantial damageNTSB ERA11CA046Accident · No injuriesData collectionFinal reportBombardier CL-600-2B19 · Pittsburgh, PAThe ground crew’s failure to detach the air-starter hose from the airplane before moving the cart away resulting in structural damage to a skin panel.Nov 2, 2010 · N454SW · Substantial damageNTSB CEN11LA051Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2B19 · Chicago, ILThe pickup truck driver’s failure to follow airport and company policies regarding ground vehicle operations, which allowed for the unattended truck to collide with the airplane. Contributing to the accident were the truck's misadjusted shift lever and…Nov 2, 2010 · N709BR · Substantial damageNTSB WPR11CA036Accident · Minor injuriesData collectionFinal reportAerostar Acft Corp Of Texas M20E · Seligman, AZThe pilot's failure to maintain clearance from terrain while maneuvering. Contributing to the accident was the pilot's inadequate preflight and in-flight planning.Nov 1, 2010 · N9614V · Substantial damageNTSB WPR11CA035Accident · No injuriesData collectionFinal reportCessna 172S · Branscomb, CAThe pilot's failure to maintain clearance from trees during the landing roll on an unimproved airstrip.Nov 1, 2010 · N3542V · Substantial damageNTSB CEN11CA121Accident · No injuriesData collectionFinal reportPiper J3C-65 · Cypress, TXThe pilot's failure to maintain directional control of the airplane during landing.Oct 31, 2010 · N41458 · Substantial damageNTSB ERA11FA042Accident · 1 fatalField investigationFinal reportMD Helicopters 369E · Thomas, WVThe pilot's failure to clear the helicopter and its external load from surrounding structures and his failure to execute a timely release of the external load, which resulted in an inadvertent entanglement and collision with wires and terrain. Contributing to…Oct 30, 2010 · N765WH · Substantial damageNTSB WPR11CA031Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Prescott, AZThe student pilot's failure to maintain the proper airspeed and the certificated flight instructor's inadequate supervision and delayed remedial action during a practice autorotation, which resulted in a hard landing and rollover.Oct 29, 2010 · N844SH · Substantial damageNTSB ERA11LA044Accident · No injuriesLimited investigationFinal reportBoeing 737 · Fort Lauderdale, FLThe ground service vehicle driver's depressing of the accelerator rather than the brake pedal, resulting in a collision with the airplane.Oct 29, 2010 · C-FWAQ · Substantial damageNTSB ERA11LA043Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Hilton Head Island, SCThe Pitts pilot's inadequate visual lookout and failure to maintain clearance from the Cirrus airplane.Oct 29, 2010 · N8ZT · 2 aircraft · Minor damageNTSB CEN11LA045Accident · Serious injuriesLimited investigationFinal reportWalker Kenneth Sonex · San Angelo, TXThe pilot's loss of airplane control. Contributing to the accident was the pilot's impairment due to alcohol.Oct 29, 2010 · N234KS · Substantial damageNTSB CEN11CA052Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Stockport, OHThe pilot's inadvertent movement of the throttle control during landing, which resulted in an increase in power and excursion from the runway.Oct 29, 2010 · N619CS · Substantial damage