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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB CEN11CA131Accident · No injuriesData collectionFinal reportCessna 152 · Bolingbrook, ILThe student pilot's failure to maintain directional control during landing.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CEN11CA113Accident · No injuriesData collectionFinal reportBeech 95-C55 · Ozark, ARThe pilot's failure to extend the landing gear prior to landing.NTSB 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.NTSB CEN11FA110Accident · 2 fatalField investigationFinal reportBeech B60 · Edwards, COControlled flight into terrain, while on an instrument approach in instrument meteorological conditions, for undetermined reasons.NTSB 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.NTSB ERA11LA100Accident · No injuriesLimited investigationFinal reportCessna 172 · St. ThomasThe pilot's failure to maintain an adequate visual lookout while taxiing.NTSB 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.NTSB WPR11CA077Accident · No injuriesData collectionFinal reportCessna 177 · Corona, CAThe pilot’s improper flare, which resulted in a hard landing.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ERA11LA083Accident · Minor injuriesLimited investigationFinal reportBell 206B · Isom, KYThe pilot's failure to maintain clearance from a known wire hazard during an aerial observation flight.NTSB 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.NTSB OPS11IA173Incident · No injuriesIncident investigationFinal reportBoeing 737-832 · Covington, KYThe local controller's distraction with a helicopter south of the field.NTSB WPR11CA084Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Phoenix, AZThe student pilot's failure to maintain clearance from obstacles while taxiing.NTSB 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.NTSB ERA11CA081Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Pahokee, FLThe pilot's failure to maintain control of the helicopter during takeoff.NTSB 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.NTSB CEN11CA123Accident · No injuriesData collectionFinal reportCessna 177B · Seymour, INThe pilot's failure to maintain directional control while taking off with a gusting wind.NTSB CEN11CA100Accident · No injuriesData collectionFinal reportCessna 172S · Lawrence, KSThe student pilot’s non-stabilized approach and improper landing flare, which resulted in a hard landing.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CEN11LA093Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Ponca City, OKThe pilot's loss of control during landing for undetermined reasons.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB WPR11CA065Accident · No injuriesData collectionFinal reportAviat A-1B · North Bend, WAThe pilot's failure to predetermine the depth of the snow on the runway.NTSB 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.NTSB WPR11CA066Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5B · Coalinga, CAThe pilot's failure to remove the gust lock prior to takeoff.NTSB 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.NTSB 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.NTSB CEN11CA187Accident · No injuriesData collectionFinal reportCessna 182M · Lubbock, TXThe pilot's inadequate visual lookout resulting in a collision with an airport sign.NTSB 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…NTSB WPR11CA057Accident · Minor injuriesData collectionFinal reportFlight Design Ctsw · Fullerton, CAThe pilot's improper flare during landing.NTSB 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.NTSB 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.NTSB 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.