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 CEN11CA624Accident · No injuriesData collectionFinal reportCessna 172S · Bemidji, MNThe student pilot's improper flare, which resulted in a hard landing.Sep 5, 2011 · N548ND · Substantial damageNTSB ANC11CA097Accident · No injuriesData collectionFinal reportPiper PA-12 · Anchorage, AKThe pilot's misidentification of the runway environment in dusk light conditions.Sep 5, 2011 · N3654M · Substantial damageNTSB ANC11CA095Accident · No injuriesData collectionFinal reportCessna 170A · Anchorage, AKThe fracture of a hydraulic brake line fitting due to incorrect installation of the brake line by the pilot/owner, which resulted in a loss of brake pressure and subsequent loss of directional control during the landing roll.Sep 5, 2011 · N5406C · Substantial damageNTSB ANC11CA094Accident · No injuriesData collectionFinal reportPiper PA-12 · North Pole, AKThe pilot's failure to maintain adequate airspeed during takeoff, resulting in an aerodynamic stall and collision with the water.Sep 5, 2011 · N78463 · Substantial damageNTSB WPR11LA471Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Phoenix, AZThe pilot's improper flare and hard landing, which resulted in the failure of the nose landing gear drag link in overstress.Sep 4, 2011 · N316PA · Substantial damageNTSB WPR11GA431Accident · Minor injuriesFinal reportBell 205 · Tehachapi, CAThe pilot's inability to adequately execute an emergency autorotation due to the flight's low altitude during external load operations, which resulted in a hard landing. Contributing to the accident was a torsionally overstressed tachometer shaft, which sent…Sep 4, 2011 · N205WW · Substantial damageNTSB WPR11FA430Accident · 2 fatalField investigationFinal reportCessna P210 · Tehachapi, CAThe pilot’s intentional low-altitude maneuvering and failure to maintain clearance from terrain due to distraction.Sep 4, 2011 · N7WJ · DestroyedNTSB WPR11FA429Accident · 1 fatalField investigationFinal reportBrewster LONG-EZ · Kanab, UTThe pilot's loss of airplane control during cruise flight.Sep 4, 2011 · N9DZ · Substantial damageNTSB WPR11FA428Accident · 2 fatalField investigationFinal reportVeatch Kitfox · Caldwell, IDThe pilot’s failure to prevent a low-altitude stall and spin following a complete loss of engine power during the initial climb after takeoff.Sep 4, 2011 · N624JS · Substantial damageNTSB WPR11CA432Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Lancaster, CAThe student pilot’s inadequate flare resulting in a hard landing. Contributing to the accident was the certified flight instructor's inadequate supervision.Sep 4, 2011 · N43220 · Substantial damageNTSB ERA11LA484Accident · No injuriesLimited investigationFinal reportNorth American TB-25N · Georgetown, DEMaintenance personnel's inadequate examination of the main landing gear during the airplane’s most recent conditional inspection, which resulted in the fatigue failure of the right main landing gear shock strut drag arm during the landing roll.Sep 4, 2011 · N9079Z · Substantial damageNTSB CEN11FA616Accident · 2 fatalField investigationFinal reportLarson Ken W Christen EAGLE-II · Seward, NEThe pilot’s inadvertent pulling of the mixture control lever on takeoff, which shut down the engine.Sep 4, 2011 · N88CE · Substantial damageNTSB CEN11CA677Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Monte Vista, COThe student pilot's loss of control while landing, which resulted in a ground loop.Sep 4, 2011 · N5934Z · Substantial damageNTSB ANC11FA093Accident · Serious injuriesField investigationFinal reportPiper PA-18-150 · McGrath, AKThe pilot inadvertently switched off the engine magnetos during short final approach, which resulted in a loss of engine power. Contributing to the accident was the manufacturer's placement of the magneto switches in the cabin.Sep 4, 2011 · N13973 · Substantial damageNTSB ANC11CA092Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Deadhorse, AKThe pilot's continued visual flight into instrument meteorological conditions.Sep 4, 2011 · N83283 · Substantial damageNTSB WPR11LA427Accident · No injuriesLimited investigationFinal reportStinson V77 · Tillamook, ORThe pilot’s loss of directional control while taxiing in a gusting tailwind.Sep 3, 2011 · N9112H · Substantial damageNTSB WPR11FA426Accident · Serious injuriesField investigationFinal reportEnstrom 280FX · Heber City, UTThe pilot’s failure to ensure that there was sufficient fuel onboard to conduct the flight, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the severity of the passengers’ injuries was the operator’s failure to provide…Sep 3, 2011 · N280AD · Substantial damageNTSB WPR11CA433Accident · No injuriesData collectionFinal reportSherman Craig W Glasair III · Kanab, UTThe pilot’s failure to maintain directional control during the landing roll, as a result of a flat left main landing gear tire.Sep 3, 2011 · N17S · Substantial damageNTSB WPR11CA425Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Gerlach, NVThe pilot’s decision to land at an unknown off-airport location.Sep 3, 2011 · N7303W · Substantial damageNTSB ERA11LA481Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · St. Petersburg, FLThe commercial pilot's improper recovery from a practice autorotation, resulting in a tailboom strike and subsequent rollover.Sep 3, 2011 · N7197W · Substantial damageNTSB CEN11CA689Accident · Minor injuriesData collectionFinal reportPiper J3L-65 · Gainesville, TXThe pilot’s failure to maintain directional control during taxi, which resulted in a runway excursion.Sep 3, 2011 · N30950 · Substantial damageNTSB CEN11CA684Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Fort Worth, TXThe certified flight instructor’s improper flare during a simulated emergency landing.Sep 3, 2011 · N242BC · Substantial damageNTSB WPR11FA424Accident · Serious injuriesField investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Lakeport, CAThe pilot's decision to continue the takeoff with reduced engine power, which resulted in a collision with terrain during the takeoff initial climb. Contributing to the accident was the partial loss of engine power for reasons that could not be determined…Sep 2, 2011 · N80033 · Substantial damageNTSB WPR11CA422Accident · No injuriesData collectionFinal reportAir Creation Clipper 582S · Enumclaw, WAThe pilot’s failure to maintain directional control during landing.Sep 2, 2011 · N5099A · Substantial damageNTSB ANC11FA091Accident · 1 fatalField investigationFinal reportCessna 208B · Nightmute, AKThe failure of the pilot of the other airplane to maintain adequate clearance while performing an unexpected and unannounced abrupt maneuver, resulting in a midair collision between the two airplanes.Sep 2, 2011 · N207DR · 2 aircraft · DestroyedNTSB ERA11FA480Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Provincetown, MAThe pilot’s failure to maintain adequate clearance from trees and terrain during the initial climb. Contributing was spatial disorientation due to a vestibular illusion and the pilot’s likely impairment due to alcohol consumption.Sep 1, 2011 · N6249C · DestroyedNTSB ERA11CA500Accident · Minor injuriesData collectionFinal reportSpectrum RX 550 · Hartland, MEA total loss of engine power due to fuel contamination.Sep 1, 2011 · UNREG · Substantial damageNTSB CEN11LA614Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Valparaiso, INThe pilot’s loss of directional control during landing. Contributing to the accident was the wear in the tailwheel assembly.Sep 1, 2011 · N83533 · Substantial damageNTSB CEN11IA615Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Baton Rouge, LAThe improperly installed upper attachment bolt in the left main landing gear uplock assembly, which led to the failure of the left main landing gear to extend before landing. Contributing to the accident was maintenance personnel's lack of training on the…Sep 1, 2011 · N875AS · Minor damageNTSB CEN11CA670Accident · No injuriesData collectionFinal reportCessna 140 · Conroe, TXThe pilot's excessive use of brakes during the landing.Sep 1, 2011 · N76521 · Substantial damageNTSB CEN11CA613Accident · Minor injuriesData collectionFinal reportTaylorcraft DCO-65 · Higginsville, MOThe pilot's failure to maintain directional control during landing and his failure to maintain clearance from trees during the attempted aborted landing.Sep 1, 2011 · N46112 · Substantial damageNTSB WPR11CA419Accident · Minor injuriesData collectionFinal reportCessna TU206F · Bremerton, WAThe total loss of engine power as a result of fuel exhaustion due to the pilot's inadequate in-flight planning.Aug 31, 2011 · N338F · Substantial damageNTSB ERA11LA489Accident · No injuriesLimited investigationFinal reportCessna 172N · Plymouth, MAThe pilot's inadequate flare and improper recovery from a bounced landing.Aug 31, 2011 · N739RU · Substantial damageNTSB ERA11CA517Accident · No injuriesData collectionFinal reportFantasy Air Sro Allegro 2000 · Stonington, METhe pilot's inadequate landing flare, which resulted in a hard landing during crosswind conditions.Aug 31, 2011 · N90650 · Substantial damageNTSB CEN11CA660Accident · No injuriesData collectionFinal reportCessna 175 · Sugar Creek, OHThe pilot's delayed application of carburetor heat while operating in conditions conducive to carburetor icing.Aug 31, 2011 · N7103M · Substantial damageNTSB CEN11CA611Accident · No injuriesData collectionFinal reportPiper L-21B · East Liverpool, OHThe pilot's failure to maintain directional control of the airplane during landing.Aug 31, 2011 · N10365 · Substantial damageNTSB WPR11CA418Accident · Minor injuriesData collectionFinal reportChristen Industries A-1 · Dorris, CAThe pilot’s failure to maintain lateral aircraft control while taking off with a gusting crosswind.Aug 30, 2011 · N2868A · Substantial damageNTSB CEN11CA609Accident · Minor injuriesData collectionFinal reportMooney M20C · Allen, OKA total loss of engine power in flight due to fuel starvation as a result of the pilot’s inadequate fuel management.Aug 30, 2011 · N5501Q · Substantial damageNTSB ANC11CA089Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Cape Yakataga, AKThe pilot inadvertently switching off the engine magnetos during the initial climb, resulting in a loss of engine power. Contributing to the accident was the manufacturer's placement of the magneto switches.Aug 30, 2011 · N82448 · Substantial damageNTSB WPR11FA415Accident · Serious injuriesField investigationFinal reportCessna 172M · Santa Monica, CAThe student pilot’s misjudged approach and landing attempt. Contributing to the accident was a lack of airspeed due to a blocked pitot tube.Aug 29, 2011 · N5155Q · Substantial damageNTSB WPR11CA414Accident · No injuriesData collectionFinal reportMaule M-6-235 · Hailey, IDThe pilot’s failure to maintain directional control during the landing rollout in a gusty, crosswind condition.Aug 29, 2011 · N6140B · Substantial damageNTSB WPR11CA413Accident · Minor injuriesData collectionFinal reportCessna 172F · Atlanta, IDThe pilot’s misjudgment of his final approach path. Contributing to the accident was the pilot’s inadequate preflight planning.Aug 29, 2011 · N8698U · Substantial damageNTSB CEN11LA601Accident · Minor injuriesLimited investigationFinal reportVan's RV-12 · Windom, MNThe pilot's loss of airplane control after liftoff due to his distraction with the unsecured canopy, which he did not lock before takeoff.Aug 29, 2011 · N73712 · Substantial damageNTSB CEN11CA638Accident · No injuriesData collectionFinal reportEnstrom F-28F · Menominee, MIThe pilot's failure to maintain control of the helicopter during a hover.Aug 29, 2011 · N228F · Substantial damageNTSB CEN11CA604Accident · No injuriesData collectionFinal reportCessna 172M · Plymouth, MIThe pilot's failure to perform a go-around when the airplane was not in a position to make a safe landing and his excessive use of bank control during the landing attempt, which resulted in the wing striking the ground.Aug 29, 2011 · N172LD · Substantial damageNTSB WPR11LA412Accident · No injuriesLimited investigationFinal reportWheeler Vans RV-6A · Albany, ORThe in-flight separation of a propeller blade due to fatigue.Aug 28, 2011 · N642DW · Substantial damageNTSB WPR11LA410Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Napa, CAThe pilot’s mismanagement of the fuel supply, which resulted in a loss of engine power due to fuel starvation.Aug 28, 2011 · N6052W · Substantial damageNTSB WPR11CA411Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-32 · Warner Springs, CAThe pilot’s inadequate altitude to clear a ridgeline while maneuvering over a mountainous area.Aug 28, 2011 · N5840V · Substantial damageNTSB WPR11CA409Accident · Serious injuriesData collectionFinal reportCessna 170A · Grangeville, IDThe pilot's loss of directional control for undetermined reasons.Aug 28, 2011 · N1238D · Substantial damageNTSB CEN11LA688Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Berryville, TXThe pilot did not maintain control of the airplane during a forced landing, which resulted in an aerodynamic stall. Contributing to the accident was the loss of engine power for undetermined reasons.Aug 28, 2011 · N8617 · Substantial damage