NTSB investigations, 2018
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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 year(c.\"eventDate\") = 2018 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.
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 year(c."eventDate") = 2018 ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB GAA19CA015Accident · No injuriesData collectionFinal reportTitan Titan Tornado 912 · Corry, PAThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.NTSB GAA19CA012Accident · No injuriesData collectionFinal reportBearden Biplane Sopwith Camel · Bolivar, MOThe pilot's failure to maintain directional control during landing.NTSB ERA19TA005Accident · No injuriesFinal reportEnstrom F28 · Bridgeville, DEThe pilot's mismanagement of collective pitch control during takeoff from an area with numerous obstacles, which resulted in the helicopter entering a low rotor rpm state and a forced hard landing.NTSB ANC19LA004Accident · Serious injuriesLimited investigationFinal reportAirborne X-Series · North Pole, AKThe student pilot's decision to fly the weight-shift-controlled airplane with no training in the airplane type, which resulted in a loss of control and impact with terrain shortly after takeoff.NTSB GAA19CA009Accident · No injuriesData collectionFinal reportStearman A75N1(PT17) · New Orleans, LAThe pilot’s failure to maintain directional control during a crosswind landing.NTSB GAA19CA007Accident · No injuriesData collectionFinal reportMaule M7 · Medford, ORThe pilot’s failure to maintain directional control during landing.NTSB GAA19CA006Accident · No injuriesData collectionFinal reportZenair CH 2000 · Topeka, KSThe pilot's improper landing flare, which resulted in a hard, bounced landing and a subsequent runway excursion.NTSB ERA19FA003Accident · 1 fatalField investigationFinal reportPiper J3C · Fancy Gap, VAThe non-instrument-rated pilot's improper decision to undertake a flight into forecast instrument meteorological conditions (IMC) and his subsequent decision to continue the flight after encountering IMC, which resulted in controlled flight into terrain.…NTSB CEN19WA019Incident · No injuriesForeign investigationCessna 510 · Lugano, SwitzerlandOn October 6, 2018, about 0945 Universal Coordinated Time, a Cessna Citation 510, OE-FID, experienced a tire failure during landing at the Lugano Airport (LSZA), Lugano, Switzerland. There were no injuries to the 2 crewmembers. The flight originated from the…NTSB GAA19CA019Accident · No injuriesData collectionFinal reportChampion 7ECA · Cleveland, TXThe pilot’s failure to maintain directional control while landing in a gusting crosswind conditions.NTSB GAA19CA014Accident · No injuriesData collectionFinal reportCessna 172 · Stockton, CAThe student pilot's failure to maintain directional control during takeoff.NTSB GAA19CA011Accident · Minor injuriesData collectionFinal reportBeech 55 · San Antonio, TXThe pilot's improper takeoff trim setting and failure to properly secure his seatbelt, which resulted in a loss of airplane control. Contributing to the accident was the pilot's failure to follow the Before Takeoff checklist.NTSB GAA19CA004Accident · No injuriesData collectionFinal reportCessna 310 · Marathon, TXThe pilot's failure to see and avoid a cow on the airstrip during landing.NTSB ERA19LA008Accident · No injuriesLimited investigationFinal reportNorth American Navion A · Stonewall, MSThe fatigue failure of the No. 3 cylinder exhaust valve, which resulted in a fractured camshaft and a total loss of engine power.NTSB WPR19WA036Accident · Minor injuriesForeign investigationAir Tractor 401B · Rukubi, NigeriaOn October 4, 2018, about 0815 coordinated universal time, an Air Tractor AT-401B airplane, 5N-BTV, executed a forced landing following a loss of engine power near Rukubi, Nigeria. The pilot sustained minor injuries and the airplane was substantially damaged.…NTSB GAA19CA017Accident · No injuriesData collectionFinal reportCessna 177RG · Albermarle, NCThe pilot's improper decision to attempt a gear-up glide to the runway and his subsequent failure to extend the landing gear before landing. Contributing to the accident was the pilot's failure to use a checklist before landing.NTSB GAA19CA016Accident · No injuriesData collectionFinal reportPiper PA24 · Winder, GAThe pilot’s failure to maintain an adequate approach path at night after an electrical failure, which resulted in the airplane striking runway lights.NTSB ERA19LA006Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 205 · Wagoner, OKMaintenance personnel’s improper maintenance of the magnetos, which resulted in a loss of engine power.NTSB ERA19CA002Accident · Serious injuriesData collectionFinal reportChampion 7FC · Myakka City, FLThe pilot's failure to maintain clearance from an obstacle during takeoff.NTSB WPR19WA090Incident · No injuriesForeign investigationCessna 560 · Bauchi, NigeriaOn October 3, 2018, about 0754 universal coordinated time, a Cessna Citation XLS+/Nigerian 5N-HAR sustained minor damage during takeoff roll at Sir Abubakar Tafawa Balewa / Bauchi State International Airport, Bauchi, Nigeria. The pilot and two passengers were…NTSB GAA19CA005Accident · No injuriesData collectionFinal reportCessna 180 · Hailey, IDThe pilot’s failure to maintain directional control during takeoff in gusting crosswind conditions.NTSB ERA19WA038Accident · 2 fatalForeign investigationSiai Marchetti SF260 · Caorle, ItalyThe government of Italy has notified the NTSB of an accident involving a Siai Marchetti SF260 airplane that occurred on October 03, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the…NTSB ERA19LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA 24-180 · Smithville, TNA total loss of engine power during initial climb due to carburetor ice that formed during an extended ground delay.NTSB ANC19CA002Accident · No injuriesData collectionFinal reportBeech 1900 · Gambell, AKThe pilot’s unstabilized approach and improper landing flare, which resulted in a hard landing.NTSB GAA19CA002Accident · Minor injuriesData collectionFinal reportAirborne Windsports PTY Edge XT 912 · Frankston, TXThe pilot's improper landing flare, which resulted in the weight-shift-controlled aircraft landing crooked on a turf runway.NTSB DCA19WA009Incident · Minor injuriesForeign investigationBoeing 737 · Zagreb, CroatiaThe AIN of Croatia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on October 02, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AIN of Croatia's investigation under the provisions of ICAO Annex…NTSB WPR19FA001Accident · 1 fatalClass 2 · FieldFinal reportBeech V35 · La Verne, CAThe pilot's failure to maintain clearance from trees during a visual approach for landing. Contributing to the accident was the pilot's distraction during the approach.NTSB GAA19CA025Accident · No injuriesData collectionFinal reportCessna 152 · Lakeland, FLThe pilot's improper landing flare, which resulted in a hard, bounced landing and the nose gear collapsing.NTSB GAA19CA003Accident · No injuriesData collectionFinal reportCessna 152 · Farmingdale, NJThe pilot’s failure to maintain clearance from a vehicle while taxiing for departure.NTSB GAA19CA001Accident · No injuriesData collectionFinal reportCessna 340 · Keokuk, IAThe pilot's failure to correctly identify the runway environment during an instrument approach at night in instrument meteorological conditions because he mistook building lights for runway lights, which resulted in landing short of the runway.NTSB CEN19WA001Accident · 3 fatalForeign investigationCessna 210 5 · Yécora, MexicoOn October 1, 2018, about 2110 universal coordinated time (UTC), a Cessna 210, US registration N8388Z, impacted terrain under unknown circumstances near Sonora, Mexico. Under the provisions of ICAO Annex 13, the NTSB has assigned an accredited representative…NTSB ANC19WA001Accident · 2 fatalForeign investigationRobinson R44 · Bodaybo, RussiaOn October 1, 2018, at an undetermined time, a Robinson R-44-II helicopter, RA-05758, impacted water and sank prior to colliding with a power transmission line near Bodaybo, Russia. The pilot and passenger sustained fatal injuries. The Interstate Aviation…NTSB WPR18LA278Accident · No injuriesClass 3 · LimitedFinal reportHoward DGA 15P · Kernville, CAA total loss of engine power during initial climb due to fuel starvation.NTSB WPR18FA279Accident · 1 fatalClass 2 · FieldFinal reportCessna 177RG · La Verne, CAThe pilot's failure to maintain adequate airspeed and the exceedance of the airplane's critical angle of attack during a turn, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was an undetermined engine…NTSB WPR18FA276Accident · 3 fatalClass 2 · FieldFinal reportCessna T210 · Silver City, IDThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack while making a turn in gusting wind conditions while flying through hilly terrain, which resulted in an aerodynamic stall.NTSB GAA18CA580Accident · No injuriesData collectionFinal reportPiper PA28 · Van Nuys, CAThe pilot's failure to maintain directional control of the airplane during landing.NTSB ERA18TA266Accident · No injuriesFinal reportCessna 172 · Somerset, PAThe pilot's decision to land with insufficient runway remaining to stop, which resulted in a runway overrun.NTSB ERA18LA269Accident · No injuriesLimited investigationFinal reportRobinson R44 · Westminster, MDThe pilot's attempt to move the helicopter from a sloped surface after an overspeed event, which resulted in a loss of helicopter control and impact with a car. The overspeed event resulted from misrouted and damaged wiring in the magneto, which subsequently…NTSB DCA18WA298Incident · No injuriesForeign investigationAirbus A320 · Sydney, AustraliaNTSB CEN18LA392Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Addison, TXMaintenance personnel’s improper installation of the muffler attachment hardware, which resulted in the muffler separating in flight, thermal damage that interrupted the magnetos’ function, and the subsequent total loss of engine power.NTSB ANC18LA080Accident · No injuriesLimited investigationFinal reportPiper PA18 · Delta Junction, AKThe total loss of engine power due to carburetor icing, which resulted from the pilot's failure to use carburetor heat while operating at low power settings in conditions conducive to the formation of carburetor ice.NTSB GAA18CA576Accident · Minor injuriesData collectionFinal reportRaymon A. King Super CUB Replica · Saratoga Springs, UTThe pilot's failure to maintain directional control during the takeoff roll with crosswind conditions.NTSB GAA18CA575Accident · Serious injuriesData collectionFinal reportPiper PA28 · Spokane, WAThe pilot’s improper retraction of the flaps during a go-around, which resulted in the airplane’s failure to climb and its subsequent collision with trees.NTSB GAA18CA574Accident · No injuriesData collectionFinal reportPiper PA24 · Crewe, VAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s improper fuel management, which resulted in fuel starvation…NTSB GAA18CA571Accident · No injuriesData collectionFinal reportEurocopter AS350 · Ruidoso, NMThe pilot's failure to maintain the proper descent rate during landing. Contributing to the accident were the pilot’s failure to conduct preflight performance calculations, which resulted in his operating the helicopter in high-density altitude conditions,…NTSB ERA18LA268Accident · Minor injuriesLimited investigationFinal reportDiamond DA20 · Sebring, FLThe inability of the pilot of the Piper and the student pilot and flight instructor of the Diamond to see and avoid the other airplane. Contributing to the collision was the Piper pilot’s failure to use the correct common traffic advisory frequency to…NTSB ERA18LA265Accident · Minor injuriesLimited investigationFinal reportPiper PA32 · Bartow, FLA total loss of engine power after the separation of the No. 3 cylinder from the crankcase due to improper maintenance.NTSB DCA18WA300Incident · No injuriesForeign investigationBoeing 737 · Diagoras, HungaryThe government of Hungary has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Hungary's investigation under the…NTSB DCA18RA292Accident · 1 fatalForeign investigationBoeing 737 · Chuuk, MicronesiaThe government of Federated States Of Micronesia (FSM) has notified the NTSB of an accident involving a BOEING 737 that occurred on September 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the FSM's investigation under the…NTSB CEN18FA391Accident · 3 fatalField investigationFinal reportAirbus Helicopters AS350 · Gustavus, AKThe pilot's failure to maintain main rotor speed after setting the engine fuel control to idle, which resulted in a loss of helicopter control and impact with water.