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 CEN12FA570Accident · 2 fatalField investigationFinal reportAmerican AA-1 · Llano, TXThe flight instructor’s delayed remedial action and inadequate supervision during practice traffic pattern work. Contributing to the accident was the flight instructor’s use of sedating medication on the day of the accident and airplane’s high angle of attack…Aug 25, 2012 · N5796L · Substantial damageNTSB CEN12CA576Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Watkins, COThe pilot did not maintain control of the airplane while landing in gusty wind conditions.Aug 25, 2012 · N215VS · Substantial damageNTSB ANC12CA092Accident · Minor injuriesData collectionFinal reportDehavilland Beaver U-6 · Kenai, AKThe pilot’s failure to maintain adequate ground clearance during his landing approach, which resulted in a collision with terrain.Aug 25, 2012 · N314HA · Substantial damageNTSB ERA12LA525Accident · No injuriesLimited investigationFinal reportCessna 152 · Ormond Beach, FLThe pilot's improper decision to take off again after a successful abort due to diminished airplane climb performance. Contributing to the accident was carburetor icing during the taxi, which resulted in the loss of engine performance.Aug 24, 2012 · N24264 · Substantial damageNTSB ERA12CA533Accident · Minor injuriesData collectionFinal reportStearman M-2 · Robbinsville, NJThe pilot's failure to maintain directional control during the landing roll.Aug 24, 2012 · N9055 · Substantial damageNTSB CEN12LA583Accident · No injuriesLimited investigationFinal reportCessna 150M · Arrow Rock, MOThe pilot's inadequate fuel management and in-flight decision making, which resulted in a total loss of engine power due to fuel exhaustion.Aug 24, 2012 · N63672 · Substantial damageNTSB CEN12FA571Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Milner, COThe student pilot's impairment from alcohol, marijuana, and hypoxia, which adversely affected his ability to maintain control of the airplane.Aug 24, 2012 · N7774P · Substantial damageNTSB CEN12CA595Accident · Minor injuriesData collectionFinal reportAeronca 11AC · Comfort, TXThe pilot did not maintain control of the airplane after takeoff, which resulted in an inadvertent stall.Aug 24, 2012 · N9771E · Substantial damageNTSB ERA12LA524Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Riverview, FLDamage to the propeller governor gasket during installation by unknown persons, which resulted in a total loss of engine oil in flight and a subsequent forced landing.Aug 23, 2012 · N362DM · Substantial damageNTSB ERA12CA531Accident · No injuriesData collectionFinal reportCessna 172P · Lyman, MSThe pilot's loss of directional control during takeoff as a result of his attempt to close an unsecured cockpit window.Aug 23, 2012 · N65747 · Substantial damageNTSB ERA12CA529Accident · No injuriesData collectionFinal reportStinson 108-2 · Winter Haven, FLThe pilot’s failure to maintain directional control during the takeoff, which resulted in a runway excursion.Aug 23, 2012 · N340C · Substantial damageNTSB ERA12CA558Accident · No injuriesData collectionFinal reportBeech 35-C33 · Burlington, NCThe pilot's improper landing flare, which resulted in a hard landing.Aug 22, 2012 · N331DP · Substantial damageNTSB ERA12CA523Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-1B · Bedford, PAThe pilot's failure to maintain control of the airplane during the landing and subsequent go-around. Contributing to the accident was the pilot's failure to shutoff the carburetor heat during the attempted go-around and the weight at which the airplane was…Aug 22, 2012 · N9858L · Substantial damageNTSB CEN12CA574Accident · No injuriesData collectionFinal reportFantasy Air Sro Allegro 2000 · Centralia, ILThe pilot’s failure to maintain directional control of the airplane during the landing roll.Aug 22, 2012 · N25015 · Substantial damageNTSB CEN12CA564Accident · Minor injuriesData collectionFinal reportCessna T210N · Boulder, COThe pilot’s decision to continue the unstable approach, which resulted in a loss of control during landing and a runway excursion.Aug 22, 2012 · N85S · Substantial damageNTSB WPR12CA368Accident · No injuriesData collectionFinal reportPiper PA-28-140 · McMinnville, ORThe pilot’s loss of directional control during the takeoff roll, which resulted in a runway excursion.Aug 21, 2012 · N8154N · Substantial damageNTSB ERA12CA521Accident · Minor injuriesData collectionFinal reportCessna 152 · Deland, FLThe pilot’s failure to maintain airplane control on final approach in gusting wind conditions. Contributing to the accident was the pilot’s decision to operate in an environment of thunderstorms and rapidly deteriorating weather.Aug 21, 2012 · N49054 · Substantial damageNTSB CEN12LA566Accident · Serious injuriesLimited investigationFinal reportThorp T-18 · Gilmer, TXThe disconnected metering unit fuel line, which resulted in a loss of engine power.Aug 21, 2012 · N2443 · Substantial damageNTSB WPR12LA365Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · McCall, IDThe flight instructor’s selection of the wrong route while flying in mountainous terrain at a high-density altitude, which resulted in the airplane impacting terrain when the increase in elevation exceeded the airplane’s climb performance.Aug 20, 2012 · N735KV · Substantial damageNTSB WPR12CA399Accident · No injuriesData collectionFinal reportCessna 182F · Hood River, ORThe pilot's improper landing flare and inadequate recovery from a bounced landing.Aug 20, 2012 · N34SR · Substantial damageNTSB WPR12CA363Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8E · Hillsboro, ORThe pilot’s improper use of the brakes during the landing roll, which resulted in a nose over.Aug 19, 2012 · N2287K · Substantial damageNTSB ERA12FA514Accident · 2 fatalField investigationFinal reportSocata TB 10 · Shirley, NYThe pilot/owner's operation of the airplane with known deficiencies, and the mechanic's failure to reattach the mixture control cable to the mixture control arm following maintenance of the carburetor.Aug 19, 2012 · N5542Z · Substantial damageNTSB ERA12CA516Accident · Serious injuriesData collectionFinal reportBeech A23-19 · West Liberty, KYThe pilot's delayed decision to abort a takeoff, which resulted in a runway excursion.Aug 19, 2012 · N4746J · Substantial damageNTSB CEN12LA642Accident · No injuriesLimited investigationFinal reportAeropro CZ A240 · Greenfield, MOThe pilot's failure to attain a proper takeoff speed or pitch attitude during takeoff, which resulted in the airplane settling on the runway and impacting trees.Aug 19, 2012 · N812S · Substantial damageNTSB CEN12LA577Accident · No injuriesLimited investigationFinal reportJones Kitfox III · Rockford, ILThe pilot's improper installation of a spark plug, which led to a partial loss of engine power after takeoff and the resultant forced landing.Aug 19, 2012 · N942EJ · Substantial damageNTSB CEN12LA565Accident · No injuriesLimited investigationFinal reportKolb MK-3 · Onondaga, MIThe noncertificated pilot's inadequate preflight planning, which resulted in landing on a runway of inadequate length and subsequent runway excursion.Aug 19, 2012 · N520SK · Substantial damageNTSB CEN12LA556Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Sidney, NEThe pilot's misuse of the brakes during landing, which resulted in the airplane nosing over.Aug 19, 2012 · N68564 · Substantial damageNTSB WPR12CA372Accident · No injuriesData collectionFinal reportBoeing B75N1 · Mesa, AZThe pilot's failure to maintain directional control while landing in a crosswind.Aug 18, 2012 · N47964 · Substantial damageNTSB ERA12TA515Accident · No injuriesFinal reportBell 206B · San Juan, PRThe crew’s inadequate preflight inspection and failure to monitor the fuel state during flight, which resulted in a total loss of engine power due to fuel exhaustion.Aug 18, 2012 · N118EC · Substantial damageNTSB ERA12FA513Accident · 1 fatalField investigationFinal reportMcleod Alan FW-190 1/2 Scale · Columbus, GAThe pilot’s failure to maintain airspeed while maneuvering following a partial loss of engine power. Contributing to the accident was the pilot’s decision not to land on the remaining runway ahead, and the partial loss of engine power due to carburetor ice.Aug 18, 2012 · N149AM · Substantial damageNTSB ERA12CA520Accident · No injuriesData collectionFinal reportFleet Fleet 16B · Bayport, NYThe pilot’s improper landing flare, which resulted in a hard landing.Aug 18, 2012 · N343SF · Substantial damageNTSB ERA12CA519Accident · No injuriesData collectionFinal reportCessna 208B · Raeford, NCThe pilot's decision to land in a grassy area next to a paved runway, which resulted in impact with a ditch and subsequent nose landing gear collapse.Aug 18, 2012 · N80GE · Substantial damageNTSB CEN12LA569Accident · No injuriesLimited investigationFinal reportPiper PA28 · Leesburg, OHThe pilot's improper preflight planning and decision to attempt a takeoff from a runway that was too short for conditions, which resulted in the airplane settling into terrain.Aug 18, 2012 · N1845J · Substantial damageNTSB ANC12CA091Accident · No injuriesData collectionFinal reportPiper PA-18A 150 · Talkeetna, AKThe pilot's decision to land on a short, wet, off-airport landing site, which resulted in a runway excursion.Aug 18, 2012 · N7863D · Substantial damageNTSB ANC12CA089Accident · No injuriesData collectionFinal reportMaule M-5-210C · Coldfoot, AKThe pilot's delayed decision to turn around while flying through a narrow mountain pass, which resulted in a forced landing and impact with terrain.Aug 18, 2012 · N319X · Substantial damageNTSB WPR12LA362Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Spanish Fork, UTThe flight instructor’s delayed remedial action and inadequate supervision during a practice autorotation, which resulted in a hard landing and rollover.Aug 17, 2012 · N208WM · Substantial damageNTSB ERA12CA517Accident · No injuriesData collectionFinal reportAir Tractor AT-402B · Gum Neck, NCThe pilot's failure to maintain airplane control during the takeoff roll. Contributing to the accident was the rough condition of the runway.Aug 17, 2012 · N5127T · Substantial damageNTSB CEN12LA558Accident · No injuriesLimited investigationFinal reportBeech A36 · Ruleton, KSThe improper installation of the wastegate controller O-ring, which resulted in a partial loss of engine power.Aug 17, 2012 · N262EA · Substantial damageNTSB CEN12LA553Accident · Minor injuriesLimited investigationFinal reportSchleicher ASG29-15M · Uvalde, TXThe glider pilot’s inadequate visual lookout and collision avoidance just after joining a thermal in which other gliders were operating, which resulted in a midair collision with another glider.Aug 17, 2012 · F-CIFB · 2 aircraft · Minor damageNTSB CEN12LA552Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Tribune, KSThe pilot's failure to maintain clearance from a corn crop.Aug 17, 2012 · N6006J · Substantial damageNTSB CEN12LA551Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Holton, KSThe mechanic's failure to adequately torque the right magneto attachment nuts, allowing the right magneto to come loose, which allowed engine oil to escape, causing the engine to seize.Aug 17, 2012 · N8546P · Substantial damageNTSB CEN12CA599Accident · No injuriesData collectionFinal reportCessna 152 · Rockford, ILA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no anomalies.Aug 17, 2012 · N152BA · Substantial damageNTSB CEN12CA598Accident · No injuriesData collectionFinal reportMooney M20E · Gresham, WIThe pilot's failure to maintain airplane control and clearance from field corn during takeoff.Aug 17, 2012 · N5642Q · Substantial damageNTSB CEN12CA568Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Bogata, TXThe pilot’s inadequate preflight planning, which resulted in the airplane’s loading beyond its maximum gross weight.Aug 17, 2012 · N6047G · Substantial damageNTSB ANC12CA090Accident · No injuriesData collectionFinal reportCessna 170B · Fairbanks, AKThe pilot's failure to maintain directional control during landing, which resulted in a ground loop and runway excursion.Aug 17, 2012 · N4551C · Substantial damageNTSB ERA12LA518Accident · No injuriesLimited investigationFinal reportMeyers OTW-160 · Worton, MDThe student pilot's improper landing flare and the flight instructor's inadequate remedial action, which resulted in a hard landing.Aug 16, 2012 · N26490 · Substantial damageNTSB WPR12CA360Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Coolin, IDThe pilot’s failure to attain a touchdown point sufficient to stop the airplane within the length of the runway.Aug 15, 2012 · N9382P · Substantial damageNTSB CEN12CA555Accident · Minor injuriesData collectionFinal reportBrown Mitch Challenger II · Dexter, MOThe operation of an airplane by a noncertificated pilot and his failure to maintain clearance from power lines during low-level flight.Aug 15, 2012 · N167MB · Substantial damageNTSB CEN12CA544Accident · Serious injuriesData collectionFinal reportSchweizer, N36289 G-164B · Kaplan, LAThe pilot's failure to maintain clearance from power lines during the aerial application flight.Aug 15, 2012 · N36289 · Substantial damageNTSB ANC12CA088Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot's loss of control during the landing roll in gusting wind conditions, which resulted in the airplane nosing over.Aug 15, 2012 · N4001Z · Substantial damage