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 ERA10IA459Incident · No injuriesIncident investigationFinal reportBell Helicopter Textron Canada 407 · Marion, VAThe cardiac impairment of the pilot during a positioning flight.Aug 31, 2010 · N516MT · No damageNTSB CEN10FA509Accident · 3 fatalField investigationFinal reportBell Helicopter Textron 206L-1 · Walnut Grove, ARThe pilot’s loss of aircraft control, due to spatial disorientation, resulting in the in-flight separation of the main rotor and tail boom.Aug 31, 2010 · N62AE · Substantial damageNTSB CEN10CA518Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Anderson, INThe pilot’s failure to abort the takeoff due to degraded airplane performance.Aug 31, 2010 · N3969K · Substantial damageNTSB ANC10TA080Accident · No injuriesFinal reportAviat A-1B · Bettles Field, AKThe pilot's selection of an unsuitable off-airport landing site for a precautionary landing.Aug 31, 2010 · N20HY · Substantial damageNTSB WPR10FA438Accident · 1 fatalField investigationFinal reportCessna 182C · Belgrade, MTThe non-instrument rated pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in a loss of airplane control.Aug 30, 2010 · N8957T · Substantial damageNTSB WPR10CA437Accident · No injuriesData collectionFinal reportHolt Herbert L Long EZ · Afton, WYThe pilot's failure to securely lock the canopy prior to takeoff, which allowed the contents of the cabin to exit the airplane and damage the propeller. Contributing to the severity of the damage was the subsequent fire that ensued.Aug 29, 2010 · N31939 · Substantial damageNTSB WPR10CA436Accident · No injuriesData collectionFinal reportCessna TU206F · Seneca, ORThe pilot's failure to maintain directional control after takeoff, resulting in a collision with a tree.Aug 29, 2010 · N1406Q · Substantial damageNTSB ERA10LA454Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Acworth, GAThe pilots improper in-flight fuel management resulting in a total loss of engine power during a descent due to fuel starvation.Aug 29, 2010 · N451TS · Substantial damageNTSB ERA10CA452Accident · No injuriesData collectionFinal reportKilishek George T RV-8 · Yadkinville, NCThe pilot's inadequate flare, which resulted in a hard landing.Aug 29, 2010 · N888GK · Substantial damageNTSB CEN10CA504Accident · Minor injuriesData collectionFinal reportRauch RV-3 · Newark, OHThe pilot’s failure to attain the proper touchdown point, resulting in an undershoot.Aug 29, 2010 · N50NJ · Substantial damageNTSB WPR10LA441Accident · No injuriesLimited investigationFinal reportCessna TR182 · Spanish Fork, UTThe pilot did not extend the landing gear due to his impairment from alcohol.Aug 28, 2010 · N738MP · Substantial damageNTSB WPR10FA435Accident · 1 fatalField investigationFinal reportRemos Remos G-3/600 · Tucson, AZThe pilot's failure to maintain airplane control while maneuvering at a low altitude.Aug 28, 2010 · N268RA · Substantial damageNTSB ERA10LA504Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Mocksville, NCThe pilot’s failure to attain the proper touchdown point, following a loss of engine power due to carburetor icing.Aug 28, 2010 · N85929 · Substantial damageNTSB ERA10LA450Accident · No injuriesLimited investigationFinal reportAir Tractor AT402 · Pompano Beach, FLThe pilot's delayed decision to abort the takeoff, which resulted in a runway overrun and a subsequent collision with obstacles and terrain. Contributing to the accident was the airplane's high gross weight.Aug 28, 2010 · N4172U · Substantial damageNTSB ERA10CA451Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5 · Montauk, NYThe pilot's delay in aborting the landing, which resulted in a collision with a fence.Aug 28, 2010 · N9532L · Substantial damageNTSB CEN10CA513Accident · No injuriesData collectionFinal reportCessna 172P · Bartlesville, OKThe student pilot's loss of directional control during takeoff due to an improper flap setting.Aug 28, 2010 · N52071 · Substantial damageNTSB ERA10LA449Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7HC · Louisville, KYA loss of engine power due to fuel system contamination resulting in damage to the carburetor float.Aug 27, 2010 · N8919R · Substantial damageNTSB ERA10LA446Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Beverly, MAThe flight instructor's decision to exit the airplane on the taxiway with the engine still operating, and his failure to avoid the rotating propeller.Aug 27, 2010 · N9184Y · Minor damageNTSB ERA10CA477Accident · Minor injuriesData collectionFinal reportBeam-Walter RS-15 · Windsor, VAThe pilot's inadequate installation and preflight inspection of the right rudervator assembly, which resulted in a loss control during takeoff.Aug 27, 2010 · N29WB · Substantial damageNTSB ERA10CA448Accident · No injuriesData collectionFinal reportCessna 182E · Edenton, NCThe pilot's inadequate compensation for crosswind conditions while landing, which resulted in a loss of directional control.Aug 27, 2010 · N3351Y · Substantial damageNTSB ERA10CA447Accident · No injuriesData collectionFinal reportCessna T206H · Clayton, GAThe pilot's improper touchdown point while landing on the wet grass.Aug 27, 2010 · N6075M · Substantial damageNTSB ANC10CA077Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Wasilla, AKThe pilot's failure to maintain directional control during landing, resulting in a runway excursion and nose over.Aug 27, 2010 · N9730P · Substantial damageNTSB WPR10LA429Accident · 2 fatalLimited investigationFinal reportFinney Thorp T-18 · Willcox, AZThe pilot’s failure to maintain sufficient airspeed during a steep turn and at a low altitude in the traffic pattern, which resulted in an aerodynamic stall.Aug 26, 2010 · N467JF · Substantial damageNTSB WPR10IA430Incident · Minor injuriesIncident investigationFinal reportAirbus A320-232 · Sacramento, CAThe first officer’s inadvertent activation of the parking brake in flight, which led to the airplane abruptly stopping and all four of its main landing gear tires deflating, and his use of a nonstandard procedure to cancel the airplane's monitoring alert…Aug 26, 2010 · N590JB · Minor damageNTSB ERA10CA460Accident · No injuriesData collectionFinal reportCessna 177B · Ocean City, MDThe pilot's improper recovery from a bounced downwind landing.Aug 26, 2010 · N16023 · Substantial damageNTSB ERA10CA445Accident · No injuriesData collectionFinal reportColumbia Aircraft Mfg LC42-550FG · Tampa, FLThe pilot's failure to reduce engine power following a high-powered engine start.Aug 26, 2010 · N1321C · Substantial damageNTSB ERA10LA442Accident · 1 fatalLimited investigationFinal reportStinson 108 · Andrews, SCLoss of engine power due to fuel exhaustion, and the student pilot's failure to adequately preflight the airplane prior to takeoff.Aug 25, 2010 · N97316 · Substantial damageNTSB ERA10CA468Accident · No injuriesData collectionFinal reportCessna 172S · Frederick, MDUndetermined.Aug 25, 2010 · N387AF · Substantial damageNTSB ANC10FA076Accident · 2 fatalField investigationFinal reportPiper PA-11 · Willow, AKThe pilot’s failure to maintain adequate airspeed, which resulted in an aerodynamic stall/spin and impact with the ground.Aug 25, 2010 · N78831 · Substantial damageNTSB WPR10LA427Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Sequim, WAThe pilot’s failure to maintain the proper approach path and his delayed corrective actions, which resulted in an undershoot. Contributing to the accident was the pilot's distraction from other aircraft in the area.Aug 24, 2010 · N5101L · 2 aircraft · Substantial damageNTSB WPR10LA426Accident · No injuriesLimited investigationFinal reportGrob-Werke G 120A · Buckeye, AZThe student pilot's improper flare, which resulted in a hard landing.Aug 24, 2010 · N865AF · Substantial damageNTSB CEN10LA524Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Greeley, COA loss of engine power for undetermined reasons.Aug 24, 2010 · N4167A · Substantial damageNTSB CEN10LA502Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR20 · Porter, TXThe pilot's delay in performing a go-around, which resulted in an impact with trees.Aug 24, 2010 · N8154M · Substantial damageNTSB CEN10LA498Accident · Minor injuriesLimited investigationFinal reportFreeman Super Koala · Traverse City, MIA loss of engine power due to the improper torquing of the number one cylinder's spark plug as a result of inadequate maintenance.Aug 24, 2010 · N220FF · Substantial damageNTSB WPR10LA421Accident · No injuriesLimited investigationFinal reportCessna U206 · Grangeville, IDThe pilot’s decision to fly with a known defective nosewheel assembly, which resulted in a loss of directional control and nose-over on landing after the assembly shifted out of alignment during the flight.Aug 23, 2010 · N29100 · Substantial damageNTSB WPR10LA420Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · San Diego, CAThe pilot's failure to utilize carburetor heat during initial climb, which resulted in a loss of engine power due to carburetor icing.Aug 23, 2010 · N7186Z · Substantial damageNTSB ERA10LA438Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Douglas, GAA loss of engine power during takeoff due to fuel contamination. Contributing to the accident was the pilot's inadequate preflight inspection and inadequate maintenance of the fuel system.Aug 23, 2010 · N8734Y · Substantial damageNTSB ERA10CA440Accident · No injuriesData collectionFinal reportBeech P35 · Hartford, CTThe pilot's inadequate compensation for the crosswind, resulting in a loss of directional control during landing.Aug 23, 2010 · N8667M · Substantial damageNTSB CEN10FA493Accident · 2 fatalField investigationFinal reportCessna 310C · Calhan, COThe pilots'failure to maintain control of the airplane which resulted in an inadvertent stall and spin.Aug 23, 2010 · N896H · Substantial damageNTSB WPR10LA417Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Mammoth Lakes, CAThe pilot’s failure to maintain adequate airspeed and airplane control during takeoff in high density altitude conditions, which resulted in an aerodynamic stall.Aug 22, 2010 · N7807U · Substantial damageNTSB WPR10CA422Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A · Minden, NVThe pilot’s inadequate flare and bounced landing recovery technique that resulted in a hard landing.Aug 22, 2010 · N794G · Substantial damageNTSB CEN10LA491Accident · 2 fatalLimited investigationFinal reportSchneider Christen Eagle II · Clearwater, MNThe pilot's failure to maintain aircraft control and his improper decision to perform aerobatic maneuvers without proper experience or training in aerobatic flight. Also causal was his conduct of aerobatic flight in an airplane loaded outside its weight and…Aug 22, 2010 · N222ET · Substantial damageNTSB WPR10CA418Accident · No injuriesData collectionFinal reportWilde Daniel L Zenith 701 · Turlock, CAThe pilot’s inadequate compensation for the crosswind and failure to maintain runway alignment.Aug 21, 2010 · N948DW · Substantial damageNTSB ERA10FA435Accident · 2 fatalField investigationFinal reportNorth Wing Scout X-C · Amherst, VAThe pilot's loss of aircraft control for an undetermined reason.Aug 21, 2010 · N417JN · Substantial damageNTSB ERA10LA439Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tunkhannock, PAA total loss of engine power during the initial climb due to the pilots' inadequate in-flight fuel management.Aug 20, 2010 · N4850A · Substantial damageNTSB CEN10LA497Accident · 1 fatalLimited investigationFinal reportMiller Charles W Vans RV-7A · El Dorado, ARThe pilot's failure to maintain clearance with trees on takeoff at night. Contributing factors were fatigue and the pilot's lack of recent nighttime experience.Aug 20, 2010 · N474JM · Substantial damageNTSB CEN10CA499Accident · No injuriesData collectionFinal reportCessna 182P · Del Rio, TXThe pilot's failure to monitor his altitude while making a visual approach, which resulted in landing short of the runway and subsequent collision with terrain.Aug 20, 2010 · N1289S · Substantial damageNTSB CEN10CA495Accident · No injuriesData collectionFinal reportSchempp-Hirth VENTUS-2B · Madisonville, TXThe pilot's failure to maintain control of the glider while landing in a crosswind.Aug 20, 2010 · N710RJ · Substantial damageNTSB CEN10CA490Accident · Serious injuriesData collectionFinal reportPiper PA-46-310P · Austin, TXThe pilot's failure to maintain a stabilized approach, which resulted in a loss of control on landing with a tailwind.Aug 20, 2010 · N106LB · Substantial damageNTSB CEN10CA488Accident · No injuriesData collectionFinal reportTubbs S/Performance Air PA18-225 · Denver, COThe pilot's failure to maintain control of the airplane during landing.Aug 20, 2010 · N755K · Substantial damage