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 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.Jan 28, 1990 · N44068 · DestroyedNTSB 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.Jan 28, 1990 · N1528X · Substantial damageNTSB LAX90LA079Accident · No injuriesLimited investigationFinal reportCessna 152 · Bermuda Dunes, CAThe student pilot's improper flare, and failure to avoid or correct the resultant porpoise.Jan 28, 1990 · N24988 · Substantial damageNTSB 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.Jan 28, 1990 · N4542E · Substantial damageNTSB CHI90DEM02Accident · Serious injuriesFinal reportMaxair MU532 · Vicksburg, MIThe pilot's failure to maintain adequate airspeed while performing manuevers.Jan 28, 1990 · UNREG · DestroyedNTSB ATL90LA058Accident · No injuriesLimited investigationFinal reportBeech C24R · Greer, SCThe pilot in command's improper flare which resulted in a hard landing.Jan 28, 1990 · N66336 · Substantial damageNTSB 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.Jan 28, 1990 · N8849T · Substantial damageNTSB 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.Jan 27, 1990 · N12528 · Substantial damageNTSB 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…Jan 27, 1990 · N75946 · DestroyedNTSB MIA90WA062Accident · No injuriesForeign investigationPiper PA-23-250 · Congotown, Congo - KinshasaJan 26, 1990 · N6086Y · Substantial damageNTSB 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…Jan 26, 1990 · HK201 · DestroyedNTSB 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.Jan 26, 1990 · N8199E · Substantial damageNTSB FTW90LA058Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Austin, TXFailure of the rocker arm in the engine driven fuel pump.Jan 25, 1990 · N30057 · Substantial damageNTSB 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.Jan 25, 1990 · N48K · Substantial damageNTSB 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.Jan 24, 1990 · N8298K · Substantial damageNTSB MIA90LA061Accident · 2 fatalLimited investigationFinal reportCessna 152 · Missing, FLUndetermined.Jan 24, 1990 · N4802B · DestroyedNTSB 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.Jan 24, 1990 · N5483V · DestroyedNTSB CHI90DET03Accident · 1 fatalFinal reportPterodactyl Ascender II+2 · Lake Village, INIn-flight structural failure of the right wing spar.Jan 24, 1990 · UNREG · Substantial damageNTSB ATL90LA054Accident · No injuriesLimited investigationFinal reportSwearingen SA 226TC · Morrisville, NCImproper installation of the landing gear door actuator fork assembly by company maintenance personnel.Jan 24, 1990 · N396AV · Substantial damageNTSB FTW90LA060Accident · 1 fatalLimited investigationFinal reportAerospatiale AS355F-1 · High Island Ao6Undetermined due to the lack of physical evidence.Jan 23, 1990 · N5791N · DestroyedNTSB 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.Jan 23, 1990 · N40RP · Substantial damageNTSB 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.Jan 22, 1990 · N8013K · DestroyedNTSB 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.Jan 22, 1990 · UNREG · DestroyedNTSB MKC90LA050Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Satanta, KSDirectonal control was not maintained by the pilot in command.Jan 21, 1990 · N4022X · Substantial damageNTSB LAX90LA080Accident · Serious injuriesLimited investigationFinal reportAdams A55 · Glendale, AZImproper planning/decision by the pilot. The unexpected high wind condition was a related factor.Jan 21, 1990 · N4021L · No damageNTSB LAX90LA075Accident · No injuriesLimited investigationFinal reportBellanca 14-19-2 · Palos Verdes, CALoss of engine power for undetermined reasons.Jan 21, 1990 · N7654B · DestroyedNTSB 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).Jan 21, 1990 · N2258R · Substantial damageNTSB 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…Jan 21, 1990 · N2572Y · Substantial damageNTSB 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.Jan 21, 1990 · N9892Q · Substantial damageNTSB 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.Jan 21, 1990 · N3712X · DestroyedNTSB 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…Jan 21, 1990 · N1802R · Substantial damageNTSB SEA90FA036Accident · 2 fatalField investigationFinal reportPiper PA-18 · Longmire, WAUndetermined.Jan 20, 1990 · N7216K · DestroyedNTSB 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.Jan 20, 1990 · N66787 · DestroyedNTSB 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.Jan 20, 1990 · N124AA · No damageNTSB MIA90FA060Accident · 2 fatalField investigationFinal reportPiper J-3 · Clewiston, FLFailure of the pilot to secure the flight control stick (inadequate preflight) before takeoff.Jan 20, 1990 · N88125 · DestroyedNTSB 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.Jan 20, 1990 · N38908 · Substantial damageNTSB 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.Jan 20, 1990 · N4898L · Substantial damageNTSB 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.Jan 20, 1990 · N727G · Substantial damageNTSB 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…Jan 20, 1990 · N34860 · Substantial damageNTSB 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.Jan 20, 1990 · N338UA · Minor damageNTSB 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.Jan 19, 1990 · N231FH · DestroyedNTSB 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.Jan 19, 1990 · N6017G · DestroyedNTSB 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…Jan 19, 1990 · N38389 · DestroyedNTSB 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…Jan 19, 1990 · N46TE · DestroyedNTSB 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.Jan 19, 1990 · N661AB · Substantial damageNTSB 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…Jan 19, 1990 · N8251B · DestroyedNTSB 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.Jan 19, 1990 · N99SR · Substantial damageNTSB 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…Jan 19, 1990 · N44UE · 2 aircraft · DestroyedNTSB CHI90LA068Accident · No injuriesLimited investigationFinal reportCessna 150H · Sullivan, INThe student pilot's inadequate compensation for the wind gust and lack of total experience.Jan 19, 1990 · N50292 · Substantial damageNTSB 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.Jan 19, 1990 · N551C · Substantial damage