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 WPR11FA078Accident · 1 fatalField investigationFinal reportAero Commander 680FL · Perris, CAThe pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain.Dec 20, 2010 · N316KW · Substantial damageNTSB CEN11CA131Accident · No injuriesData collectionFinal reportCessna 152 · Bolingbrook, ILThe student pilot's failure to maintain directional control during landing.Dec 19, 2010 · N5437M · Substantial damageNTSB ERA11LA093Accident · Serious injuriesLimited investigationFinal reportCessna 182 · West Milford, NJThe pilot's delayed application of carburetor heat while taking off in weather conditions conducive to serious carburetor icing, which resulted in a partial loss of engine power.Dec 18, 2010 · N1462M · Substantial damageNTSB DCA11CA014Accident · No injuriesData collectionFinal reportBoeing 737-7H4 · Philadelphia, PAthe failure of the ground operations personnel to maintain awareness of the relative position of the two airplanes.Dec 18, 2010 · N913WN · 2 aircraft · Substantial damageNTSB CEN11LA148Accident · No injuriesLimited investigationFinal reportBeech H35 · Des Moines, IAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Dec 18, 2010 · N5537D · Substantial damageNTSB CEN11LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-350P · Lake Elmo, MNThe pilot's improper fuel management which resulted in the loss of engine power due to fuel starvation. Contributing to the accident was the distraction of the cabin depressurization.Dec 18, 2010 · N92358 · Substantial damageNTSB CEN11CA113Accident · No injuriesData collectionFinal reportBeech 95-C55 · Ozark, ARThe pilot's failure to extend the landing gear prior to landing.Dec 17, 2010 · N990W · Substantial damageNTSB CEN11LA109Accident · Minor injuriesLimited investigationFinal reportCessna T182T · Moline, ILThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and noseover.Dec 16, 2010 · N2187H · Substantial damageNTSB CEN11FA110Accident · 2 fatalField investigationFinal reportBeech B60 · Edwards, COControlled flight into terrain, while on an instrument approach in instrument meteorological conditions, for undetermined reasons.Dec 15, 2010 · N571M · Substantial damageNTSB WPR11LA076Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-65 · College Place, WAThe pilot's failure to abort the landing when he lost sight of the runway due to sun glare, and his inadequate compensation for the crosswind.Dec 13, 2010 · N36041 · Substantial damageNTSB ERA11LA100Accident · No injuriesLimited investigationFinal reportCessna 172 · St. ThomasThe pilot's failure to maintain an adequate visual lookout while taxiing.Dec 13, 2010 · N1348L · Substantial damageNTSB ERA11FA085Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 40 · Pearlington, MSThe pilot’s controlled flight into terrain likely due to spatial disorientation, while flying over sparsely lighted terrain at night.Dec 13, 2010 · N361DS · Substantial damageNTSB WPR11CA077Accident · No injuriesData collectionFinal reportCessna 177 · Corona, CAThe pilot’s improper flare, which resulted in a hard landing.Dec 12, 2010 · N2262Y · Substantial damageNTSB WPR11LA075Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Chino, CAThe student pilot's failure to properly position the flaps for the takeoff, failure to maintain airplane control during the procedure, and the flight instructor's delayed remedial action.Dec 11, 2010 · N4326H · Substantial damageNTSB ERA11LA084Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Rochester, NHThe out-of-rig condition of the tailwheel lock, which resulted in a loss of directional control on landing.Dec 11, 2010 · N2053E · Substantial damageNTSB ERA11CA087Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1-23D · Aberdeen, MDThe pilot's loss of control during an intentional aerobatic maneuver (spin) resulting in a collision with trees.Dec 11, 2010 · N91896 · Substantial damageNTSB CEN11CA122Accident · No injuriesData collectionFinal reportCessna 170B · Houston, TXThe pilot's failure to maintain directional control during landing. Contributing to the accident was the flight instructor's delayed remedial action.Dec 11, 2010 · N1634D · Substantial damageNTSB ERA11LA083Accident · Minor injuriesLimited investigationFinal reportBell 206B · Isom, KYThe pilot's failure to maintain clearance from a known wire hazard during an aerial observation flight.Dec 10, 2010 · N263CH · Substantial damageNTSB CEN11LA120Accident · No injuriesLimited investigationFinal reportBeech 300 · Minneapolis, MNThe pilot's failure to follow the aircraft checklist in locking the cabin door prior to departure which resulted in its in-flight separation.Dec 10, 2010 · N206K · Substantial damageNTSB OPS11IA173Incident · No injuriesIncident investigationFinal reportBoeing 737-832 · Covington, KYThe local controller's distraction with a helicopter south of the field.Dec 9, 2010 · N3731T · 2 aircraft · No damageNTSB WPR11CA084Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Phoenix, AZThe student pilot's failure to maintain clearance from obstacles while taxiing.Dec 8, 2010 · N418PA · Substantial damageNTSB ERA11CA082Accident · Serious injuriesData collectionFinal reportBell 206L-3 · Canal Point, FLThe pilot's failure to maintain clearance from the ground while maneuvering at a low altitude. Contributing to the accident was the pilot’s fatigue.Dec 8, 2010 · N955GT · Substantial damageNTSB ERA11CA081Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Pahokee, FLThe pilot's failure to maintain control of the helicopter during takeoff.Dec 8, 2010 · N666SL · Substantial damageNTSB ERA11CA080Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Canal Point, FLPilot fatigue due to lack of sleep resulting in incapacitation (falling asleep) and ground contact while maneuvering at a low altitude.Dec 8, 2010 · N451DB · Substantial damageNTSB CEN11CA123Accident · No injuriesData collectionFinal reportCessna 177B · Seymour, INThe pilot's failure to maintain directional control while taking off with a gusting wind.Dec 7, 2010 · N888VM · Substantial damageNTSB CEN11CA100Accident · No injuriesData collectionFinal reportCessna 172S · Lawrence, KSThe student pilot’s non-stabilized approach and improper landing flare, which resulted in a hard landing.Dec 7, 2010 · N99HV · Substantial damageNTSB WPR11FA073Accident · Serious injuriesField investigationFinal reportCessna T210M · Ogden, UTThe pilot did not maintain clearance from obstacles after descending below the published approach decision height when visibility was less than published approach minimums due to heavy ground fog and he did not execute a missed approach after failing to…Dec 6, 2010 · N77CF · Substantial damageNTSB ERA11FA078Accident · 2 fatalField investigationFinal reportCessna U206G · Leverett, MAA total loss of engine power due to the fatigue failure of the crankshaft, which resulted from improper tightening of the cylinder hold-down nuts.Dec 5, 2010 · N9742Z · Substantial damageNTSB CEN11LA099Accident · No injuriesLimited investigationFinal reportBoeing 747-47UF · Chicago, ILThe Boeing 747 first officer’s failure to maintain clearance from another airplane while taxiing due to his inadequate judgment of the distance between the airplanes.Dec 5, 2010 · N499MC · 2 aircraft · Minor damageNTSB WPR11CA072Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Pullman, WAThe pilot's delayed application of carburetor heat while maneuvering, which resulted in a partial loss of engine power.Dec 4, 2010 · N4100Z · Substantial damageNTSB ERA11IA091Incident · No injuriesIncident investigationFinal reportEurocopter Deutschland MBB-BK 117 C-1 · Boston, MAImproper installation of wiring associated with a medical cabinet interior, which resulted in chafing and a subsequent in-flight fire. Contributing to the incident was inadequate maintenance procedures for continued airworthiness.Dec 4, 2010 · N271NE · Minor damageNTSB CEN11LA093Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Ponca City, OKThe pilot's loss of control during landing for undetermined reasons.Dec 4, 2010 · N8320R · Substantial damageNTSB CEN11CA098Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Gregory, ARThe pilot’s inadequate preflight inspection and failure to detect water contaminated fuel, which resulted in a loss of engine power during takeoff.Dec 2, 2010 · N9145H · Substantial damageNTSB WPR11LA068Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-65 · Madras, ORThe failure of both pilots to see and avoid the other airplane while in the traffic pattern to land, which resulted in a midair collision.Dec 1, 2010 · N23619 · 2 aircraft · Minor damageNTSB WPR11LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-181 · Wittmann, AZThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Dec 1, 2010 · N4122F · Substantial damageNTSB ERA11FA074Accident · 1 fatalField investigationFinal reportBeech A36 · Theodore, ALThe pilot's failure to maintain aircraft control while maneuvering at night in deteriorating weather conditions due to spatial disorientation. Contributing to the accident was the pilot's failure to obtain a weather briefing.Nov 30, 2010 · N1860P · Substantial damageNTSB CEN11LA086Accident · 1 fatalLimited investigationFinal reportMaule M-5-180C · Emory, TXThe pilot's loss of control and failure to attain/maintain adequate airspeed during an attempted go-around after a hard bounced landing, resulting in an aerodynamic stall. Contributing to the accident was the pilot’s recent minimal experience in airplane…Nov 30, 2010 · N244RC · DestroyedNTSB WPR11LA064Accident · 1 fatalLimited investigationFinal reportKennedy Lancair 320 · Hubbard, ORThe loss of control during takeoff for undetermined reasons. Contributing to the accident was the pilot's impairment from an over-the-counter sedating medication.Nov 29, 2010 · N42BK · Substantial damageNTSB ERA11CA092Accident · No injuriesData collectionFinal reportHaeussler Ray Sonex · Buffalo, NYThe pilot's failure to maintain directional control during takeoff due to his abrupt advancing of the throttle.Nov 29, 2010 · N469SA · Substantial damageNTSB WPR11CA065Accident · No injuriesData collectionFinal reportAviat A-1B · North Bend, WAThe pilot's failure to predetermine the depth of the snow on the runway.Nov 28, 2010 · N55HU · Substantial damageNTSB CEN11LA084Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Navada, TXThe loss of engine power due to debris obstructing the fuel filter, which resulted in fuel starvation. Contributing to the accident was the pilot's inadequate airspeed during the forced landing, which resulted in an aerodynamic stall.Nov 27, 2010 · N4541L · Substantial damageNTSB WPR11CA066Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5B · Coalinga, CAThe pilot's failure to remove the gust lock prior to takeoff.Nov 26, 2010 · N74400 · Substantial damageNTSB WPR11CA060Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A Twin II Acro · Warner Springs, CAThe certified flight instructor's inadequate compensation for the crosswind and delayed remedial action during landing, which resulted in a ground loop.Nov 26, 2010 · N855BG · Substantial damageNTSB WPR11FA059Accident · 1 fatalField investigationFinal reportMooney M20R · Hollister, CAThe pilot did not ensure the airplane was loaded within its weight and balance envelope, which resulted in longitudinal instability and a loss of aircraft control during the initial climb.Nov 25, 2010 · VH-PPA · Substantial damageNTSB CEN11CA187Accident · No injuriesData collectionFinal reportCessna 182M · Lubbock, TXThe pilot's inadequate visual lookout resulting in a collision with an airport sign.Nov 25, 2010 · N182DG · Substantial damageNTSB WPR11LA058Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2C10 · Salt Lake City, UTThe tug driver’s loss of airplane control during pushback due to a loss of traction in slippery conditions on the ramp. Contributing to the accident was the ground crews’ and airline operators’ inadequate guidance with regard to pushback procedures during low…Nov 24, 2010 · N614SK · Substantial damageNTSB WPR11CA057Accident · Minor injuriesData collectionFinal reportFlight Design Ctsw · Fullerton, CAThe pilot's improper flare during landing.Nov 24, 2010 · N459CT · Substantial damageNTSB ERA11FA070Accident · 3 fatalField investigationFinal reportPiper PA 46-350P · Destin, FLControlled flight into water due to the pilot's improper descent below the published minimum descent altitude.Nov 24, 2010 · N548C · Substantial damageNTSB CEN11LA082Accident · 1 fatalLimited investigationFinal reportCessna 172M · Velma, OKThe pilot’s failure to maintain control of the airplane while maneuvering, which resulted in an inadvertent stall and subsequent impact with terrain. Contributing to the accident was the pilot's relative inexperience in pipeline patrols.Nov 24, 2010 · N4428Q · DestroyedNTSB CEN11LA092Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-145LR · Madison, WIThe passenger's decision to deplane without assistance despite having a preexisting condition that limited her mobility.Nov 23, 2010 · N678AE · No damage