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 ANC12CA040Accident · No injuriesData collectionFinal reportCessna T210L · Whittier, AKThe pilot’s failure use the prelanding checklist and to extend the landing gear before landing.May 20, 2012 · N732BE · Substantial damageNTSB WPR12LA218Accident · 1 fatalLimited investigationFinal reportAvia Stroitel AC-5M · Kingston, NVThe pilot's failure to maintain control of the glider while maneuvering in flight.May 19, 2012 · N186P · Substantial damageNTSB WPR12LA217Accident · Serious injuriesLimited investigationFinal reportJackson TOP DOG · Apple Valley, CAA loss of engine power during the initial climb for reasons that could not be determined because the anomalies revealed during the postaccident examination would not have necessarily precluded normal operation. Contributing to the accident was the inadequate…May 19, 2012 · N214AB · Substantial damageNTSB ERA12LA360Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Kingston, NYThe pilot’s failure to maintain adequate clearance from trees/foliage at an undetermined point during the flight.May 19, 2012 · N6236C · Substantial damageNTSB ERA12LA346Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Destin, FLThe partial loss of engine power due to a stuck (open) exhaust valve in the No. 5 cylinder. Contributing to the accident was the operator’s failure to follow the engine manufacturer’s directives concerning cooling of the engine after flight.May 19, 2012 · N444WT · Substantial damageNTSB ERA12CA357Accident · No injuriesData collectionFinal reportHughes TH-55 · Pittsfield, PAThe student pilot's failure to maintain helicopter control during an encounter with loss of tail rotor effectiveness.May 19, 2012 · N74914 · Substantial damageNTSB ERA12CA350Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Norwich, NYThe pilot's inability to maintain directional control during a landing with a deflated left main landing gear tire.May 19, 2012 · N3956P · Substantial damageNTSB ERA12CA348Accident · Minor injuriesData collectionFinal reportMooney M20C · Pembroke Pines, FLThe pilot's improper fuel management, which resulted in a total loss of engine power during approach due to fuel exhaustion.May 19, 2012 · N2610W · Substantial damageNTSB ERA12CA344Accident · No injuriesData collectionFinal reportCessna 170B · Winterville, NCThe pilot's excessive bank at low altitude, which resulted in an aerodynamic stall.May 19, 2012 · N170ED · Substantial damageNTSB CEN12LA310Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Humnoke, ARThe pilot’s failure to attain the proper touchdown point, which resulted in a landing undershoot.May 19, 2012 · N85239 · Substantial damageNTSB CEN12LA307Accident · 1 fatalLimited investigationFinal reportDial David L Titan Tornado II · Checotah, OKThe noncertificated pilot's loss of airplane control while maneuvering during initial climb, which resulted in an aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s ostentatious display.May 19, 2012 · N158TX · Substantial damageNTSB ERA12CA352Accident · Serious injuriesData collectionFinal reportSchempp-Hirth Ventus 2CT · Duncansville, PAThe glider’s encounter with atmospheric lift conditions not sufficient to clear terrain, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to continue turning toward a ridgeline.May 18, 2012 · N900BM · Substantial damageNTSB DCA12FA076Accident · 1 fatalField investigationFinal reportHawker Hawker Hunter MK.58A · Point Mugu, CAthe pilot's decision to continue the flight with a known fuel imbalance condition that resulted in a loss of lateral control when the imbalance exceeded the known capabilities of the airplane. The fuel imbalance was due to incomplete refueling and an…May 18, 2012 · N329AX · DestroyedNTSB WPR12LA214Accident · Serious injuriesLimited investigationFinal reportMarley Kolb Firestar II · Cedar Fort, UTThe pilot's failure to maintain airplane control while on approach for landing in gusting wind conditions.May 17, 2012 · N9173T · Substantial damageNTSB WPR12CA213Accident · No injuriesData collectionFinal reportRotherwick HR Glasair III · Darby, MTThe pilot’s loss of directional control during an emergency landing on a paved highway.May 17, 2012 · N471B · Substantial damageNTSB ERA12CA342Accident · No injuriesData collectionFinal reportPiper PA46 · Springfield, VTThe pilot's failure to maintain directional control while landing in gusting wind conditions.May 17, 2012 · N630TG · Substantial damageNTSB ERA12CA341Accident · Minor injuriesData collectionFinal reportCzech Sport Aircraft A S Sportcruiser · Shirley, NYThe pilot's failure to maintain airplane control after the cockpit canopy opened during the takeoff climb. Contributing to the accident was the pilot’s failure to securely lock the canopy before takeoff.May 17, 2012 · N297SC · Substantial damageNTSB CEN12LA335Accident · No injuriesLimited investigationFinal reportShort Bros Shorts SD3-60 · Houston, TXThe pilots’ improper decision to burn fuel during the taxi by operating the engines at a higher-than-normal power setting and using the wheel brakes to control taxi speed, which resulted in a wheel fire.May 17, 2012 · N617FB · Substantial damageNTSB ERA12CA339Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Gulf Shores, ALThe pilot's inadvertent application of the wheel brakes immediately after landing, which resulted in the airplane nosing over.May 16, 2012 · N86917 · Substantial damageNTSB WPR12CA206Accident · No injuriesData collectionFinal reportHunter A-20 Vista Cruiser · Molalla, ORThe pilot's failure to maintain clearance from a rock during an off-airport landing.May 14, 2012 · N9027M · Substantial damageNTSB CEN12LA304Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · El Dorado, KSThe pilot's loss of directional control during landing, which resulted in a runway excursion.May 14, 2012 · N68543 · Substantial damageNTSB CEN12LA302Accident · Serious injuriesLimited investigationFinal reportTroyer Kitfox 3 · Elm Creek, NEThe pilot’s failure to verify the amount of oil in the injection oil reservoir before takeoff, which resulted in an insufficient fuel/oil ratio and subsequent loss of engine power.May 14, 2012 · N7199T · Substantial damageNTSB CEN12LA299Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Shawnee, OKThe improper installation of the mixture cable by maintenance personnel, which allowed the mixture cable to entangle with the landing gear during gear extension and led to the subsequent loss of engine power.May 14, 2012 · N7171P · Substantial damageNTSB ANC12CA039Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Talkeetna, AKThe pilot's failure to maintain directional control of the tailwheel-equipped airplane during landing, which resulted in a ground loop. Contributing to the accident was the flight instructor's failure to adequately monitor the landing.May 14, 2012 · N7257D · Substantial damageNTSB WPR12LA212Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Hillsboro, ORThe flight instructor's improper decision to take off from a hover with low rotor rpm.May 13, 2012 · N61482 · Substantial damageNTSB WPR12LA211Accident · No injuriesLimited investigationFinal reportBeech F33A · Mobile, AZThe student pilot's failure to maintain directional control during takeoff.May 13, 2012 · N5521A · Substantial damageNTSB WPR12FA203Accident · 1 fatalField investigationFinal reportM Squared Breese · Whitewater, CAThe pilot’s decision to fly at low altitude in mountainous terrain in the presence of strong wind and turbulence, which resulted in an aerodynamic upset at too low an altitude for recovery.May 13, 2012 · N51336 · Substantial damageNTSB ERA12LA335Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · South Canaan, PAThe pilot's delayed decision to abort the takeoff during shifting wind conditions.May 13, 2012 · N98568 · Substantial damageNTSB ERA12LA332Accident · Serious injuriesLimited investigationFinal reportStinson SR-7B · West Ossipee, NHThe pilot's inadequate application of carburetor heat which resulted in the formation of carburetor ice and a partial loss of engine power.May 13, 2012 · N16122 · Substantial damageNTSB CEN12CA294Accident · Serious injuriesData collectionFinal reportBeckert Bruce A RV-6 · Au Gres, MIThe pilot’s low altitude maneuvering, which resulted in an inadvertent stall and subsequent impact with the water.May 13, 2012 · N212LB · Substantial damageNTSB ANC12CA047Accident · No injuriesData collectionFinal reportMaule M-4-220C · Sterling, AKThe pilot's failure to use a preflight checklist and subsequent failure to turn on the airplane's fuel supply, which resulted in a loss of engine power due to fuel starvation.May 13, 2012 · N615SD · Substantial damageNTSB WPR12LA252Accident · No injuriesLimited investigationFinal reportStaudacher Hydroplanes S300X · Ephrata, WAThe pilot’s inadequate landing flare, which resulted in a bounced landing and subsequent loss of directional control.May 12, 2012 · N336JS · Substantial damageNTSB WPR12LA200Accident · No injuriesLimited investigationFinal reportChampion 7GC · Rexburg, IDA decrease in indicated oil pressure while maneuvering at low altitude for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Also causal was the pilot’s failure to…May 12, 2012 · N4861E · Substantial damageNTSB WPR12CA202Accident · No injuriesData collectionFinal reportPiper PA-12 · Idaho Falls, IDThe pilot’s improper landing flare, inadequate recovery from a bounced landing, and subsequent failure to maintain directional control.May 12, 2012 · N278JB · Substantial damageNTSB ERA12LA336Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Erwin, NCThe partial loss of engine power shortly after takeoff due to fatigue-fractured exhaust valve springs. Contributing to the accident was the mechanic’s decision to install exhaust valve springs with an unknown service history in the engine’s No. 4 cylinder.May 12, 2012 · N2WZ · Substantial damageNTSB ERA12CA382Accident · No injuriesData collectionFinal reportBeech B90 · Savannah, GAThe pilot's failure to maintain adequate visual lookout while taxiing near a hangar, which resulted in airplane's right wingtip impacting the hangar door.May 12, 2012 · N275LE · Substantial damageNTSB ERA12CA333Accident · Minor injuriesData collectionFinal reportLuttenbacher Kurt Bushby Mustang 2 · Kingstree, SCThe pilot’s failure to maintain airplane control during the approach to landing, which resulted in a collision with terrain short of the runway. Contributing to the accident was the pilot's lack of experience in the airplane.May 12, 2012 · N58RS · Substantial damageNTSB CEN12LA339Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Applegate, MIThe pilot’s decision to attempt to take off from an unimproved field, which resulted in a collapsed nose landing gear.May 12, 2012 · N4727S · Substantial damageNTSB CEN12CA303Accident · No injuriesData collectionFinal reportCessna 182S · Houston, TXThe student pilot’s failure to maintain directional control during the landing roll. Contributing to the accident was the student pilot’s interference with the flight instructor’s attempted remedial actions.May 12, 2012 · N703MM · Substantial damageNTSB CEN12CA292Accident · No injuriesData collectionFinal reportRisher Jimmy E Vans Aircraft RV-8 · Pecos, TXThe pilot's failure to maintain directional control while landing with a crosswind.May 12, 2012 · N811JR · Substantial damageNTSB WPR12LA205Accident · Serious injuriesLimited investigationFinal reportInfinity 2000 · Hurricane, UTThe pilot's decision to fly at a low altitude in a canyon, which resulted in insufficient altitude to recover from an encounter with terrain-induced turbulence.May 11, 2012 · N541KP · Substantial damageNTSB ERA12CA334Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Weirsdale, FLThe pilot's failure to maintain directional control while landing in a gusty variable crosswind.May 11, 2012 · N71327 · Substantial damageNTSB ERA12CA330Accident · No injuriesData collectionFinal reportCessna 172R · Immokalee, FLThe student pilot’s failure to maintain directional control during a touch-and-go landing.May 11, 2012 · N5253B · Substantial damageNTSB CEN12FA290Accident · 4 fatalField investigationFinal reportCessna 401 · Chanute, KSThe malfunction of the cabin heater, which resulted in an inflight fire and smoke in the airplane. Contributing to the accident was the pilot’s lack of understanding concerning the status of the airplane's heater system following and earlier overheat event…May 11, 2012 · N9DM · Substantial damageNTSB WPR12TA445Accident · No injuriesFinal reportBeech C90 · Boise, IDExcessive loading on the left wing, which occurred over a period of time. Contributing to the accident was maintenance personnel’s failure to adequately inspect and document the left wing damage.May 10, 2012 · N14CP · Substantial damageNTSB ERA12FA327Accident · 2 fatalField investigationFinal reportMooney M20J · Sterling, PAThe pilot’s decision to take off on an uphill slope without utilizing the entire available runway, and his failure to abort the takeoff when he realized he wasn’t going to liftoff in time to clear the trees at the end of the runway.May 10, 2012 · N9154K · Substantial damageNTSB DCA12FA069Accident · Serious injuriesField investigationFinal reportAirbus A319-112 · Fort Lauderdale, FLan inadvertent encounter with convectively induced turbulence developing upwards into the flight path, which was not detected on weather radar as configured by the crew. Contributing to the delay in emergency medical personnel notification was the incomplete…May 10, 2012 · N951FR · No damageNTSB CEN12LA289Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Grants, NMThe loss of engine power due to an excessively rich fuel mixture that occurred during operations at idle power settings at a high density altitude. Contributing to the accident was the flight instructor’s poor decision-making in choosing to practice an…May 10, 2012 · N7523S · Substantial damageNTSB CEN12CA286Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2006T · Cleburne, TXThe pilot's inadvertent selection of flap 0 degrees during the go-around and the flight instructor’s inadequate supervision, which resulted in an aerodynamic stall at low altitude.May 10, 2012 · N727TA · Substantial damageNTSB ANC12CA037Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Gakona, AKThe pilot’s decision to take off in variable wind conditions, which resulted in a loss of control and the airplane striking an object after takeoff.May 10, 2012 · N999JV · Substantial damage