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 NYC90LA058Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Roxbury, MEPilot factor in that he failed to plan the approach for gusty wind conditions and impacted trees short of the runway.NTSB MIA90LA063Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Orlando, FLThe pilot misjudged clearance between his aircraft and a parked aircraft, while turning on the taxiway. Factors related to the accident were: darkness and pilot fatigue.NTSB LAX90LA079Accident · No injuriesLimited investigationFinal reportCessna 152 · Bermuda Dunes, CAThe student pilot's improper flare, and failure to avoid or correct the resultant porpoise.NTSB FTW90FA059Accident · 1 fatalField investigationFinal reportAeronca 7DC · El Paso, TXPower loss due to failure of the carburetor assembly and the pilot's failure to correct known deficiencies. Factors were contaminated fuel, partially blocked fuel screen, fouled spark plugs, the rough terrain, and the lack of shoulder harnesses.NTSB CHI90DEM02Accident · Serious injuriesFinal reportMaxair MU532 · Vicksburg, MIThe pilot's failure to maintain adequate airspeed while performing manuevers.NTSB ATL90LA058Accident · No injuriesLimited investigationFinal reportBeech C24R · Greer, SCThe pilot in command's improper flare which resulted in a hard landing.NTSB ANC90FA032Accident · Minor injuriesField investigationFinal reportCessna 182 · Anchorage, AKImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Factors related to the accident were: the obstructions (utility pole, power line & fence) in the emergency landing area.NTSB LAX90LA078Accident · No injuriesLimited investigationFinal reportCessna 172 · Inyokern, CAImproper in-flight planning/decision by the pilot-in-command (PIC), and his failure to maintain adequate airspeed while maneuvering, which resulted in an inadvertent stall/mush.NTSB BFO90LA022Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Gaithersburg, MDInadequate supervision by the instructor pilot (CFI), which resulted in failure to maintain airspeed and a subsequent stall. Factors related to the accident were: gusty/crosswind conditions, the student pilot's inadequate compensation for wind conditions and…NTSB MIA90WA062Accident · No injuriesForeign investigationPiper PA-23-250 · Congotown, Congo - KinshasaNTSB DCA90MA019Accident · 73 fatalClass 1 · MajorFinal reportBoeing 707-321B · Cove Neck, NYThe failure of the flightcrew to adequately manage the airplane's fuel load, and their failure to communicate an emergency fuel situation to air traffic control before fuel exhaustion occurred. Contributing to the accident was the flightcrew's failure to use…NTSB ATL90LA057Accident · No injuriesLimited investigationFinal reportMooney M20A · Parris Island, SCThe failure of the pilot to insure that sufficient fuel was aboard for the flight, resulting in fuel exhaustion.NTSB FTW90LA058Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Austin, TXFailure of the rocker arm in the engine driven fuel pump.NTSB CHI90LA072Accident · No injuriesLimited investigationFinal reportBeech E18S · Oak Creek, WIImproper planning/decision by the pilot. Factors related to the accident were: the adverse weather conditions, accumulation of structural and/or induction ice, and dark night.NTSB MKC90LA051Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Conway, ARThe pilot failed to attain the proper touchdown point and the delayed initiation of the go-around. Contributing to the accident was the fence struck during the aborted landing.NTSB MIA90LA061Accident · 2 fatalLimited investigationFinal reportCessna 152 · Missing, FLUndetermined.NTSB FTW90DRA02Accident · Serious injuriesFinal reportNorth American P-51-D · Galveston, TXThe pilot in command's failure to obtain a weather briefing. Ontributing to the accident was his inadequate inflight planning and the resultant low fuel state.NTSB CHI90DET03Accident · 1 fatalFinal reportPterodactyl Ascender II+2 · Lake Village, INIn-flight structural failure of the right wing spar.NTSB ATL90LA054Accident · No injuriesLimited investigationFinal reportSwearingen SA 226TC · Morrisville, NCImproper installation of the landing gear door actuator fork assembly by company maintenance personnel.NTSB FTW90LA060Accident · 1 fatalLimited investigationFinal reportAerospatiale AS355F-1 · High Island Ao6Undetermined due to the lack of physical evidence.NTSB ATL90LA053Accident · No injuriesLimited investigationFinal reportMitsubishi MU2B-20 · Nashville, TNInadequate maintenance adjustment of the landing gear system which resulted in the jamming of the left gear door.NTSB LAX90LA076Accident · Serious injuriesLimited investigationFinal reportRobinson R22B · Parlier, CAThe pilot's flight into the known adverse weather and his inadvertent descent to the ground. Factors in the accident were: the fog condition and spatial disorientation of the pilot.NTSB CHI90DET02Accident · 1 fatalFinal reportAir Command 532 · Munster, INThe pilot's exceeding the design stress limits of the aircraft. Factors in the accident were the pilot's ostentatious display and his lack of total experience in type aircraft.NTSB MKC90LA050Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Satanta, KSDirectonal control was not maintained by the pilot in command.NTSB LAX90LA080Accident · Serious injuriesLimited investigationFinal reportAdams A55 · Glendale, AZImproper planning/decision by the pilot. The unexpected high wind condition was a related factor.NTSB LAX90LA075Accident · No injuriesLimited investigationFinal reportBellanca 14-19-2 · Palos Verdes, CALoss of engine power for undetermined reasons.NTSB LAX90LA074Accident · No injuriesLimited investigationFinal reportRobinson R22 · Ramona, CAThe pilot encountered a tailwind while on final approach, but delayed the go-around. During the go-around the pilot failed to maintain airspeed and entered a descent (settling with power).NTSB LAX90LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Coalinga, CAThe pilot's misjudgement of distance and altitude to the runway, while on final approach, which resulted in his failure to attain the proper touchdown point for landing. Factors related to the accident were: darkness, haze, and soft terrain in the area where…NTSB FTW90LA057Accident · No injuriesLimited investigationFinal reportCessna 172M · Goliad, TXThe pilot in command's failure to identify and correct for carburetor icing conditions which existed at the time of the accident and precipitated the precautionary landing.NTSB FTW90LA054Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Bastrop, LALoss of engine power due to water contamination in the fuel. A factor related to the accident was: inadequate design of the fuel system drains, which prevented an adequate preflight of the fuel system.NTSB ANC90LA031Accident · No injuriesLimited investigationFinal reportCessna 185 · Willow, AKSelection of an unsuitable landing area (unsuitable terrain) by the pilot. Factors related to the accident were: deep snow on the runway and failure of the flight service station (fss) specialist to inform the pilot that the runway was closed to wheel…NTSB SEA90FA036Accident · 2 fatalField investigationFinal reportPiper PA-18 · Longmire, WAUndetermined.NTSB NYC90LA055Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Schuyler, NYThe pilot's improper use of carburetor heat, which resulted in a loss of engine power due to carburetor ice.NTSB MIA90LA058Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-10-10 · San Juan, PRInadvertent flight of the airplane into an area of turbulence associated with a developing rain storm.NTSB MIA90FA060Accident · 2 fatalField investigationFinal reportPiper J-3 · Clewiston, FLFailure of the pilot to secure the flight control stick (inadequate preflight) before takeoff.NTSB LAX90LA108Accident · No injuriesLimited investigationFinal reportPiper PA-32-R-300 · Sacramento, CAAn inadvertent collision with a large bird during the hours of darkness while in the landing pattern.NTSB LAX90LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · El Cajon, CAThe student pilot's failure to maintain directional control during a full stop landing in calm winds.NTSB LAX90LA071Accident · No injuriesLimited investigationFinal reportNorth American Navion · Apple Valley, CAThe pilot failed to properly preflight the airplane and departed on the accident flight with minimal fuel.NTSB CHI90LA071Accident · No injuriesLimited investigationFinal reportCessna 177B · Acme, MIThe student pilot misjudged distance and altitude to the runway, and the instructor pilot (CFI) failed to attain remedial action, which resulted in their failure to attain the proper touchdown point. Factors related to the accident were: the cfi's lack of…NTSB CHI90IA070Incident · No injuriesIncident investigationFinal reportBoeing B737-300 · Cedar Rapids, IAThe failure of all four main landing gear tires on takeoff due to the parking brake being locked.NTSB NYC90LA053Accident · Minor injuriesLimited investigationFinal reportMooney M20 · Brogue, PAOff airport landing due to an engine power loss due to failure of the no. 2 crankshaft bearing.NTSB NYC90LA052Accident · Serious injuriesLimited investigationFinal reportCessna C150 · E. Prospect, PAPilot's improper execution of emergency procedures after the engine failed. The pilot lost control of the airplane while maneuver the airplane back to the airstrip during the forced landing. The pilot stalled the airplane at too low an altitude to recover.NTSB NYC90FA051Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Great Barrngton, MAFailure of the pilot to maintain proper altitude and clearance from trees while departing from the airport. Factors related to the accident were: the pilot's inadequate preflight planning/preparation, his allowing the aircraft weight and balance to be…NTSB MKC90MA049Accident · 7 fatalMajor investigationFinal reportGrumman G1159 · Little Rock, ARFailure of the pilot-in-command to follow IFR procedures (maintain an ILS glide path or initiate a missed approach) during an IFR arrival to the airport. Factors related to the accident were: unfavorable weather conditions, an erroneous wind indication from…NTSB MIA90LA059Accident · No injuriesLimited investigationFinal reportBiagi, Arthur R. Buccaneer II XA650 · Lake Wales, FLEngine failure due to a hole that chafed in a fuel line on the suction side of the fuel filter due to poor maintenance.NTSB LAX90FA070Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Burbank, CAPoor judgement of the instructor pilot (CFI) due to his impairment from use of marijuana, inadequate supervision of the flight by the CFI, and his failure to assure that adequate airspeed was maintained, which resulted in an inadvertent stall. Factors related…NTSB DEN90LA047Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-25 · Broomfield, COLoss of directional control by the pilot, during takeoff ground run. Contributing to this accident were a loss of power on the left engine due to snow ingestion, heavy snow showers in progress and an icy, snow covered runway.NTSB DCA90MA017Accident · 1 fatalClass 1 · MajorFinal reportBeech A100 · Atlanta, GA(1) Failure of the federal aviation administration to provide air traffic control procedures that adequately take into consideration human performance factors such as those which resulted in the failure of the north local controller to detect the developing…NTSB CHI90LA068Accident · No injuriesLimited investigationFinal reportCessna 150H · Sullivan, INThe student pilot's inadequate compensation for the wind gust and lack of total experience.NTSB ANC90LA030Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Anchorage, AKThe pilot misjudged his distance and altitude to the runway on final approach, and failed to attain the proper touchdown point. Factors related to the accident were: dark night, unfavorable wind wind conditions and snow covered terrain.