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 LAX93LA156Accident · No injuriesLimited investigationFinal reportCessna 182F · Chandler, AZThe pilot's inadequate weather evaluation resulting in an inadvertent encounter with gusty wind conditions while taxiing.Mar 19, 1993 · N3211U · Substantial damageNTSB LAX93LA155Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Chandler, AZThe student pilot's failure to maintain directional control of the aircraft and his improper remedial action to correct the situation. A factor in the accident was the student's lack of total experience.Mar 19, 1993 · N89681 · Substantial damageNTSB LAX93FA154Accident · 2 fatalField investigationFinal reportCessna 172M · White Water, CAThe pilot's failure to see and avoid the tower due to drug impairment. Factors which contributed to the accident were: the low altitude and the dawn light condition.Mar 19, 1993 · N12587 · DestroyedNTSB BFO93LA052Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · New Gloucester, MELoss of engine power during takeoff due to undetermined reasons, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall.Mar 19, 1993 · N25881 · Substantial damageNTSB ANC93LA047Accident · No injuriesLimited investigationFinal reportPiper PA-12-150 · Anchorage, AKThe complete loss of engine power due to undetermined reasons. Factor was the deep water forced landing area.Mar 19, 1993 · N4182M · DestroyedNTSB SEA93LA079Accident · No injuriesLimited investigationFinal reportCessna 177 · Buena, WAThe pilot in command's failure to maintain directional control. Factors contributing to the accident were crosswinds and the fence.Mar 18, 1993 · N2899X · DestroyedNTSB SEA93LA078Accident · No injuriesLimited investigationFinal reportSchweizer G-164B-600 · Quincy, WAUnsuitable terrain encountered during a forced landing after an engine cylinder assembly had separated. Factors include a snowbank.Mar 18, 1993 · N7503L · Substantial damageNTSB BFO93LA058Accident · No injuriesLimited investigationFinal reportLearjet 35 · Teterboro, NJImproper planning or decision by the pilot in command (PIC). Factors related to the accident were: darkness, the adverse weather conditions, and the runway/terrain condition.Mar 18, 1993 · N304AF · Substantial damageNTSB BFO93LA051Accident · No injuriesLimited investigationFinal reportCessna 150M · Rochester, NYA fire in the engine compartment due to over-priming.Mar 18, 1993 · N63206 · Substantial damageNTSB BFO93FA049Accident · Minor injuriesField investigationFinal reportBritish Aerospace BAE 3101 · Beckley, WVFailure of the captain to assure proper alignment with the plowed portion of the runway (or perform a missed approach). Factors related to the accident were: darkness, the adverse weather condition, inadequate removal of snow from the runway with snow along…Mar 18, 1993 · N159PC · Substantial damageNTSB LAX93FA153Accident · 6 fatalField investigationFinal reportPiper PA-34-200 · Carpenteria, CAUndetermined.Mar 17, 1993 · N55334 · DestroyedNTSB CHI93LA113Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mason, MIThe pilot-in-command's failure to maintain directional control.Mar 17, 1993 · N2440T · Substantial damageNTSB LAX93LA181Accident · Minor injuriesLimited investigationFinal reportCessna U-206G · Yuma, AZAn inadequate annual inspection which led to a loss of the electrical system due to loose alternator belt, and the pilot's failure to attain the proper touchdown point during a night precautionary landing on an unlit runway.Mar 16, 1993 · N733TH · Substantial damageNTSB LAX93LA152Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Vacaville, CAa loss of engine power for undetermined reason(s).Mar 16, 1993 · N8120H · DestroyedNTSB FTW93TA#03Accident · No injuriesFinal reportBell 206B · Dallas, TXMar 16, 1993 · N3211N · Substantial damageNTSB FTW93LA106Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Mena, ARThe pilot's improper in-flight planning/decision. Factors related to the accident were: the adverse weather conditions, the pilot's improper use of carburetor heat, his improper IFR procedures, darkness, and the high (mountainous) terrain.Mar 16, 1993 · N4341P · Substantial damageNTSB DEN93FA033Accident · 3 fatalField investigationFinal reportHiller UH-12E · Applegate, ORThe pilot initiating flight into known adverse weather. Factors were: low ceiling, fog, and turbulence.Mar 16, 1993 · N5344V · DestroyedNTSB CHI93LA114Accident · Serious injuriesLimited investigationFinal reportBeech F33A · Park, KSThe pilot-in-command's physical incapacitation for reason or reasons undetermined.Mar 16, 1993 · N5592A · Substantial damageNTSB SEA93LA076Accident · No injuriesLimited investigationFinal reportBarr Kitfox II · Sheridan, WYA partial power loss for undetermined reasons. Factors include a strong crosswind on landing.Mar 15, 1993 · N569F · Substantial damageNTSB NYC93IA059Incident · No injuriesIncident investigationFinal reportBoeing 737-130 · Newark, NJInadequate maintenance/inspection by company maintenance personnel, the manufacturer's inadequate inspection and/or replacement procedures for the aileron cables, and subsequent failure of the 'down' aileron control cable due to wear.Mar 15, 1993 · N14212 · No damageNTSB MIA93LA085Accident · No injuriesLimited investigationFinal reportCessna 150M · Fort Pierce, FLInaccurate fuel consumption calculations, resulting in fuel exhaustion.Mar 15, 1993 · N6168K · Substantial damageNTSB LAX93LA151Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Lake Havasu, AZThe improper welding of the inboard boss by an unknown person resulting in a fatigue failure on the inboard boss. A factor related to the accident was the vehicle that was struck during the forced landing.Mar 15, 1993 · N466KT · Substantial damageNTSB FTW93WA107Accident · No injuriesForeign investigationBoeing 727-232 · Guadalajara, MexicoMar 15, 1993 · N527DA · 2 aircraft · Minor damageNTSB FTW93LA104Accident · No injuriesLimited investigationFinal reportCessna 172M · Overbrook, OKThe pilot's failure to assure that the elevator trim was properly set for takeoff and his delay in aborting the takeoffMar 15, 1993 · N9689H · Substantial damageNTSB FTW93FA105Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Radium Springs, NMA total failure of the airplane's vacuum system. Factors which contributed to the accident were: the dark night, snow, the pilot's loss of aircraft control, and the pilot's lack of experience in flying in actual intrument meteorological conditions.Mar 15, 1993 · N47402 · DestroyedNTSB FTW93FA103Accident · 4 fatalField investigationFinal reportBeech 58 · Grants, NMThe pilot's inadequate preflight planning/preparation and the selection of an altitude that would not provide terrain clearance along his planned route. Factors were the dark night conditions and the mountainous terrain.Mar 15, 1993 · N4320W · DestroyedNTSB CHI93FAMS2Accident · 1 fatalMissing aircraftFinal reportPiper PA-28R-200 · Grand Haven, MIundetermined.Mar 15, 1993 · N15206 · DestroyedNTSB LAX93LA150Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Gila Bend, AZThe failure of maintenance personnel to perform mandatory service bulletins during the annual inspection 20 flying hours prior to the accident which resulted in the carburetor's primary venturi becoming loose.Mar 14, 1993 · N4070F · Substantial damageNTSB ANC93LA044Accident · No injuriesLimited investigationFinal reportCessna 185 · Barrow, AKThe pilot in command inadvertently stalling the airplane.Mar 14, 1993 · N61500 · Substantial damageNTSB SEA93LA075Accident · No injuriesLimited investigationFinal reportCessna 172M · Logan-Cache, UTThe pilot's failure to maintain directional control, and insufficient remedial action. Factors include a snow bank near the edge of the runway.Mar 13, 1993 · N13008 · Substantial damageNTSB DEN93FA032Accident · 2 fatalField investigationFinal reportBeech A36 · Englewood, COPower loss due to fuel exhaustion as a result of failing to refuel en route. Factors were: inaccurate fuel consumption calculations, lack of suitable terrain for a forced landing, lack of total experience in the type of aircraft being flown, and becoming lost…Mar 13, 1993 · N4495W · Substantial damageNTSB CHI93LA117Accident · No injuriesLimited investigationFinal reportCessna 150J · Hastings, NEThe pilot's failure to refuel the airplane en route which resulted in an inadequate fuel supply for the flight.Mar 13, 1993 · N50467 · Substantial damageNTSB CHI93IA126Incident · No injuriesIncident investigationFinal reportATR ATR 42 · Chicago, ILAn improper clearance by the north local controller, which resulted in a failure to maintain proper IFR separation. A factor related to the incident was: inadequate coordination among the tower personnel.Mar 13, 1993 · N426MQ · No damageNTSB CHI93IA110Incident · No injuriesIncident investigationFinal reportFokker 100 · Chicago, ILFailure of the company station manager to follow proper dispatch procedures, and ice accumulation on the nose gear locking mechanism. Factors related to the incident were: wet snow (slush) on the runway at the departure airport, and inadequate design which…Mar 13, 1993 · N895US · Minor damageNTSB SEA93LA077Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Burley, IDLanding on the wrong runway and an improper touchdown. Lack of total experience in type of operation was a factor.Mar 12, 1993 · N2438L · Substantial damageNTSB LAX93LA147Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Folsom, CAThe student pilot's excessive rate of descent during a approach for landing, improper remedial action to arrest the rate of descent, and a failure to maintain proper main rotor RPM. The student pilot's lack of total aeronautical experience was a factor in…Mar 12, 1993 · N4072T · Substantial damageNTSB LAX93FA149Accident · 3 fatalField investigationFinal reportCessna 421C · Eagle Mountain, CAFailure of the left elevator for undetermined reason(s), which resulted in flutter and failure of the empennage, and subsequent uncontrolled collision with the terrain.Mar 12, 1993 · N2656N · DestroyedNTSB CHI93FA109Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC-9-31 · Saint Louis, MOThe captain's improper use of thrust reversers and excessive use of engine power. Factors which contributed to the accident were: the crosswind and the first officer's failure to raise the flaps.Mar 12, 1993 · N978Z · Substantial damageNTSB ANC93LA043Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Ketchikan, AKThe pilot selected unsuitable terrain for takeoff. A factor in the accident was the building situated at the end of the takeoff site.Mar 12, 1993 · N67667 · Substantial damageNTSB LAX93LA146Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Avalon, CAThe pilot's poorly planned approach, excessive airspeed, and failure to attain the proper touchdown point. The pilot's lack of familiarity with the airport is a factor in this accident.Mar 11, 1993 · N1808H · Substantial damageNTSB FTW93LA102Accident · No injuriesLimited investigationFinal reportMistretta Challenger II · Albuquerque, NMThe pilot's failure to maintain control of the airplane. A factor was his possible encounter with turbulence.Mar 11, 1993 · N3207C · Substantial damageNTSB FTW93LA101Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Goodwin, ARThe pilot's failure to compensate for the crosswind. A factor was the crosswind.Mar 11, 1993 · N634U · Substantial damageNTSB CHI93LA128Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Bismarck, NDThe pilot's failure to refuel the airplane en route to ensure adequate fuel to complete the flight.Mar 11, 1993 · N88384 · Substantial damageNTSB MIA93LA084Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Village Of Golf, FLThe pilot-in-command's improper movement of the fuel selector valve resulting in fuel starvation, forced landing, and an in-flight collision with terrain.Mar 10, 1993 · N6998Q · Substantial damageNTSB FTW93FA100Accident · Serious injuriesField investigationFinal reportBoeing 727-200 · Houston, TXThe failure of the pilot of the T-38A to follow flight advisories. A factor which contributed to the accident was the development of a letter of agreement between the FAA and NASA which was not in accordance with ICAO procedures.Mar 9, 1993 · N79754 · No damageNTSB ANC93LA042Accident · Minor injuriesLimited investigationFinal reportCessna 180J · Anchorage, AKThe failure of the private certificated/dual student pilot to maintain directional control. A factor in the accident was the failure of the flight instructor/pilot in command to take timely remedial action.Mar 9, 1993 · N9977N · Substantial damageNTSB SEA93LA099Accident · No injuriesLimited investigationFinal reportCessna 172K · Ogden, UTThe pilot in command's failure to maintain directional control. Factors contributing to the accident were soft terrain, excessive airspeed, and crosswinds.Mar 8, 1993 · N1628C · Substantial damageNTSB LAX93FA144Accident · 1 fatalField investigationFinal reportCessna 152 · Apple Valley, CAThe pilot inadvertently stalled the airplane near the ground. The intentional buzzing, over confidence in his personal ability, and poor inflight planning/decision were factors.Mar 8, 1993 · N48860 · DestroyedNTSB FTW93LA113Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Marshall, ARThe pilots failure to maintain directional control. A factor was the fence post.Mar 8, 1993 · N8696D · Substantial damageNTSB FTW93LA099Accident · No injuriesLimited investigationFinal reportCessna 180J · Albuquerque, NMAircraft control not maintained by the pilot. A factor was vibration in the tailwheel for undetermined reasons.Mar 8, 1993 · N7770K · Substantial damage