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 ANC12CA062Accident · No injuriesData collectionFinal reportPiper PA-18A 150 · Illiamna, AKThe pilot's inadequate recovery from a bounced landing, which resulted in a loss of control.Jul 3, 2012 · N8889D · Substantial damageNTSB WPR12CA284Accident · Minor injuriesData collectionFinal reportCessna 210-5 · West Glacier, MTThe pilot elected to abort the takeoff without sufficient runway available to land and stop the airplane. Contributing to the accident was the illusion created by the rising terrain, which influenced the pilot's decision to abort the takeoff.Jul 2, 2012 · N8450Z · Substantial damageNTSB ERA12LA431Accident · No injuriesLimited investigationFinal reportLeder John A Leder Velocity XL RG · Thomson, GASeparation of the nose landing gear due to a preexisting fatigue crack caused by an earlier shimmy event and the subsequent incorrect installation of the shimmy dampener.Jul 2, 2012 · N224SM · Substantial damageNTSB ERA12CA472Accident · Serious injuriesData collectionFinal reportSix Chutter SKY Writer 2 · Hamburg, NYThe operation of a powered parachute by a non-certificated pilot. Contributing to the accident was the non-certificated pilot’s loss of aircraft control while landing.Jul 2, 2012 · UNREG · Substantial damageNTSB ERA12CA443Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Lancaster, PAThe pilot's attempt to secure an open canopy during takeoff, which resulted in a loss of control and subsequent hard landing.Jul 2, 2012 · N182EV · Substantial damageNTSB ANC12CA060Accident · No injuriesData collectionFinal reportDehavilland Beaver DHC-2 · Ketchikan, AKThe pilot’s failure to maintain directional control during a step turn on floats.Jul 2, 2012 · N1018A · Substantial damageNTSB ERA12LA428Accident · No injuriesLimited investigationFinal reportCessna R172K · Greene, NYAn undetected fatigue crack on the outer surface of the No. 3 cylinder barrel that could only have been detected visually and not by a differential compression test , resulting in separation of the head from the barrel and a subsequent partial loss of engine…Jul 1, 2012 · N758JQ · Substantial damageNTSB ERA12CA424Accident · No injuriesData collectionFinal reportBeech 58 · Atlanta, GAThe pilot's inadvertent retraction of the landing gear during the landing.Jul 1, 2012 · N827EB · Substantial damageNTSB CEN12LA408Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Griswold, IAThe pilot’s failure to maintain adequate airspeed during an attempted go-around, resulting in an aerodynamic stall.Jul 1, 2012 · N73182 · Substantial damageNTSB CEN12CA409Accident · No injuriesData collectionFinal reportWilkinson Lorin L Hatz XB-II · Oshkosh, WIThe pilot's loss of directional control while landing with a crosswind.Jul 1, 2012 · N500L · Substantial damageNTSB CEN12CA406Accident · No injuriesData collectionFinal reportPiper PA-24 · Watertown, WIThe pilot’s failure to extend the landing gear before landing.Jul 1, 2012 · N6580P · Substantial damageNTSB WPR12LA283Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Stanley, IDThe pilot’s inadequate preflight planning and decision to takeoff at a density altitude outside of the airplane’s takeoff performance envelope, with a tailwind, and near the airplane’s maximum gross weight, which resulted in the airplane’s inability to climb…Jun 30, 2012 · N773C · Substantial damageNTSB WPR12LA281Accident · No injuriesLimited investigationFinal reportTecnam P2002 Sierra · Watsonville, CAA partial loss of engine power during initial climb due to the blockage of the carburetor’s main jet by deteriorated float material. Contributing to the accident was an inadequate maintenance inspection by maintenance personnel.Jun 30, 2012 · N308TA · Substantial damageNTSB WPR12FA282Accident · 4 fatalField investigationFinal reportAerospatiale AS350B · Camp Verde, AZThe pilot's improper decision to fly at a low altitude through a river canyon, contrary to voluntary guidance within the Special Conservation Area, which led to collision with a cable. Contributing to the pilot’s decision were his cognitive and psychomotor…Jun 30, 2012 · N729DP · Substantial damageNTSB ERA12FA423Accident · 1 fatalField investigationFinal reportPiper PA-31P · Dalton, GAThe pilot’s failure to maintain airplane control following loss of power in the right engine for reasons that could not be determined because of fire and impact damage. Contributing to the accident was the pilot’s delayed feathering of the right propeller…Jun 30, 2012 · N33CG · Substantial damageNTSB ERA12CA430Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Camden, TNThe pilot's failure to properly secure the airplane before hand-propping the engine for startup.Jun 30, 2012 · N96282 · Substantial damageNTSB CEN12LA414Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Glenwood Springs, COThe pilot's decision to fly into a mountainous area where conditions were such that the airplane was unable to climb above rising terrain. Contributing to the accident was the pilot's insufficient pilot-in-command experience and inadequate training in…Jun 30, 2012 · N917SA · Substantial damageNTSB ANC12LA061Accident · No injuriesLimited investigationFinal reportDehavilland Beaver DHC-2 MK.1 · Bettles, AKThe pilot’s failure to properly judge the airplane’s distance and altitude from the landing location during the final approach, which resulted in an undershoot and a nose over.Jun 30, 2012 · N63562 · Substantial damageNTSB CEN12LA417Accident · Serious injuriesLimited investigationFinal reportBadeaux Challenger II · New Iberia, LAThe operation of an airplane by a noncertificated pilot and his failure to maintain clearance with the power lines during the landing approach.Jun 29, 2012 · N16665 · Substantial damageNTSB CEN12LA407Accident · Serious injuriesLimited investigationFinal reportFields Mike Hawk SSC · Evansville, INThe operation of an airplane by a non-certificated pilot, and the pilot's loss of control during takeoff, which resulted in an inadvertent stall and spin.Jun 29, 2012 · N163F · Substantial damageNTSB CEN12CA413Accident · Serious injuriesData collectionFinal reportCessna 182K · Newark, OHThe pilot's loss of control during taxi in strong wind conditions.Jun 29, 2012 · N2591R · Substantial damageNTSB WPR12FA280Accident · 1 fatalField investigationFinal reportAviat A-1C-180 · Kooskia, IDThe pilot's decision to attempt a takeoff with a gusty tailwind, which resulted in his loss of airplane control during the initial climb and an aerodynamic stall/spin.Jun 28, 2012 · N63WY · Substantial damageNTSB ERA12LA422Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Mc Kinnon, TNThe separation of the piston connecting rod from the crankshaft due to inadequate installation from a mechanic, resulting in a total loss of engine power.Jun 28, 2012 · N174JB · Substantial damageNTSB ERA12CA454Accident · Minor injuriesData collectionFinal reportLet L-23 Super Blanik · Benton, TNThe pilot's inadvertent extension of the wing airbrakes, which resulted in a loss of lift and subsequent landing prior to the runway.Jun 28, 2012 · N273BA · Substantial damageNTSB ERA12CA427Accident · No injuriesData collectionFinal reportCessna 182A · Sussex, NJThe pilot’s delayed decision to abort the landing and perform a go-around, which resulted in a runway overrun.Jun 28, 2012 · N5143D · Substantial damageNTSB CEN12LA401Accident · Serious injuriesLimited investigationFinal reportPiper PA-23 · Baltic, OHLoss of engine power due to fuel starvation as a result of particulate contaminant on the carburetor screens.Jun 28, 2012 · N3170P · Substantial damageNTSB CEN12CA403Accident · No injuriesData collectionFinal reportAyres S2R-G10 · Minden, NEThe pilot’s failure to maintain clearance from the wake turbulence from a previous pass.Jun 28, 2012 · N3299Z · Substantial damageNTSB WPR12LA277Accident · 1 fatalLimited investigationFinal reportRehn Kitfox IV · Vancouver, WAThe pilot's failure to maintain airspeed during an attempt to return to the runway immediately after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was foreign debris in the right-hand carburetor bowl, which precipitated a loss…Jun 27, 2012 · N645GR · Substantial damageNTSB WPR12CA287Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Paulden, AZThe pilot’s failure to maintain directional control during the landing roll.Jun 27, 2012 · N43087 · Substantial damageNTSB ERA12LA417Accident · No injuriesLimited investigationFinal reportLuters Arnis V Legend · Glenwood, FLThe total loss of engine power due to the airplane builder’s improper installation of the fuel control unit condition lever cables, which resulted in the airplane’s subsequent forced landing.Jun 27, 2012 · N3YZ · Substantial damageNTSB ERA12CA420Accident · No injuriesData collectionFinal reportCessna 172M · Smyrna, TNThe pilot’s inadequate flare and improper recovery from a bounced landing, which resulted in a hard landing.Jun 27, 2012 · N80985 · Substantial damageNTSB ERA12CA418Accident · Minor injuriesData collectionFinal reportGrumman American Avn. AA-1C · West Chester, PAThe pilot’s failure to maintain directional control during an attempted go-around, which resulted in a runway excursion.Jun 27, 2012 · N9675U · Substantial damageNTSB CEN12LA434Accident · No injuriesLimited investigationFinal reportBeech A36 · New Orleans, LAThe pilot's failure to lower the landing gear before touchdown.Jun 27, 2012 · N136EH · Substantial damageNTSB ERA12CA419Accident · No injuriesData collectionFinal reportCessna 172S · West Palm Beach, FLThe flight instructor’s failure to maintain airplane control during the takeoff in gusting crosswind conditions. Contributing to the accident was the flight instructor’s decision to conduct takeoffs and landings in conditions exceeding the airplane’s maximum…Jun 26, 2012 · N961MC · Substantial damageNTSB CEN12CA402Accident · No injuriesData collectionFinal reportSchweizer TH55A/269A · Grinnell, IAThe pilot’s inadequate compensation for the wind during a hovering maneuver, which resulted in a loss of tail rotor effectiveness and directional control.Jun 26, 2012 · N488MC · Substantial damageNTSB CEN12CA396Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Valparaiso, INThe pilot’s failure to stop the airplane while taxiing to park, which resulted in a collision with a parked vehicle.Jun 26, 2012 · N6183H · Substantial damageNTSB CEN12CA394Accident · Minor injuriesData collectionFinal reportBoeing B75N1 · Fredricksburg, TXThe pilot's excessive brake application, leading to a noseover during the landing. Contributing to the accident was the pilot’s delay in lowering the tail after landing.Jun 26, 2012 · N50082 · Substantial damageNTSB WPR12CA291Accident · No injuriesData collectionFinal reportStinson 108-2 · Mile Hi Landing Strip, IDThe pilot's misjudgment of the speed and distance required to land, which resulted in a runway overrun.Jun 25, 2012 · N247C · Substantial damageNTSB ERA12FA412Accident · 1 fatalField investigationFinal reportSocata TB21 · Gold Hill, NCAn inflight fire, the origin of which could not be determined because of postaccident fire damage. Contributing to the accident was the pilot's improper modifications to the airplane.Jun 25, 2012 · N2528N · Substantial damageNTSB WPR12LA290Accident · No injuriesLimited investigationFinal reportBurleigh Bearhawk · Heber City, UTThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.Jun 24, 2012 · N117Z · Substantial damageNTSB WPR12LA275Accident · No injuriesLimited investigationFinal reportDehavilland Tiger Moth DH 82A · Fontana, CAPartial loss of engine power during cruise flight due to a failed engine cylinder rocker assembly clamping bolt. Contributing to the accident was the failure of unknown maintenance personnel to perform a modification to the assembly that would have prevented…Jun 24, 2012 · N523R · Substantial damageNTSB WPR12CA355Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Rexburg, IDThe student pilot's failure to maintain directional control and subsequent excessive braking during the landing roll with a tailwind, which resulted in a noseover.Jun 24, 2012 · N741R · Substantial damageNTSB ERA12CA413Accident · Minor injuriesData collectionFinal reportMooney M10 · Hurlock, MDThe pilot's failure to see and avoid power lines during final approach to landing.Jun 24, 2012 · N9542V · Substantial damageNTSB CEN12LA404Accident · Serious injuriesLimited investigationFinal reportDestiny 2000 · Shelbyville, INThe operation of the aircraft by a non-certificated pilot and his failure to plan for the high density altitude and to maintain control of the aircraft.Jun 24, 2012 · UNREG · Substantial damageNTSB CEN12CA415Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Richmond, INThe pilot’s failure to ensure that the fuel selector was properly positioned, which resulted in a total loss of engine power due to fuel starvation.Jun 24, 2012 · N8788W · Substantial damageNTSB WPR12LA289Accident · No injuriesLimited investigationFinal reportCox PA 18 · Soldier Bar, IDThe pilot’s failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and the airplane nosing over.Jun 23, 2012 · N13VC · Substantial damageNTSB WPR12FA274Accident · 4 fatalField investigationFinal reportCessna 172 · Veneta, ORThe pilot’s failure to maintain adequate airspeed and altitude to clear trees during the initial climb after takeoff.Jun 23, 2012 · N5781A · Substantial damageNTSB ERA12CA414Accident · No injuriesData collectionFinal reportCessna 177 · West Milford, NJThe pilot's improper full flap retraction while performing a go-around maneuver, which resulted in a loss of airplane control.Jun 23, 2012 · N30163 · Substantial damageNTSB CEN12LA388Accident · No injuriesLimited investigationFinal reportCessna A150K · Mamou, LAThe pilot's inadequate preflight inspection, which resulted in a partial loss of engine power due to fuel contamination.Jun 23, 2012 · N8380M · Substantial damageNTSB ANC12CA057Accident · No injuriesData collectionFinal reportChampion 7GCB · Tyonek, AKThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall while maneuvering.Jun 23, 2012 · N466RV · Substantial damage