NTSB investigations

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
  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 CHI00LA105Accident · Minor injuriesLimited investigationFinal reportWeinzierl Titan Tornado II · Maple Plain, MNthe obstructed fuel system filter, the inadequate silicone material the builder used, and the rough and uneven terrain. A factor was that suitable landing terrain was not available.Apr 2, 2000 · N196KW · Substantial damageNTSB CHI00LA104Accident · Minor injuriesLimited investigationFinal reportWilson RAF 2000 GTX SE · Monroe City, MOthe pilot not obtaining clearance from the trees. Factors were the trees and the ravine terrain condition.Apr 2, 2000 · N1964 · Substantial damageNTSB CHI00LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Pine City, MNA loss of engine power due to the failure of the number four cylinder's exhaust valve spring and exhaust valve. Contributing to the accident were, the barbwire fence and the clump of high vegetation encountered by the airplane.Apr 2, 2000 · N54454 · Substantial damageNTSB ANC00LA040Accident · No injuriesLimited investigationFinal reportCessna 150M · Skwentna, AKThe pilot's selection of an unsuitable landing area. Factors associated with the accident were the pilot's disorientation, landing at the wrong airport, flat lighting conditions, and his delay in initiating a go-around.Apr 2, 2000 · N704GK · Substantial damageNTSB NYC00LA115Accident · No injuriesLimited investigationFinal reportMooney M-20F · Parker, PAThe pilot's failure to maintain an adequate visual lookout, due to his distraction with a flock of birds. A factor was the pilot's improper in flight decision to continue the simulated engine failure to too low of an altitude.Apr 1, 2000 · N737HB · Substantial damageNTSB NYC00LA108Accident · No injuriesLimited investigationFinal reportSportavia Putzer RF-5B · Gillespie, PAThe pilot's improper weather evaluation, resulting in a tailwind departure.Apr 1, 2000 · N55GS · Substantial damageNTSB NYC00LA107Accident · Minor injuriesLimited investigationFinal reportPagan RV-8A · East Liverpool, OHThe pilot's loss of control during the landing.Apr 1, 2000 · N565BW · Substantial damageNTSB DEN00LA069Accident · Minor injuriesLimited investigationFinal reportHawkins & Powers UH-1B · Helper, UTTotal failure of the number 1 bearing due to lack of lubrication, the oil flow being restricted by a foreign object (epoxy hardener). Factors were trees and the unavailability of suitable terrain for a forced landing.Apr 1, 2000 · N50330 · DestroyedNTSB CHI00LA101Accident · 1 fatalLimited investigationFinal reportAerotek Pitts S-2A · Shelbyville, ILthe proper touchdown point and proper alignment not attained by the pilot. Contributing factors were the unmarked golf cart, color, and lack of a radio. Additional factors were the runway maintenance performed by the driver of the golf cart and the NOTAM(s)…Apr 1, 2000 · N224V · Substantial damageNTSB SEA00LA059Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Odessa, WADisintegration of a lining of the right brake and subsequent lodging of brake lining debris between the brake housing and brake disc, resulting in seizure of the right brake. A factor was that directional control was not possible.Mar 31, 2000 · N3662X · Substantial damageNTSB MIA00LA125Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Rocky Mount, NCThe pilot's inadvertent VFR flight into IMC conditions and the failure of the pilot to maintain altitude/clearance resulting in the in-flight collision with trees and unmarked power lines during a visual approach to the runway.Mar 31, 2000 · N8230V · Substantial damageNTSB IAD00LA030Accident · Serious injuriesLimited investigationFinal reportMaule M-4-220C · Lincoln Park, NJthe pilot's failure to maintain control during landing roll. A factor was the crosswind.Mar 31, 2000 · N2060U · Substantial damageNTSB IAD00IA032Incident · No injuriesIncident investigationFinal reportBoeing 767-332 · New York City, NYThe first officer's failure to maintain control of the airplane during climb out over water at night, which was a result of spatial disorientation. Factors in the incident were the cloud layer and dark night.Mar 31, 2000 · N182DN · No damageNTSB FTW00LA115Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Addison, TXThe loss of engine power for reasons undetermined. A factor was the lack of suitable terrain for the forced landing.Mar 31, 2000 · N6046J · Substantial damageNTSB CHI00LA108Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Arlington, SDthe CFI's improper use of the throttle control during a simulated loss of engine power emergency. A factor associated with the accident was the rough terrain on which the forced landing was conducted.Mar 31, 2000 · N8371V · Substantial damageNTSB CHI00LA102Accident · No injuriesLimited investigationFinal reportBeech A36 · Bloomington, INdirectional control not maintained and maximum gross weight was exceeded by the pilot in command.Mar 31, 2000 · N91TD · Substantial damageNTSB NYC00LA111Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · East Haddam, CTThe private pilots failure to obtain the proper touchdown point and the CFI's delay in remedial action.Mar 30, 2000 · N8041B · Substantial damageNTSB NYC00FA106Accident · 2 fatalField investigationFinal reportCessna 172P · Ballston Spa, NYa loss of control for undetermined reason(s).Mar 30, 2000 · N98574 · DestroyedNTSB LAX00FA144Accident · 4 fatalField investigationFinal reportCommander 114 · Hanford, CAundetermined. The pilot's failure to reject the takeoff and his failure to retract the landing gear following liftoff were factors.Mar 30, 2000 · N516CA · DestroyedNTSB CHI00LA100Accident · No injuriesLimited investigationFinal reportPiper J-3C · Eureka, SDthe foreign object (shot gun shell) which jammed the control stick. Factors associated with the accident were the low altitude at which the control stick jammed and the rough terrain which the airplane contacted.Mar 30, 2000 · N71060 · Substantial damageNTSB ANC00TA039Accident · No injuriesFinal reportBell 206B · Manokotak, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors in the accident were low ceilings and snow, and snow-covered terrain.Mar 30, 2000 · N5006R · Substantial damageNTSB SEA00IA057Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300-600 · Seattle, WAAn oil leak from the aircraft's APU that subsequently contaminated the aircraft's environmental system.Mar 29, 2000 · N667FE · No damageNTSB MIA00LA124Accident · No injuriesLimited investigationFinal reportCessna 172P · St. Petersburg, FLThe failure of the pilot to maintain clearance between the left wingtip and a hangar door resulting in the on-ground collision.Mar 29, 2000 · N9400L · Substantial damageNTSB MIA00LA123Accident · Minor injuriesLimited investigationFinal reportAyres S2R-G10 · Leesburg, GAThe failure of the pilot to maintain clearance during a spray pass resulting in the in-flight collision with the raised rows of the field.Mar 29, 2000 · N4089Q · Substantial damageNTSB SEA00LA058Accident · No injuriesLimited investigationFinal reportCessna 170B · Lopez Island, WAThe pilot's failure to maintain aircraft control during landing. Contributing factors were the crosswind condition, gusts, and the pilot's overall lack of total (flight and tail wheel) experience.Mar 28, 2000 · N4653C · Substantial damageNTSB NYC00LA103Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Renick, WVThe pilot's improper weather evaluation, and subsequent improper decision to fly into forecast and known icing conditions that exceeded the capability of the airplane to maintain flight. A factor was the icing conditions.Mar 28, 2000 · N1830Q · Substantial damageNTSB LAX00WA138Accident · 5 fatalForeign investigationMcDonnell Douglas 369FF · Manapouri, New ZealandMar 28, 2000 · ZKHJN · DestroyedNTSB IAD00RA033Accident · No injuriesForeign investigationBell UH-1H · Tingo Mar, PeruMar 28, 2000NTSB FTW00WA112Accident · No injuriesForeign investigationBell 206B · Puntarenas, Costa RicaMar 28, 2000 · N9GA · Substantial damageNTSB FTW00LA109Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Decatur, TXThe instructor pilot's failure to maintain the minimum controllable airspeed during a simulated emergency approach, which resulted in a stall.Mar 28, 2000 · N94912 · Substantial damageNTSB ATL00LA039Accident · Serious injuriesLimited investigationFinal reportAlon A-2A · Hernando, FLLoss of power due to carburetor contamination. Factors, were the trees, and the weather conditions were conducive to carburetor icing.Mar 28, 2000 · N67HS · Substantial damageNTSB NYC00LA105Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Keene, NHThe CFI's failure to perform remedial action in a timely manner which resulted in a hard landing during the practice autorotation. A factor in this accident was the CFI's lack of total experience as a flight instructor.Mar 27, 2000 · N2260W · Substantial damageNTSB MIA00GA121Accident · 2 fatalFinal reportHughes 269C · Del Rio, TXAn in-flight loss of control while maneuvering for undetermined reasons resulting in an in-flight collision with terrain. A factor in the accident was the in-flight loss of engine power and rotor rpm.Mar 27, 2000 · N1110N · DestroyedNTSB MIA00FA118Accident · 1 fatalField investigationFinal reportPiper PA-24-260 · Panama City, FLThe pilot experiencing spatial disorientation while reversing course during a dark night while over water which resul;ted in an in-flight collision with water. A factor was the dark night lighting conditions.Mar 27, 2000 · N9204P · DestroyedNTSB LAX00LA141Accident · 2 fatalLimited investigationFinal reportBirx Vans RV-6 · Taft, CAThe in-flight collision with the ground for undetermined reasons.Mar 27, 2000 · N986DB · DestroyedNTSB LAX00LA140Accident · 1 fatalLimited investigationFinal reportStuart RAF 2000 GTX SE · Overton, NVFailure of the pilot to obtain/maintain aircraft control. A factor in the accident was the pilot's inexperience in rotorcraft.Mar 27, 2000 · N60739 · DestroyedNTSB LAX00FA136Accident · Serious injuriesField investigationFinal reportAerospatiale AS350B · Van Nuys, CAthe pilot's failure to land as soon as practical and to utilize the available accumulator pressure to transition from hover to flight. Contributing to the accident was the pilot's physical stature and strength, and the inadequate and incomplete emergency…Mar 27, 2000 · N500WC · DestroyedNTSB FTW00LA108Accident · Minor injuriesLimited investigationFinal reportNorth American T-28B · Bridgeport, TXThe partial loss of engine power for an undetermined reason.Mar 27, 2000 · N28NE · Substantial damageNTSB CHI00LA096Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec PZL-M-18 · Bucklin, KSthe right main gear brake was binding for an undetermined reason which resulted in the pilot's inability to maintain directional control of the airplane.Mar 27, 2000 · N27301 · Substantial damageNTSB ANC00LA038Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Fairbanks, AKThe pilot's misjudgment of distance/altitude, and subsequent undershoot during landing. Factors in the accident were light snow precipitation, flat light conditions, snow-covered terrain, and the absence of a visual approach slope indicator.Mar 27, 2000 · N8540F · Substantial damageNTSB NYC00LA110Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Waynesburg, PAThe private pilot's inadequate compensation for wind conditions and the flight instructor's delay in remedial action. A factor in the accident was the gusting wind conditions.Mar 26, 2000 · N88340 · Substantial damageNTSB NYC00LA099Accident · No injuriesLimited investigationFinal reportCessna 172 · Sissonville, WVThe pilot's failure to maintain runway alignment during takeoff. A factor in the accident was wind gusts.Mar 26, 2000 · N7879T · Substantial damageNTSB NYC00LA098Accident · Serious injuriesLimited investigationFinal reportPiper PA28R-200 · Lehighton, PAThe pilot's inadequate compensation for the crosswind. A factor in this accident was the gusty crosswind condition.Mar 26, 2000 · N55820 · DestroyedNTSB MIA00LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgewater, FLThe partial loss of engine power due to undetermined reasons.Mar 26, 2000 · N757JE · Substantial damageNTSB MIA00LA119Accident · Minor injuriesLimited investigationFinal reportBair Helicopters Searey · Kill Devil Hill, NCThe inadvertent stall by the pilot-in-command while on final approach resulting in the uncontrolled descent and in-flight collision with water.Mar 26, 2000 · N246DB · Substantial damageNTSB FTW00LA105Accident · No injuriesLimited investigationFinal reportSchweizer 300C · New Ulm, TXThe pilot's inadequate in-flight evaluation of the landing area, which resulted in the separation of the main rotor system as a result of foreign object damage.Mar 26, 2000 · N698SM · Substantial damageNTSB FTW00FA103Accident · 1 fatalField investigationFinal reportCessna 525 · Buda, TXthe pilot's inadequate in-flight decision to continue a visual approach in instrument meteorological conditions which resulted in his failure to maintain terrain clearance. Contributing factors were the fog, drizzle, and low ceilings.Mar 26, 2000 · N130MR · DestroyedNTSB DCA00WA031Incident · No injuriesForeign investigationBoeing B747-267B · Jeddah, Saudi ArabiaMar 26, 2000 · APBCO · Substantial damageNTSB LAX00LA135Accident · No injuriesLimited investigationFinal reportCessna 172 · Corona, CAThe pilot's inadequate weather evaluation, and his improper remedial actions that led to a precautionary landing and subsequent attempted takeoff from unsuitable terrain.Mar 25, 2000 · N7354A · Substantial damageNTSB FTW00LA106Accident · Minor injuriesLimited investigationFinal reportWard Acro · Beasley, TXThe loss of engine power for an undetermined reason.Mar 25, 2000 · N79RW · Substantial damage