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 WPR13CA261Accident · No injuriesData collectionFinal reportBeech A23-24 · La Grande, ORThe pilot’s failure to maintain airplane control and the flight instructors failure to monitor the pilot during a simulated emergency landing.Jun 1, 2013 · N650VX · Substantial damageNTSB WPR13CA260Accident · No injuriesData collectionFinal reportWampach Murphy Moose · Galt, CAThe pilot's improper landing flare, which resulted in an abnormal runway contact.Jun 1, 2013 · N331RW · Substantial damageNTSB WPR13CA256Accident · No injuriesData collectionFinal reportCub Crafters CC11-100 · Payson, AZThe pilot’s failure to maintain aircraft control during the landing flare with a quartering tailwind.Jun 1, 2013 · N787AK · Substantial damageNTSB ERA13LA264Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1B · Williamson, SCThe pilot’s decision to takeoff with a quartering tailwind at high density altitude, close to gross takeoff weight, on a short turf runway with trees at the departure end.Jun 1, 2013 · N3715K · Substantial damageNTSB ERA13LA263Accident · 1 fatalLimited investigationFinal reportWilson William M Cricket MC12 · Doylestown, PAThe pilot's failure to abort the takeoff after detecting the airplane’s degraded performance. Contributing to the accident were the likely loss of power from the left engine for reasons that could not be determined during the postaccident examination of the…Jun 1, 2013 · N2SZ · Substantial damageNTSB CEN13LA330Accident · No injuriesLimited investigationFinal reportCessna TP206B · Sturgeon Bay, WIThe pilot’s improper reselection of the left fuel tank, which had an obstructed vent system and resulted in a total loss of engine power during the approach for landing.Jun 1, 2013 · N3350J · Substantial damageNTSB CEN13LA323Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Hamlin, TXThe pilot's decision to land the airplane with a crosswind that exceeded the airplane's capabilities.Jun 1, 2013 · N4946X · Substantial damageNTSB WPR13FA254Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Anthem, AZThe failure of the pilots in both aircraft to maintain adequate visual lookout in a known training area where multiple aircraft frequently operated, which resulted in a midair collision.May 31, 2013 · N327PA · 2 aircraft · Substantial damageNTSB WPR13CA255Accident · No injuriesData collectionFinal reportBellanca 7ECA · San Martin, CAThe pilot’s failure to maintain directional control during the landing roll.May 31, 2013 · N5032G · Substantial damageNTSB WPR13CA252Accident · Minor injuriesData collectionFinal reportCessna 172A · Eatonville, WAA partial loss of engine power due to carburetor icing and the pilot's failure to maintain adequate airspeed during a go-around, which resulted in a stall.May 31, 2013 · N7701T · Substantial damageNTSB ERA13LA258Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Herndon, VAThe pilot’s inadequate preflight planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.May 31, 2013 · N177FG · Substantial damageNTSB ERA13FA259Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Linden, NJThe flight instructor's inadequate preflight planning and his decision to take off with the airplane at a high gross weight in high temperature conditions that degraded the engine’s available power and his subsequent failure to maintain airspeed while…May 31, 2013 · N176MA · Substantial damageNTSB ERA13CA280Accident · No injuriesData collectionFinal reportPiper PA-25-260 · Hollywood, FLThe pilot's failure to maintain directional control during the landing roll.May 31, 2013 · N169AB · Substantial damageNTSB ERA13CA266Accident · No injuriesData collectionFinal reportCessna 172L · Millinocket, METhe student pilot’s failure to maintain directional control during landing.May 31, 2013 · N9816G · Substantial damageNTSB ERA13CA265Accident · No injuriesData collectionFinal reportCessna 180 · Concord, NHThe pilot’s delayed remedial action following a loss of directional control during the landing roll.May 31, 2013 · N2724X · Substantial damageNTSB ANC13CA052Accident · No injuriesData collectionFinal reportCessna U206A · Fairbanks, AKThe pilot’s inadequate flare, which resulted in a nose-low impact with glassy water and a subsequent nose-over.May 31, 2013 · N4571K · Substantial damageNTSB ERA13CA260Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Ellenville, NYThe student pilot's inadequate preflight planning and failure to maintain clearance from rising terrain, which resulted in controlled flight into terrain.May 30, 2013 · N5715F · Substantial damageNTSB ANC13CA053Accident · No injuriesData collectionFinal reportCessna U206G · King Salmon, AKThe pilot's inadequate airspeed control during a glassy water landing, which resulted in an excessive sink rate, and a hard landing.May 30, 2013 · N77206 · Substantial damageNTSB WPR13FA244Accident · 2 fatalField investigationFinal reportRaytheon A36 · Mountainaire, AZThe pilot's inability to maintain a climb after departure in high-density altitude conditions, which resulted in a collision with trees and terrain. Contributing to the accident were the pilot's decision not to track the four-lane highway just beyond the…May 28, 2013 · N999PK · DestroyedNTSB WPR13CA245Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Page, AZA loss of engine power during cruise flight due to fuel exhaustion. Contributing to the accident was the pilot's improper fuel planning.May 28, 2013 · N969BD · Substantial damageNTSB ANC13CA050Accident · No injuriesData collectionFinal reportTaylorcraft F19 · Napakiak, AKThe student pilot's improper flare, which resulted in a hard landing, and the flight instructor's inadequate supervision of the student.May 28, 2013 · N3617T · Substantial damageNTSB WPR13CA259Accident · No injuriesData collectionFinal reportDressen Escape LS · Fruitland, IDThe pilot’s failure to maintain airplane control during the landing roll as a result of the parking brake lever not being positioned in the full off position.May 26, 2013 · N3932D · Substantial damageNTSB WPR13CA249Accident · No injuriesData collectionFinal reportBeech V35B · Kernville, CAThe pilot's failure to maintain directional control during the landing roll in gusty wind conditions.May 26, 2013 · N7435B · Substantial damageNTSB ERA13LA254Accident · Serious injuriesLimited investigationFinal reportFleming Eldridge E Sonex · Naples, FLThe pilot’s failure to maintain airspeed during a forced landing, which resulted in an aerodynamic stall. Contributing to the accident was a partial loss of the noncertificated engine’s power for reasons that could not be determined because examination of the…May 26, 2013 · N634SX · Substantial damageNTSB WPR13CA242Accident · No injuriesData collectionFinal reportCessna 182R · Alpine, WYThe pilot’s inadequate flare and loss of aircraft control during landing.May 25, 2013 · N9760H · Substantial damageNTSB ERA13CA277Accident · Minor injuriesData collectionFinal reportBoswell John J AIR CAM 912S · West Palm Beach, FLThe pilot's failure to maintain directional control of the airplane during takeoff.May 25, 2013 · N220AC · Substantial damageNTSB ERA13CA255Accident · Minor injuriesData collectionFinal reportFlightstar Sportplanes Flightstar II · York, SCThe pilot’s failure to maintain aircraft control while landing in gusty wind conditions.May 25, 2013 · N677NC · Substantial damageNTSB CEN13CA319Accident · No injuriesData collectionFinal reportCessna TR182 · Emporia, KSThe pilot's failure to lower the landing gear prior to landing.May 25, 2013 · N757QT · Substantial damageNTSB WPR13LA248Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Wheatland, WYA loss of engine power due to fuel exhaustion and the pilot's inadequate fuel planning.May 24, 2013 · N23647 · Substantial damageNTSB ERA13FA253Accident · 3 fatalField investigationFinal reportPiper PA-34-200T · Johnstown, NYThe pilot's loss of control due to spatial disorientation in instrument meteorological conditions, which resulted in an exceedance of the airplane's design stress limitations, and a subsequent in-flight breakup.May 24, 2013 · N31743 · DestroyedNTSB CEN13FA295Accident · 2 fatalField investigationFinal reportRobinson Helicopter R44 II · Cross Timbers, MOThe pilot's failure to see and avoid a power line during the low-altitude flight.May 24, 2013 · N569BC · DestroyedNTSB WPR13LA251Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Truckee, CAThe pilot's failure to lean the fuel mixture during takeoff in high-density altitude conditions, which resulted in a loss of engine power.May 23, 2013 · N5909L · Substantial damageNTSB WPR13CA241Accident · No injuriesData collectionFinal reportCessna 172M · Truckee, CAThe pilot’s failure to maintain directional control during the landing roll which resulted in a collision with a tree.May 23, 2013 · N8879V · Substantial damageNTSB ERA13LA252Accident · No injuriesLimited investigationFinal reportBeech A36 · Atlanta, GAThe pilot's inadequate preflight planning, which resulted in the airplane being loaded in excess of its maximum gross weight at an aft center of gravity for a takeoff with a quartering tailwind and high-density altitude conditions, all of which degraded the…May 23, 2013 · N8225T · Substantial damageNTSB CEN13LA305Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Beaumont, TXThe lack of a forward clamp on the carburetor heat box rubber boot, which allowed the boot to be ingested into the inlet of the carburetor heat box, restricting the airflow and leading to a subsequent partial loss of engine power.May 23, 2013 · N121CM · Substantial damageNTSB CEN13LA293Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Longview, TXThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's inadequate preflight planning, which precluded him from locating his intended destination and led to fuel…May 23, 2013 · N583LA · Substantial damageNTSB CEN13CA306Accident · No injuriesData collectionFinal reportCessna 170B · Danville, INThe pilot not maintaining directional control of the airplane during the landing roll resulting in the ground loop.May 23, 2013 · N3119A · Substantial damageNTSB CEN13LA291Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Englewood, COThe in-flight separation of the engine throttle lever and throttle cable due to maintenance personnel not applying sufficient torque to the self-locking nut or improperly reusing a degraded self-locking nut.May 22, 2013 · N571MA · Substantial damageNTSB CEN13CA292Accident · No injuriesData collectionFinal reportCessna 162 · Erie, COThe pilot’s total lack of experience in aircraft make/model, and his failure to maintain directional control during landing. Contributing to the accident was the operator’s lack of oversight is allowing the airplane to be rented to the pilot.May 22, 2013 · N6106 · Substantial damageNTSB WPR13FA236Accident · 2 fatalField investigationFinal reportCessna 170B · Auburn, CAThe pilot's failure to maintain airplane control during approach to landing, which resulted in an inadvertent stall and subsequent spin.May 19, 2013 · N2865C · Substantial damageNTSB WPR13CA240Accident · No injuriesData collectionFinal reportGlobe GC-1B · Tucson, AZThe pilot's failure to lower the landing gear prior to touchdown.May 19, 2013 · N3802K · Substantial damageNTSB ENG13IA027Incident · No injuriesIncident investigationFinal reportBoeing 747 · Atlanta, GAFailure of the right inboard foreflap outboard fitting due to fatigue and bearing anomalies on the sequence carriages which resulted in the partial separation of the right inboard foreflap. Contributing to the incident was the failure of maintenance personnel…May 19, 2013 · B18701 · Minor damageNTSB ANC13LA049Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Big Lake, AKThe pilot’s execution of a hard landing, which resulted in the overstress fracture of the right main axle housing and the subsequent nosedown.May 19, 2013 · N56464 · Substantial damageNTSB WPR13LA247Accident · No injuriesLimited investigationFinal reportCessna 210-5A · Wenatchee, WAThe pilot’s inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion, and his improper landing flare, which resulted in the airplane’s tail striking the runway.May 18, 2013 · N4848U · Substantial damageNTSB ERA13LA248Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Geneva, FLThe passenger’s failure to adhere to the pilot’s instructions to stay away from the front of the airplane when the engine was operating.May 18, 2013 · N4702F · No damageNTSB ERA13CA250Accident · Minor injuriesData collectionFinal reportThomas David W Rans S-12 XL · Cleveland, GAThe pilot's failure to maintain airspeed while maneuvering after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of overall recent flight experience and lack of experience in make and model.May 18, 2013 · N81788 · Substantial damageNTSB CEN13LA299Accident · 1 fatalLimited investigationFinal reportPeck Norman O Peck P-1 · Aztec, NMThe pilot’s loss of airplane control during takeoff for reasons that could not be determined because postaccident fire damage precluded a complete examination of the airplane.May 18, 2013 · N16NM · DestroyedNTSB CEN13LA286Accident · No injuriesLimited investigationFinal reportCessna 182C · Fremont, MIThe pilot's improper preflight planning, which resulted in a loss of engine power due to fuel exhaustion while in the traffic pattern.May 18, 2013 · N9075T · Substantial damageNTSB WPR13CA235Accident · Minor injuriesData collectionFinal reportSwanson Tiger Moth 80 · Lynden, WAThe pilot's failure to maintain clearance from trees during final approach and his obscured vision due to the sun glare.May 17, 2013 · N928VS · Substantial damageNTSB ERA13CA247Accident · No injuriesData collectionFinal reportCessna 182D · East Moriches, NYThe inadvertent deployment of the skydiving instructor's drogue chute when he exited the airplane, resulting in it contacting and damaging the horizontal stabilizer.May 17, 2013 · N8775X · Substantial damage