NTSB investigations, 2019
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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\") = 2019 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") = 2019 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 WPR20CA048Accident · No injuriesData collectionFinal reportPiper PA22 · Caldwell, IDThe student pilot's failure to establish a positive climb rate during an aborted landing, which resulted in abnormal runway contact, a subsequent loss of directional control, runway excursion, and the right main landing gear collapsing.NTSB DCA20CA043Accident · Serious injuriesClass 4 · Data collectionFinal reportEmbraer ERJ190 · Disputanta, VAan encounter with clear air turbulence during cruise flight.NTSB CEN20WA056Incident · No injuriesForeign investigationLearjet 45 · Geneva, SwitzerlandThe government of Switzerland has notified the NTSB of an incident involving a LEARJET 45 airplane that occurred on December 18, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…NTSB CEN20LA041Accident · No injuriesClass 3 · LimitedFinal reportCessna 525A · Scotts Bluff, NEThe installation of incorrect mounting hardware to secure the right engine cowl, which resulted in an in-flight separation and impact with the horizontal stabilizer and elevator.NTSB CEN20LA036Accident · Minor injuriesClass 3 · LimitedFinal reportChampion 7ECA · Starkville, MSThe total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's decision not to visually confirm the remaining fuel onboard during the intermediate stop.NTSB WPR20CA046Accident · No injuriesData collectionFinal reportBeech 350 · Visalia, CAThe single-engine pilot's failure to yield to traffic established on the taxiway, which resulted in a ground collision.NTSB WPR20CA045Accident · Minor injuriesData collectionFinal reportCessna 140 · Lancaster, CAThe student pilot's failure to maintain directional control and his use of excessive braking while taxiing.NTSB WPR20CA043Accident · No injuriesData collectionFinal reportJohn Sample Bearhawk · Nampa, IDThe pilot's selection of unsuitable terrain for landing, which resulted in impact with a knoll and a subsequent ground-loop.NTSB ERA20CA138Accident · Serious injuriesData collectionFinal reportLindstrand 180A · Davenport, FLThe pilot’s failure to maintain the proper descent rate during the approach to landing, which resulted in a hard landing and serious injury to a passenger.NTSB DCA20WA039Incident · No injuriesForeign investigationBoeing 767 · Shannon, IrelandThe government of Ireland has notified the NTSB of an incident involving a Boeing 767 airplane that occurred on December 16, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions…NTSB DCA20CA038Accident · Serious injuriesClass 4 · Data collectionFinal reportEmbraer EMB 135KL · Alexandria, LAan encounter with convectively induced turbulence while overflying an area of known convective activity.NTSB ERA20LA055Accident · No injuriesClass 3 · LimitedFinal reportPiper PA18 · New Market, VAThe pilot's improper touchdown, which resulted in a hard landing and an overload failure of the right main landing gear leg and its associated shock/dampener.NTSB DCA20CA040Accident · Serious injuriesClass 4 · Data collectionFinal reportEmbraer EMB145 · Philadelphia, PAAn inadvertent encounter with convective turbulence.NTSB ANC20CA014Accident · No injuriesData collectionFinal reportCessna 172 · Tokyo, JapanThe airplane’s encounter with prop wash while taxiing behind a larger airplane that was conducting a high-power engine run on the same taxiway. Contributing to the accident was the air traffic controller’s failure to inform the smaller airplane’s pilot about…NTSB WPR20WA044Accident · 2 fatalForeign investigationAngel 44 · Mareeba, AustraliaOn December 14, 2019, at 1115 local time, an Angel Aircraft Corporation 44 twin-engine airplane, registration VH-IAZ, collided with terrain near Mareeba Aerodrome, Mareeba Queensland, Australia. Both pilots were fatally injured, and the airplane was…NTSB WPR20CA050Accident · Minor injuriesData collectionFinal reportHead AX8 88B · Las Cruces, NMA burner flameout, which resulted in the pilot's inability to arrest the balloon’s descent and its subsequent impact with power lines as he was trying to relight the burner.NTSB ERA20LA054Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson R44 · San Antonio, TXMaintenance personnel’s failure to complete all necessary steps of a service bulletin and subsequent failure to identify the loose lower actuator bearing support bracket during inspections, which resulted in the misalignment of the clutch actuator, resulted…NTSB WPR20LA042Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Carlsbad, CAThe fatigue failure of the crankshaft. Contributing to the accident was the undocumented installation of the supercharger, which resulted in increased stress on the crankshaft.NTSB GAA20WA103Accident · 1 fatalForeign investigationCessna 150 · Region del Bio Bio, ChileThe government of Chile has notified the NTSB of an accident involving a CESSNA 150 airplane that occurred on December 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions of…NTSB GAA19WA598Accident · Serious injuriesClass 5 · ForeignAerospatiale AS350 · Kitzbühel, AustriaNTSB WPR20TA039Accident · Minor injuriesClass 3Final reportEnstrom F28 · Riverton, UTThe noncertificated pilot’s decision to operate a deregistered helicopter, which resulted in a component failure and subsequent loss of control and hard landing. Contributing to the accident was the lack of recent maintenance on the helicopter.NTSB WPR20LA038Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-34-200T · Phoenix, AZThe pilot’s mismanagement of the fuel onboard, which resulted in a loss of engine power due to fuel starvation. Contributing to the fuel starvation was the erroneous indications on the fuel gauges.NTSB DCA20WA041Incident · No injuriesForeign investigationBoeing 747 · Auckland, New ZealandThe Transport Safety Investigation Bureau (TSIB) of Singapore has informed the NTSB of an incident involving a Boeing 747-400, which occurred on December 10, 2019. The NTSB has appointed a U.S Accredited Representative to assist the TSIB investigation under…NTSB ANC20WA009Accident · 3 fatalForeign investigationPiper PA60 · Nanaimo, CanadaThe government of Canada has notified the NTSB of an accident involving a Piper PA60 airplane that occurred on December 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…NTSB ERA20LA053Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Louisville, KYThe pilot’s improper flare to land, which resulted in a hard landing and the nose landing gear collapsing.NTSB CEN20FA032Accident · 1 fatalClass 3 · FieldFinal reportCessna 208 · Victoria, TXThe pilot’s loss of control due to spatial disorientation. Contributing to the accident were the inoperative attitude indicator and horizontal situation indicator on the pilot’s side of the cockpit, and the pilot’s failure to reference the flight instruments…NTSB ANC20CA037Accident · No injuriesData collectionFinal reportCessna 207 · Kwigillingok, AKThe pilot's improper decision to depart from an ice-covered runway with a strong crosswind, which resulted in a loss of directional control, runway excursion, and impact with a ditch.NTSB ENG20IA006Incident · No injuriesClass 3 · IncidentFinal reportDe Havilland DHC8 · Keene, NHThe arcing failure of the windshield heat L2 power wire on the right windshield due to unknown reasons.NTSB ERA20LA051Accident · Serious injuriesClass 3 · LimitedFinal reportParsons Two Place #1 · Naguabo, PRA failure of the rudder attachment bolt, which resulted in the rudder’s subsequent inflight separation from the fuselage.NTSB ERA20LA050Accident · Minor injuriesClass 3 · LimitedFinal reportZenith Zodiac CH-650 · Willow Springs, MOImproper maintenance practices on the fuel system causing fuel starvation and a total loss of engine power.NTSB CEN20WA210Accident · 2 fatalForeign investigationPiper PA30 · Kaunas, LithuaniaThe government of Lithuania has notified the NTSB of an accident involving a PIPER PA30 airplane that occurred on December 08, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Lithuania's investigation under the…NTSB CEN20FA034Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Flower Pot, AZThe noninstrument-rated pilot’s decision to initiate and continue the visual flight rules flight into an area of forecast instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of airplane control. Contributing was…NTSB WPR20WA081Accident · Minor injuriesForeign investigationOas UH-1H · Williamtown Aerodrome, AustraliaThe government of Australia has notified the NTSB of an accident involving a OAS UH-1H helicopter that occurred on December 07, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…NTSB CEN20TA030Accident · Serious injuriesClass 3Final reportRotary RAF 2000 · Omaha, NEThe pilot's loss of directional control while landing in gusting wind conditions.NTSB CEN20FA035Accident · 2 fatalClass 3 · FieldFinal reportBell 407 · Gulf of Mexico (Gulf of Mexico)A total loss of engine power due to the failure of the engine’s Nos. 3 and 4 bearings and the power turbine pinion gear, and subsequent loss of main rotor rpm, which resulted in a loss of control and impact with the water.NTSB GAA20WA108Incident · No injuriesForeign investigationDe Havilland DHC6 · Pau Pyrenesse, FranceThe government of France has notified the NTSB of an accident involving a DE HAVILLAND DHC6 airplane that occurred on December 06, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the…NTSB DCA20WA152IncidentClass 5 · ForeignBoeing 737 · Paris, FranceNTSB CEN20TA031Accident · No injuriesClass 3Final reportBeech 36 · Spring Branch, TXThe pilot's inadequate preflight performance planning and his operation of the airplane outside of the manufacturer's specified weight and balance limitations, which resulted in a failure of the airplane to become airborne, an aborted takeoff, and subsequent…NTSB WPR20WA037Accident · 1 fatalForeign investigationRobinson R44 · Eschowe, South AfricaThe government of South Africa has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on December 5, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under…NTSB WPR20LA040Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV 6 · Pima, AZA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR20CA041Accident · No injuriesData collectionFinal reportCessna 182 · Camas, WAThe student pilot's improper landing flare, which resulted in a bounced landing, and the flight instructor’s delayed remedial action and the student’s failure to relinquish control, which resulted in a runway overrun and impact with a fence.NTSB DCA20IA034Incident · No injuriesIncident investigationFinal reportAirbus AS 350 B2 · Los Angeles, CAan inflight collision with a hard object of polycarbonate construction, with size and features consistent with that of a small UAS (drone).NTSB ERA20LA047Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Potts Camp, MSThe pilot’s delayed use of carburetor heat, which resulted in carburetor icing and a subsequent total loss of engine power.NTSB CEN20LA029Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8A · Baldwin City, KSThe pilot's failure to maintain directional control during takeoff, and the flight instructor's delayed remedial action, which resulted in a runway excursion and nose over.NTSB WPR20WA251Incident · No injuriesForeign investigationDe Havilland DHC8 · Eaton, AustraliaThe government of Australia has notified the NTSB of an accident involving a De Havilland DHC8 airplane that occurred on December 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…NTSB WPR20CA036Accident · No injuriesData collectionFinal reportJavron PA-18 Replica · Nephi, UTThe passenger’s inadvertent application of the brakes during landing, which resulted in a nose-over.NTSB CEN20LA028Accident · No injuriesClass 3 · LimitedFinal reportBAE BAE125 · Detroit, MIThe pilots’ failure to increase approach speed as recommended for flight in icing conditions, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the failure of the stall warning system to advise the…NTSB GAA20WA102Accident · 1 fatalForeign investigationBeech C90 · Caieiras, SP, BrazilThe government of Brazil has notified the NTSB of an accident involving a BEECH C90 airplane that occurred on December 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB GAA20WA099Accident · No injuriesForeign investigationPiper PA23 · Shannon, IrelandThe government of Ireland has notified the NTSB of an accident involving a PIPER PA23 airplane that occurred on December 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions…NTSB ERA20TA046Accident · No injuriesClass 3Final reportPiper PA28 · Vero Beach, FLThe pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power.