NTSB investigations

19,222 cases where NTSB found Aircraft.

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\", '01'))
  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 GAA18CA490Accident · Serious injuriesData collectionFinal reportCessna 172 · DePere, WIThe pilot’s failure to maintain lateral control and his subsequent failure to maintain the runway heading during an attempted go-around, which resulted in impact with trees.Aug 14, 2018 · N1085U · Substantial damageNTSB CEN18LA329Accident · No injuriesLimited investigationFinal reportCessna 150 · Madison, SDA stuck No. 3 cylinder exhaust valve, which resulted in failure of the associated rocker arm, a partial loss of engine power, and the subsequent forced landing into tall vegetation.Aug 14, 2018 · N6341K · Substantial damageNTSB WPR18LA241Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Afton, WYThe pilot’s failure to maintain terrain clearance after an encounter with a downdraft while maneuvering in a valley with a high-density altitude, which resulted in impact with trees and terrain.Aug 13, 2018 · N5660J · Substantial damageNTSB DCA18CA283Accident · No injuriesClass 4 · Data collectionFinal reportAirbus A321-271N · Los Angeles, CAa tailstrike caused by inappropriate recovery technique after a bounced landing. Contributing to the accident was the failure of the radio altimeter, caused by the approach being over calm/flat water, that was not recognized by the flight crew.Aug 13, 2018 · N204HA · Substantial damageNTSB CEN18TA330Accident · No injuriesFinal reportPiper J3C · Friendswood, TXThe pilot's decision to conduct a flight in an airplane that had a tailwheel with degraded locking pins, which allowed the tailwheel to unlock and swivel out of alignment and precluded the pilot from regaining directional control on the ground during a…Aug 13, 2018 · N42218 · Substantial damageNTSB WPR18FA219Accident · 1 fatalField investigationFinal reportBeech A36TC · Sylmar, CAThe pilot's failure to maintain airplane control following a total loss of engine power for reasons that could not be determined based on the available information.Aug 12, 2018 · N136RM · Substantial damageNTSB GAA18CA494Accident · No injuriesData collectionFinal reportPiper PA18 · Gilliam Glacier, AKThe pilot's improper decision to take off in gusting crosswind conditions, which resulted in a loss of control and collision with terrain.Aug 12, 2018 · N9884D · Substantial damageNTSB GAA18CA488Accident · No injuriesData collectionFinal reportCessna 185 · Brooks Range, AKThe airplane's encounter with downdraft conditions during takeoff, which resulted in a subsequent loss of altitude and collision with terrain.Aug 12, 2018 · N62882 · Substantial damageNTSB ERA18LA214Accident · No injuriesClass 3 · LimitedFinal reportPipistrel Sinus 912 · West Palm Beach, FLThe fatigue failure of the exhaust system manifold, which resulted in a ground fire after landing.Aug 12, 2018 · N467L · DestroyedNTSB WPR18TA223Accident · No injuriesFinal reportZenair Zenith Stol CH750 · Napa, CAThe pilot's use of fuel below the required octane rating, which caused engine detonation and damage and subsequently led to oil exhaustion and a total loss of engine power in flight. Contributing to the accident was the pilot's inadequate service/maintenance…Aug 11, 2018 · N328SK · Substantial damageNTSB WPR18FA218Accident · 2 fatalField investigationFinal reportMooney M20K · Baker City, ORThe pilot's exceedance of the airplane's critical angle of attack during the landing approach as a result of his diversion of attention after a series of non-essential aircraft systems became inoperative following the failure of the engine-driven vacuum pump,…Aug 11, 2018 · N231EC · Substantial damageNTSB GAA18CA482Accident · No injuriesData collectionFinal reportQac Quickie · helena, MTThe pilot's failure to maintain yaw control and a proper descent rate during an aborted takeoff.Aug 11, 2018 · N624JC · Substantial damageNTSB GAA18CA481Accident · No injuriesData collectionFinal reportHelio H 295 · Great Falls, MTThe pilot’s failure to maintain lateral control of the airplane during takeoff in a quartering tailwind.Aug 11, 2018 · N77TR · Substantial damageNTSB GAA18CA489Accident · No injuriesData collectionFinal reportMaule MX7 · Valdez, AKThe pilot's failure to maintain the proper airspeed during landing, which resulted in a bounced landing and subsequent nose-over.Aug 10, 2018 · N7ZV · Substantial damageNTSB GAA18CA483Accident · No injuriesData collectionFinal reportRobinson R22 · Ocean City, NJThe flight instructor's decision to conduct hover practice at a lower altitude than recommended and his delayed remedial action during recovery from an unstable hover, which resulted in a dynamic rollover.Aug 10, 2018 · N92TR · Substantial damageNTSB WPR18LA215Accident · No injuriesLimited investigationFinal reportCessna T337 · Lewiston, IDThe liberation of an internal snap ring from a landing gear door actuator, which resulted in a complete loss of hydraulic fluid and a gear-up landing. Contributing to the accident was the failure of maintenance personnel to replace the snap ring during the…Aug 9, 2018 · N255 · Substantial damageNTSB GAA18CA515Accident · No injuriesData collectionFinal reportDell Lawrence Kitfox · Hunter, NYThe pilot’s inadequate in-flight fuel management, which necessitated an off-airport precautionary landing, and his failure to maintain airplane control during the landing roll on rough terrain.Aug 9, 2018 · N26LD · Substantial damageNTSB GAA18CA484Accident · Minor injuriesData collectionFinal reportAirgyro Tercel · Spanish Fork, UTThe student pilot’s failure to maintain pitch and yaw control during takeoff.Aug 9, 2018 · N557AT · Substantial damageNTSB GAA18CA480Accident · No injuriesData collectionFinal reportPiper PA18 · Raton, NMThe pilot's loss of directional control during the landing roll.Aug 9, 2018 · N104CC · Substantial damageNTSB GAA18CA479Accident · No injuriesData collectionFinal reportPiper PA28 · Merritt Island, FLThe pilot's exceedance of the airplane's critical angle of attack while maneuvering to avoid a bird during the landing flare, which resulted in an aerodynamic stall.Aug 9, 2018 · N487JK · Substantial damageNTSB ERA18LA215Accident · No injuriesLimited investigationFinal reportCessna R182 · Florence, SCThe pilot's failure to comply with emergency procedures in the pilot's operating handbook, resulting in the collapse of the main landing gear during landing. Contributing to the accident was the pilot's failure to address the low battery voltage before…Aug 9, 2018 · N1693R · Substantial damageNTSB CEN18CA323Accident · No injuriesData collectionFinal reportCessna 172 · Greeley, COThe pilot’s and safety pilot's conflicting control inputs during landing, which resulted in their failure to maintain a proper airspeed and resulted in an aerodynamic stall. Contributing to the accident was the lack of communication between the pilot and…Aug 9, 2018 · N20JA · Substantial damageNTSB WPR18LA221Accident · No injuriesClass 2 · LimitedFinal reportHughes 369 · Honolulu, HIThe operator's improper installation of the tail rotor (TR) teeter bearings, which resulted in cascading in-flight failures of the TR components and attach hardware.Aug 8, 2018 · N369MH · Substantial damageNTSB WPR18LA214Accident · Minor injuriesLimited investigationFinal reportBell 206 · Basin City, WAThe pilot's improper execution of a slowing and turning maneuver, which resulted in a loss of control at an altitude that was too low for recovery.Aug 7, 2018 · N607RA · DestroyedNTSB ANC18LA064Accident · No injuriesClass 3 · LimitedFinal reportCessna 207 · Iliamna, AKA total loss of engine power due to detonation/preignition damage of the No. 2 cylinder and piston for reasons that could not be determined.Aug 7, 2018 · N7379U · Substantial damageNTSB GAA18CA478Accident · No injuriesData collectionFinal reportCessna 172 · Crystal River, FLThe pilot’s improper landing flare, which resulted in a hard landing.Aug 6, 2018 · N9608H · Substantial damageNTSB GAA18CA470Accident · Minor injuriesData collectionFinal reportWalter C Smythe Tango XR · Mansfield, OHThe pilot’s exceedance of the airplane’s critical angle of attack during a go-around, which resulted in an aerodynamic stall.Aug 6, 2018 · N454WS · Substantial damageNTSB CEN18LA317Accident · No injuriesLimited investigationFinal reportCessna 120 · Pomona, MOThe pilot's inadequate fuel management, which resulted in fuel starvation and a forced landing.Aug 6, 2018 · N76524 · Substantial damageNTSB WPR18FA211Accident · 5 fatalClass 2 · FieldFinal reportCessna 414 · Santa Ana, CAThe pilot’s failure to maintain adequate airspeed while maneuvering in the traffic pattern which resulted in an aerodynamic stall and subsequent spin at a low altitude, which the pilot was unable to recover from.Aug 5, 2018 · N727RP · DestroyedNTSB GAA18CA468Accident · No injuriesData collectionFinal reportCessna 185 · Lovelock, NVThe pilot's improper in-flight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.Aug 5, 2018 · N9867X · Substantial damageNTSB CEN18LA316Accident · Serious injuriesLimited investigationFinal reportChampion 7GCBC · Wiley, COThe pilot's failure to maintain proper clearance from the sprinkler guy-wire, which resulted in the airplane’s collision with the wire during a visual approach to landing.Aug 5, 2018 · N90990 · Substantial damageNTSB GAA18CA502Accident · No injuriesData collectionFinal reportWSK PZL Mielec M-18A · Dansville, NYThe pilot’s failure to maintain clearance from crops during an agricultural application flight.Aug 4, 2018 · N851EJ · Substantial damageNTSB GAA18CA485Accident · No injuriesData collectionFinal reportCessna 172 · Sallisaw, OKThe student pilot's loss of directional control during the landing roll.Aug 4, 2018 · N707TM · Substantial damageNTSB GAA18CA473Accident · Serious injuriesData collectionFinal reportVans RV6 · Greeley, COThe pilot’s exceedance of the airplane’s critical angle of attack during approach, which resulted in an aerodynamic stall.Aug 4, 2018 · N56LK · Substantial damageNTSB GAA18CA472Accident · Minor injuriesData collectionFinal reportCessna 140 · Mount Holly, NJThe pilot's improper landing flare, which resulted in the airplane ballooning upon landing, and his subsequent loss of directional control and excessive brake application.Aug 4, 2018 · N1160D · Substantial damageNTSB GAA18CA471Accident · Minor injuriesData collectionFinal reportCessna 172 · Dowagiac, MIThe pilot's failure to maintain bank control during takeoff.Aug 4, 2018 · N8994V · Substantial damageNTSB GAA18CA469Accident · Minor injuriesData collectionFinal reportRans S7 · Kenai, AKThe pilot's exceedance of the airplane's climb capability due to his use of full flaps during a short-field takeoff, his failure to attain a positive climb rate after takeoff, and his exceedance of the airplane’s critical angle of attack, which resulted in an…Aug 4, 2018 · N8443B · Substantial damageNTSB ERA18LA210Accident · Minor injuriesClass 3 · LimitedFinal reportChampion 7GCAA · Lakewood, NJThe pilot's failure to use carburetor heat in weather conditions conducive to carburetor icing, which resulted in a partial loss of engine power due to the formation of carburetor ice, a forced landing and impact with terrain.Aug 4, 2018 · N87000 · Substantial damageNTSB ERA18FA208Accident · 2 fatalField investigationFinal reportChampion 8GCBC · Foley, ALThe pilot's exceedance of the airplane's critical angle of attack, which resulted in a subsequent aerodynamic stall and spin at an altitude that was too low for recovery.Aug 4, 2018 · N424A · DestroyedNTSB CEN18FA310Accident · 5 fatalClass 3 · FieldFinal reportExtra EA 400 · Ponca City, OKThe pilot's loss of control for reasons that could not be determined with the available evidence.Aug 4, 2018 · N13EP · DestroyedNTSB WPR18FA210Accident · 2 fatalField investigationFinal reportMooney M20J · Lopez Island, WAThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in a cross-control aerodynamic stall, spin, and impact with terrain. Contributing to the accident was the flight instructor's delayed remedial…Aug 3, 2018 · N56039 · Substantial damageNTSB GAA18CA467Accident · No injuriesData collectionFinal reportBeech 58 · Greenville, SCThe pilot failure to attain the proper touchdown point on a wet runway, which resulted in insufficient runway remaining to safely stop the airplane.Aug 3, 2018 · N59PR · Substantial damageNTSB CEN18LA315Accident · No injuriesLimited investigationFinal reportColumbia Aircraft Mfg LC41-550FG · Dallas, TXThe pilot's inability to maintain directional control during taxi due to excessively worn brake pads and a deflated right main tire.Aug 3, 2018 · N2546B · Substantial damageNTSB CEN18LA314Accident · Serious injuriesLimited investigationFinal reportAirbus EC 130 T2 · Mullen, NEThe pilot’s inadequate and incorrect antitorque pedal application during a tight, decelerating turn downwind, which resulted in a loss of yaw control.Aug 3, 2018 · N130TG · Substantial damageNTSB CEN18LA313Accident · No injuriesLimited investigationFinal reportBrantly B-2 · Midland, MIThe in-flight separation of the tail rotor blade due to fatigue, which resulted in the subsequent emergency landing and dynamic rollover.Aug 3, 2018 · N5901X · Substantial damageNTSB WPR18LA216Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Big Creek, IDThe pilot's failure to maintain directional control during the landing roll.Aug 1, 2018 · N57477 · Substantial damageNTSB GAA18CA521Accident · No injuriesData collectionFinal reportCub Crafters CC18 · Fairbanks, AKThe pilot’s premature liftoff and subsequent settling of the airplane to the gravel airstrip.Aug 1, 2018 · N437CC · Substantial damageNTSB GAA18CA459Accident · No injuriesData collectionFinal reportHerzog CCX-2000 · Bend, ORThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and the subsequent collapse of the left main landing gear when he attempted to steer the airplane back onto the runway.Jul 31, 2018 · N116PM · Substantial damageNTSB CEN18LA303Accident · Minor injuriesLimited investigationFinal reportBuchanan Kitfox IV · Loma, COThe pilot's improper decision to conduct a low-altitude flight over a river and his inadequate monitoring of the environment, which resulted in a collision with a cableway.Jul 31, 2018 · N125TY · Substantial damageNTSB GAA18CA476Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Louise, MSThe pilot's improper landing flare, which resulted in a hard, bounced landing and a subsequent loss of directional control.Jul 30, 2018 · N205SK · Substantial damage