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.
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
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 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB NYC00LA108Accident · No injuriesLimited investigationFinal reportSportavia Putzer RF-5B · Gillespie, PAThe pilot's improper weather evaluation, resulting in a tailwind departure.NTSB NYC00LA107Accident · Minor injuriesLimited investigationFinal reportPagan RV-8A · East Liverpool, OHThe pilot's loss of control during the landing.NTSB 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.NTSB 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)…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CHI00LA102Accident · No injuriesLimited investigationFinal reportBeech A36 · Bloomington, INdirectional control not maintained and maximum gross weight was exceeded by the pilot in command.NTSB 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.NTSB NYC00FA106Accident · 2 fatalField investigationFinal reportCessna 172P · Ballston Spa, NYa loss of control for undetermined reason(s).NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB LAX00WA138Accident · 5 fatalForeign investigationMcDonnell Douglas 369FF · Manapouri, New ZealandNTSB IAD00RA033Accident · No injuriesForeign investigationBell UH-1H · Tingo Mar, PeruNTSB FTW00WA112Accident · No injuriesForeign investigationBell 206B · Puntarenas, Costa RicaNTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB LAX00LA141Accident · 2 fatalLimited investigationFinal reportBirx Vans RV-6 · Taft, CAThe in-flight collision with the ground for undetermined reasons.NTSB 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.NTSB 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…NTSB FTW00LA108Accident · Minor injuriesLimited investigationFinal reportNorth American T-28B · Bridgeport, TXThe partial loss of engine power for an undetermined reason.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB MIA00LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgewater, FLThe partial loss of engine power due to undetermined reasons.NTSB 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.NTSB 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.NTSB 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.NTSB DCA00WA031Incident · No injuriesForeign investigationBoeing B747-267B · Jeddah, Saudi ArabiaNTSB 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.NTSB FTW00LA106Accident · Minor injuriesLimited investigationFinal reportWard Acro · Beasley, TXThe loss of engine power for an undetermined reason.