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 DCA19WA071Incident · No injuriesForeign investigationBoeing 747 · Kolkata, IndiaThe Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a Boeing 747, which occurred on October 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…NTSB CEN19WA012Accident · 2 fatalForeign investigationCessna 150M · La Paz, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA 150M airplane that occurred on October 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…NTSB CEN19FA008Accident · 2 fatalClass 3 · FieldFinal reportCessna 182 · Canoncito, NMThe partial loss of engine power due to induction system icing. Contributing to the accident was the fractured carburetor heat control cable, which rendered the carburetor heat inoperative.NTSB GAA19CA026Accident · No injuriesData collectionFinal reportCessna 140 · Denver, COThe pilot’s inadvertent brake application, which resulted in a loss of directional control and a subsequent nose-over.NTSB ERA19LA014Accident · Serious injuriesClass 3 · LimitedFinal reportHargrove Hummel Ultra Cruiser · Zephyrhills, FLThe pilot's failure to activate the airplane’s auxiliary fuel pump, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident were the impairing effects of the pilot’s medication on his performance.NTSB DCA19WA196Incident · Serious injuriesForeign investigationBoeing 777 · New Delhi, IndiaThe government of India has notified the NTSB of a serious incident involving a BOEING 777 airplane that occurred on October 15, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of India's investigation under the…NTSB DCA19CA207Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Albany, NYan encounter with convective turbulence that resulted in a serious injury to a flight attendant.NTSB WPR19FA007Accident · 2 fatalClass 2 · FieldFinal reportCessna T240 · Payson, AZThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall/spin and a subsequent loss of control.NTSB GAA19CA024Accident · No injuriesData collectionFinal reportCessna 172 · Vergennes, VTThe pilot's failure to maintain clearance from trees while taxiing.NTSB GAA19CA022Accident · No injuriesData collectionFinal reportPiper PA 18-135 · Cherry Ridge, PAThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB GAA19CA020Accident · No injuriesData collectionFinal reportCessna 172 · Lawrenceville, GAThe student pilot's improper pitch application, which resulted in a hard landing and subsequent fire. Contributing to the accident was the student’s failure to give over the flight controls to the flight instructor when instructed to do so.NTSB CEN19WA014Accident · No injuriesForeign investigationPiper L4 · Skane County, SwedenThe government of Sweden has notified the NTSB of an accident involving a PIPER L4 airplane that occurred on October 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Sweden's investigation under the provisions of…NTSB CEN19WA010Accident · 3 fatalForeign investigationCessna F172 · Wasserkuppe, GermanyOn October 14, 2018, about 1345 coordinated universal time, a Cessna F172N, D-EFJX, experienced a runway excursion during landing which resulted in 3 ground fatalities.This investigation is under the jurisdiction and control of the German Federal Bureau of…NTSB GAA19CA027Accident · No injuriesData collectionFinal reportPiper J3C · Camas, WAThe student pilot’s failure to maintain directional control during the landing roll.NTSB GAA19CA023Accident · No injuriesData collectionFinal reportSkystar Kitfox SER 5 Safari · Monte Vista, COThe pilot's improper landing flare in gusting crosswind conditions, which resulted in a hard, bounced landing and his subsequent failure to maintain directional control.NTSB ERA19TA011Accident · No injuriesFinal reportBeech F33 · Reidsville, GAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a taxiway sign.NTSB ERA19LA015Accident · No injuriesClass 3 · LimitedFinal reportAvid Avid Flyer · Grant-Valkaria, FLA total loss of engine power due to a carburetor malfunction, which resulted in a forced landing.NTSB ERA19LA012Accident · 3 fatalLimited investigationFinal reportPiper PA34 · Westhampton Beach, NYThe instructor's decision to conduct and continue a visual flight rules flight into instrument meteorological conditions with a known flight instrument anomaly, which resulted in spatial disorientation, causing a loss of airplane control and subsequent…NTSB CEN19LA006Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Hudson, COThe partial loss of engine power for reasons that could not be determined based on the available information.NTSB CEN19FA005Accident · 1 fatalField investigationFinal reportPiper PA28 · Cartersville, GAThe pilot's inadequate preflight and inflight fuel planning and his decision to continue flight without stopping for fuel, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA19CA051Accident · No injuriesData collectionFinal reportRIchard Silva Seawind · Pocono Summit, PAThe pilot's improper decision to attempt to take off from a lake in high crosswind conditions, which resulted in the right wing lifting, the left wing impacting the water, and the airplane bouncing and then impacting the water hard.NTSB GAA19CA034Accident · No injuriesData collectionFinal reportJust Just Aircraft (Highl · Monroe, WAThe pilot's improper engine modification and operation, which resulted in a total loss of engine power due to fuel starvation, and the pilot's failure to maintain an adequate approach path, which resulted in the airplane landing short of the runway.NTSB ERA19LA016Accident · Serious injuriesLimited investigationFinal reportSa300 Starduster · Byhalia, MSThe pilot's failure to maintain a proper approach path, which resulted a collision with trees short of the runway.NTSB ERA19FA010Accident · 1 fatalClass 2 · FieldFinal reportVans RV8 · Culpeper, VAThe pilot's loss of attitude orientation while maneuvering at low altitude in dark night visual meteorological conditions, which resulted in impact with terrain.NTSB DCA19WA013Incident · No injuriesForeign investigationBoeing 737 · East Midlands, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on October 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under…NTSB DCA19WA007Accident · No injuriesForeign investigationBoeing 737 · Tamil Nadu, IndiaThe government of India has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on October 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of India's investigation under the provisions of…NTSB DCA19CA010Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A319 · Denver, COinadvertent encounter with clear air turbulence resulting in a flight attendant receiving serious injuries.NTSB CEN19LA007Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman AA5 · Refugio, TXThe pilot’s improper inflight fuel management, which resulted in a total loss of engine power due to fuel starvation and the pilot’s failure to maintain adequate airspeed, which resulted in the airplane exceeding its critical angle of attack and an…NTSB CEN19LA002Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Midland, TXThe loss of engine power due to excessive fuel flow.NTSB CEN19FA004Accident · 2 fatalField investigationFinal reportPiper PA32RT · Poolville, TXThe pilot's loss of airplane control as a result of spatial disorientation and the exceedance of the structural capabilities of the airplane. Contributing to the accident was the pilot's limited experience in instrument conditions.NTSB CEN19FA003Accident · 1 fatalField investigationFinal reportAir Tractor AT502 · Placedo, TXThe pilot's failure to maintain clearance from the antenna tower, a known obstruction, during the agricultural application flight. Contributing to the accident was glare from the sun which hindered the pilot's ability to see and avoid the antenna tower.NTSB DCA19WA008Incident · No injuriesForeign investigationBoeing 787 · Perth, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 787 airplane that occurred on October 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation…NTSB DCA19CA006Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · San Jose, CAA passenger falling while returning to her seat which resulted in a serious injury.NTSB CEN19WA011Accident · 2 fatalForeign investigationCessna F172 · East Yorkshire, United KingdomOn November 10, 2018, about 1930 hours universal coordinated time, a Reims Cessna F172N, United Kingdom registration G-BGSV, impacted a field near East Yorkshire, United Kingdom. The two occupants on-board were fatally injured. The flight origin and…NTSB ANC19CA003Accident · No injuriesData collectionFinal reportCessna 207 · Anchorage, AKThe pilot's inadequate in-flight fuel management, which resulted in fuel starvation and the subsequent loss of engine power, and her subsequent failure to maintain clearance from trees during the approach to land at a nearby airstrip.NTSB WPR19TA005Accident · Serious injuriesFinal reportBalloon Works Firefly 7 · Placitas, NMThe pilot’s failure to properly estimate the height of terrain while descending the balloon, which resulted in the balloon impacting a hill and passengers sustaining serious injuries.NTSB GAA19CA013Accident · No injuriesData collectionFinal reportCessna 140 · Marina, CAThe pilot’s inadvertent application of the brakes, which resulted in a nose-over.NTSB DCA19CA005Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Nashville, TNflight attendant tripping over a passenger's knee that resulted in hot liquid splashing on the flight attendant.NTSB WPR19TA009Accident · Serious injuriesFinal reportKreling Supercat · Three Rivers, MIThe pilot's failure to maintain the proper pitch attitude and adequate airspeed during takeoff, which resulted in an aerodynamic stall.NTSB WPR19LA006Accident · 1 fatalClass 2 · LimitedFinal reportVans RV6 · Cape Girardeau, MOThe pilot's improper landing flare in gusting crosswind conditions, his failure to conduct a go-around, and his failure to maintain directional control, which resulted in a runway departure and nose-over.NTSB GAA19CA021Accident · No injuriesData collectionFinal reportAviat S · Hampton, GAThe pilot’s failure to see and avoid power wires during approach.NTSB DCA19WA011Incident · No injuriesForeign investigationBoeing 737 · Brisbane, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on October 09, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation…NTSB WPR19WA004Accident · 2 fatalForeign investigationCessna 172 · Midrand, South AfricaOn October 8, 2018, at 0920 coordinated universal time, a Cessna 172L airplane, registration ZS-PZT, sustained substantial damage after colliding with the ground during the landing approach at Grand Central Airport, Midrand, South Africa. The pilot and one…NTSB WPR19LA003Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Grass Valley, CAA loss of engine power due to fuel starvation and the pilot's mismanagement of the available fuel.NTSB GAA19CA030Accident · Serious injuriesData collectionFinal reportUltramagic N 250 · Rio Rancho, NMThe balloon tipping over during deflation, which resulted in a passenger injury.NTSB GAA19CA010Accident · No injuriesData collectionFinal reportAir Tractor AT 402 · Crowley, LAThe pilot's selection of unsuitable terrain for takeoff, which resulted in a collision with vegetation and a subsequent loss of directional control.NTSB GAA19CA008Accident · Minor injuriesData collectionFinal reportCessna 188 · Rolla, MOThe pilot's failure to maintain directional control during takeoff in a left quartering tailwind.NTSB DCA19WA083Incident · No injuriesForeign investigationBoeing 747 · Bangkok, ThailandThe government of Thailand has notified the NTSB of an accident involving a BOEING 747 airplane that occurred on October 08, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Thailand's investigation under the…NTSB WPR19LA002Accident · No injuriesClass 3 · LimitedFinal reportRobinson R44 · Salinas, CAThe partial loss of engine power after takeoff due to faulty wiring to the engine governor.NTSB GAA19CA018Accident · No injuriesData collectionFinal reportPiper PA 16 · Manchester, WVA vehicle's incursion onto an active runway, which resulted in an evasive action by the pilot landing an airplane on that runway and a subsequent runway excursion.