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 ERA18LA119Accident · 2 fatalLimited investigationFinal reportAmes Angier M LNC2 · Atlantic Ocean (Atlantic Ocean)The pilot's spatial disorientation after entering instrument meteorological conditions and encountering moderate-to-heavy precipitation, which resulted in a loss of airplane control.Mar 31, 2018 · N4ZQ · Substantial damageNTSB CEN18LA131Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Grove, OKA total loss of engine power due to carburetor ice accumulation. Contributing to the accident was the pilot’s failure to apply carburetor heat immediately following the loss of engine power.Mar 31, 2018 · N2485C · Substantial damageNTSB GAA18CA202Accident · No injuriesData collectionFinal reportCessna 182 · Nephi, UTThe pilot’s failure to maintain a proper landing flare, which resulted in a hard landing.Mar 30, 2018 · N5292N · Substantial damageNTSB GAA18CA191Accident · No injuriesData collectionFinal reportPiper PA18 · Dorris, CAThe pilot’s failure to maintain directional control during takeoff.Mar 30, 2018 · N101EB · Substantial damageNTSB GAA18CA190Accident · No injuriesData collectionFinal reportCessna 180 · Salina, CAThe pilot’s failure to maintain directional control during landing.Mar 30, 2018 · N9986N · Substantial damageNTSB GAA18CA189Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Gila Bend, AZThe pilot’s failure to properly set the parking brake, which resulted in an impact with a pole.Mar 30, 2018 · N53SL · Substantial damageNTSB GAA18CA188Accident · No injuriesData collectionFinal reportPiper J3C · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll.Mar 30, 2018 · N24751 · Substantial damageNTSB GAA18CA199Accident · No injuriesData collectionFinal reportCessna 172 · New Bedford, MAThe student pilot’s failure to maintain a proper landing flare, which resulted in a porpoised landing.Mar 29, 2018 · N803BW · Substantial damageNTSB GAA18CA187Accident · No injuriesData collectionFinal reportBeech 99 · King Salmon, AKThe pilot’s failure to maintain an adequate approach path and runway centerline during the initial landing, which resulted in a hard landing to the left of the runway and damage to the landing gear and wing.Mar 29, 2018 · N31TN · Substantial damageNTSB GAA18CA186Accident · No injuriesData collectionFinal reportTerry G. Olson Kitfox S7 Super Spor · Silver Bay, MNThe pilot’s hard landing and subsequent failure to maintain airspeed and bank control during the aborted landing, which resulted in an aerodynamic stall.Mar 29, 2018 · N141AB · Substantial damageNTSB GAA18CA185Accident · No injuriesData collectionFinal reportUltramagic N 300 · Cave Creek, AZThe balloon pilot’s decision to add heat to the envelope with a tree branch protruding into the envelope that caught fire.Mar 28, 2018 · N64EX · DestroyedNTSB ERA18LA117Accident · No injuriesClass 3 · LimitedFinal reportStanley Lancair · Sebring, FLThe failure of ground personnel to obtain permission from airport management to conduct engine test runs; adequately monitor the area behind the B737 for traffic; and install barricades to prevent access behind the running airplane, which resulted in the…Mar 28, 2018 · C-GSQQ · Substantial damageNTSB WPR18LA113Accident · 1 fatalLimited investigationFinal reportSchweizer G 164B · Stockton, CAThe pilot's failure to maintain clearance with power lines while maneuvering during an aerial application flight.Mar 27, 2018 · N3629E · Substantial damageNTSB GAA18CA183Accident · No injuriesData collectionFinal reportGlobe GC 1B · Fullerton, CAThe pilot’s failure to maintain directional control during the takeoff roll resulting impact with PAPI lighting.Mar 27, 2018 · N78244 · Substantial damageNTSB WPR18FA112Accident · 1 fatalField investigationFinal reportMooney M20E · Marina, CAThe pilot's exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall/spin.Mar 26, 2018 · N213EJ · DestroyedNTSB GAA18CA179Accident · No injuriesData collectionFinal reportLynn Perry Cavalon · Haverhill, NHThe pilot's failure to maintain directional control during a rejected takeoff. Contributing to the accident was the binding of the control stick, for an undetermined reason, which precipitated the rejected takeoff.Mar 26, 2018 · N442AG · Substantial damageNTSB ERA18FA114Accident · 2 fatalField investigationFinal reportBeech V35 · Hydro, OKThe pilot's decision to continue the night visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing was the pilot's lack of instrument/night currency, and his failure…Mar 26, 2018 · N7019N · DestroyedNTSB ANC18LA030Accident · No injuriesLimited investigationFinal reportChampion 7GC · Anchorage, AKThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a loss of control and failure of the main landing gear. Contributing to the accident was the pilot's self-induced pressure to land.Mar 26, 2018 · N4844E · Substantial damageNTSB ERA18LA116Accident · Minor injuriesClass 3 · LimitedFinal reportLindstrand Balloons 105A · Wesley Chapel, FLThe pilot's failure to maintain adequate clearance from powerlines during landing approach, which resulted in an inflight collision with the powerlines.Mar 24, 2018 · N1517H · Substantial damageNTSB GAA18CA229Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Farmingdale, NYThe student pilot’s rapid lowering of the collective, which resulted in a hard landing.Mar 23, 2018 · N72QC · Substantial damageNTSB GAA18CA178Accident · No injuriesData collectionFinal reportFlightworks Capella XS FW2C80TD · Hartselle, ALThe pilot's failure to maintain directional control during the landing roll.Mar 23, 2018 · N654MM · Substantial damageNTSB GAA18CA175Accident · Minor injuriesData collectionFinal reportCessna 172 · Beaver Falls, PAThe student pilot’s failure to maintain directional control during the landing roll.Mar 23, 2018 · N987AV · Substantial damageNTSB ERA18LA115Accident · No injuriesLimited investigationFinal reportCessna 180K · Canton, MSThe pilot's decision to land the airplane with a tailwind, which led to a runway excursion. Contributing to the pilot's decision to land with a tailwind was a partial loss of engine power due to his failure to effectively use carburetor heat in conditions…Mar 23, 2018 · N77NP · Substantial damageNTSB ERA18LA113Accident · No injuriesLimited investigationFinal reportFairchild Funk M62C F 23A · Columbia, TNThe pilot's inadvertent selection of the fuel selector handle to the off position, which resulted in fuel starvation and a total loss of engine power.Mar 23, 2018 · N1131Z · Substantial damageNTSB CEN18LA123Accident · 1 fatalLimited investigationFinal reportMills Michael S1L · Dewitt, MIThe pilot's failure to see and avoid power lines due to sun glare.Mar 22, 2018 · N197X · Substantial damageNTSB GAA18CA195Accident · No injuriesData collectionFinal reportPiper PA24 · Knox, INThe flight instructor’s improper landing flare, which resulted in a hard landing.Mar 21, 2018 · N6785P · Substantial damageNTSB ERA18LA112Accident · Serious injuriesClass 3 · LimitedFinal reportGulfstream Aerospace G V · Miami, FLThe passengers' failure to comply with the fasten seatbelt sign, with resulted in their injury during an inflight turbulence encounter.Mar 21, 2018 · N90JE · No damageNTSB CEN18LA125Accident · Minor injuriesLimited investigationFinal reportCub Crafters PA18 150 · Beggs, OKThe pilot's failure to verify that the fuel selector was properly set before takeoff, which resulted in a total loss of engine power due to fuel starvation.Mar 21, 2018 · N226JK · Substantial damageNTSB CEN18FA126Accident · 1 fatalField investigationFinal reportRans S-16 Shekari · Pierce, NEThe pilot's failure to maintain airspeed during the approach for landing, which resulted in an aerodynamic stall and the airplane's impact with terrain.Mar 21, 2018 · N741WT · Substantial damageNTSB ANC18LA027Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC 6 Twin Otter · Arctic OceanThe flight crew's improper decision to deliberately operate the airplane at low altitude and along a flightpath that resulted in a collision with a pedestrian after takeoff. Contributing to the accident was the pedestrian's proximity to the runway.Mar 21, 2018 · N716JP · Substantial damageNTSB WPR18LA111Accident · No injuriesLimited investigationFinal reportPflugradt Kitfox · Clatskanie, ORA partial loss of engine power due to an improperly secured throttle cable set screw.Mar 20, 2018 · N925DP · Substantial damageNTSB GAA18CA173Accident · No injuriesData collectionFinal reportCessna 182 · Rapid City, SDThe pilot's selection of unsuitable terrain for takeoff, which resulted in a loss of control and runway excursion.Mar 20, 2018 · N3024Y · Substantial damageNTSB GAA18CA172Accident · No injuriesData collectionFinal reportLithuanian Factory Of LAK 12 · Sunriver, ORThe glider pilot's inadequate flight planning, which resulted in an off-airport landing.Mar 20, 2018 · N63010 · Substantial damageNTSB GAA18CA170Accident · No injuriesData collectionFinal reportCessna 172 · Vernon, TXThe pilot's failure to maintain directional control while landing in gusty crosswind conditions.Mar 19, 2018 · N1103F · Substantial damageNTSB WPR18LA107Accident · Serious injuriesLimited investigationFinal reportCubcrafters CC11-160 · Browns Valley, CAThe pilot’s failure to adequately monitor the environment and maintain a sufficient altitude to avoid power lines.Mar 18, 2018 · N1951B · Substantial damageNTSB GAA18CA176Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Ontario, ORThe flight instructor's failure to maintain directional control during landing, in cross wind conditions.Mar 18, 2018 · N234RA · Substantial damageNTSB GAA18CA169Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Mammoth Lakes, CAThe pilot’s failure to maintain directional control during the landing roll in a gusting crosswind conditions, which exceeded the airplane’s maximum demonstrated crosswind and resulted in the collapse of the left main landing gear.Mar 16, 2018 · N473CC · Substantial damageNTSB GAA18CA167Accident · No injuriesData collectionFinal reportBeech C99 · Hastings, NEThe pilot's decision to land in a gusty crosswind that exceeded the airplane's maximum demonstrated crosswind and resulted in a runway excursion.Mar 16, 2018 · N213AV · Substantial damageNTSB ERA18LA111Accident · No injuriesLimited investigationFinal reportCessna 210 · Shelburne, VTThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.Mar 16, 2018 · N761DV · Substantial damageNTSB ERA18LA109Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Palatka, FLBoth pilots’ and the flight instructor’s failure to identify, see, and avoid the other airplane, which resulted in a midair collision.Mar 16, 2018 · N486DA · 2 aircraft · Substantial damageNTSB GAA18CA168Accident · Minor injuriesData collectionFinal reportHughes 269 · San Antonio, TXThe pilot’s decision to relinquish the helicopter flight controls to a non-rated passenger during a 3 ft hover.Mar 14, 2018 · N11047 · Substantial damageNTSB CEN18LA124Accident · Serious injuriesLimited investigationFinal reportWhite Thorpe T 18 · Cleburne, TXThe loss of engine power due to fuel exhaustion.Mar 14, 2018 · N118RG · Substantial damageNTSB ERA18LA103Accident · No injuriesClass 3 · LimitedFinal reportCessna T210 · Orlando, FLThe improper adjustment of the fuel pump by maintenance personnel, which resulted in an overly rich fuel/air mixture and a total loss of engine power.Mar 13, 2018 · N5382A · Substantial damageNTSB ERA18LA101Accident · No injuriesLimited investigationFinal reportPiper PA28 · Chesapeake, VAThe pilot's failure to apply carburetor heat during the approach for a touch-and-go landing, which resulted in a total loss of engine power during the subsequent takeoff.Mar 13, 2018 · N5646V · Substantial damageNTSB GAA18CA177Accident · No injuriesData collectionFinal reportCessna 152 · Snohomish, WAThe pilot’s decision to land with a tailwind and in his failure to maintain pitch control of the airplane in gusting wind conditions.Mar 12, 2018 · N6509L · Substantial damageNTSB GAA18CA166Accident · No injuriesData collectionFinal reportCessna 140 · Madison, SDThe flight instructor’s delayed aborted takeoff on a soft, wet, grass runway, which resulted in a runway overrun.Mar 12, 2018 · N2011N · Substantial damageNTSB GAA18CA161Accident · No injuriesData collectionFinal reportCessna 172 · Green Valley, AZThe pilot’s failure to maintain directional control of the airplane during landing with a tailwind.Mar 12, 2018 · N418DD · Substantial damageNTSB GAA18CA157Accident · No injuriesData collectionFinal reportCessna 182 · Rockford, ILThe pilot’s unnecessary action during the approach, which resulted in a hard landing.Mar 12, 2018 · N96772 · Substantial damageNTSB WPR18LA109Accident · Minor injuriesClass 3 · LimitedFinal reportLyons Robert Navajo HKS · Arlington, WAThe pilot's loss of directional control during landing. Contributing to the accident was the pilot's failure to attain a proper touchdown point, which required his use of heavy braking to stop on the remaining runway and exacerbated the uneven braking…Mar 11, 2018 · N1762C · Substantial damageNTSB WPR18FA104Accident · 1 fatalField investigationFinal reportPiper PA 18-150 · La Center, WAThe pilot's failure to maintain clearance from trees while maneuvering at a low altitude.Mar 11, 2018 · N4511Y · Destroyed