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 ANC93LA150Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Galena, AKThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain on which to make a forced landing.Aug 16, 1993 · N86361 · Substantial damageNTSB NYC93LA160Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Moneta, VAThe pilot's loss of directional control after landing, resulting in a departure from the runway and a collision with trees.Aug 15, 1993 · N4306C · Substantial damageNTSB NYC93LA157Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Beach Haven, NJFailure of the banner release system to function for an undetermined reason, which resulted in an inability of the aircraft to sustain flight once the banner began dragging in the water. A factor related to the accident was: lack of coordination between the…Aug 15, 1993 · N53136 · Substantial damageNTSB NYC93LA156Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Lawrence, MAThe improper installation of the battery box cover by maintenance personnel.Aug 15, 1993 · N30393 · Substantial damageNTSB NYC93LA155Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Lyndonville, VTAn inadvertent stall of the airplane as a result of the pilot's failure to maintain adequate airspeed and improper use of the carburetor heat and flaps during takeoff which degraded aircraft performance.Aug 15, 1993 · N2807S · Substantial damageNTSB NYC93FA158Accident · 1 fatalField investigationFinal reportCessna 172N · Lincoln Park, NJThe failure of both pilots to maintain adequate visual lookout while in the airport traffic pattern, which resulted in an in-flight collision.Aug 15, 1993 · N5226E · 2 aircraft · DestroyedNTSB LAX93LA324Accident · Serious injuriesLimited investigationFinal reportSchweizer 1-35C · Wickenburg, AZthe pilot's failure to maintain an adequate airspeed margin while maneuvering to land, resulting in an inadvertent stall/spin.Aug 15, 1993 · N2562H · DestroyedNTSB LAX93LA323Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Chico, CAthe observer's failure to properly secure stowed items in the rear compartment prior to takeoff and the resultant foreign object damage to the tail rotor system which precluded the pilot from maintaining directional control.Aug 15, 1993 · N8606F · Substantial damageNTSB DEN93LA102Accident · No injuriesLimited investigationFinal reportCessna 140A · Lake Arthur, NMThe pilot's failure to maintain directional control of the aircraft during landing roll.Aug 15, 1993 · N1142D · Substantial damageNTSB CHI93LA324Accident · Minor injuriesLimited investigationFinal reportBellanca BL-17-30 · Lee'S Summit, MOimproper maintenance which resulted in a disconnected throttle lever linkage.Aug 15, 1993 · N4846V · Substantial damageNTSB CHI93LA323Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Ellis, KSthe pilot's inadequate preflight planning and preparation. Factors in the accident are the pilot's premature liftoff, his failure to keep the airplane properly aligned during the initial climb, and the high density altitude.Aug 15, 1993 · N9666D · Substantial damageNTSB CHI93FA322Accident · 2 fatalField investigationFinal reportPiper J-3C-85 · Salol, MNThe pilot's failure to maintain adequate airspeed resulting in an aerodynamic stall. The pilot's lack of recent flight experience is a related factor.Aug 15, 1993 · N6301H · DestroyedNTSB ANC93T#A04Accident · No injuriesClass 3Final reportCessna 185 · Nome, AKAug 15, 1993 · N3374R · Substantial damageNTSB ANC93LA154Accident · No injuriesLimited investigationFinal reportHelio H-295 · Mt. Deborah, AKFailure of the right main landing gear leg due to the improper major repair performed on the gear leg by some unknown maintenance person(s).Aug 15, 1993 · N42DC · Substantial damageNTSB NYC93FA154Accident · 1 fatalField investigationFinal reportCessna 182A · East Moriches, NYEngine failure due to a fatigue failure of the no.3 piston. The fatigue failure was a result of inadequate manufacturing. In addition, the pilot made an improper decision during the forced landing in attempting to stretch his approach in order to reach the…Aug 14, 1993 · N5010D · DestroyedNTSB CHI93DEE05Accident · Serious injuriesFinal reportWeatherly 620 · Mendota, ILThe pilot-in-command's failure to maintain clearance fom powerlines during an aerial application manuever.Aug 14, 1993 · N4605P · DestroyedNTSB ANC93LA147Accident · No injuriesLimited investigationFinal reportCessna 185 · Point Barrow, AKFuel exhaustion as a result of the pilot in command's not refueling. A factor in the accident was the operator/management inadequate flight following and operational control over the flight.Aug 14, 1993 · N20752 · Substantial damageNTSB ANC93LA146Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Nome, AKFuel exhaustion due to the pilot in commands improper preflight planning/preparation.Aug 14, 1993 · N6SF · DestroyedNTSB ANC93LA144Accident · Minor injuriesLimited investigationFinal reportGrumman G-21 · Togiak River, AKThe pilot in command's improper preflight decision making and selection of unsuitable terrain for takeoff.Aug 14, 1993 · N1530H · Substantial damageNTSB NYC93LA153Accident · No injuriesLimited investigationFinal reportCessna 172RG · Philadelphia, PAFailure of the cessa pilot to remain clear of the parked Beech C90.Aug 13, 1993 · N6419V · 2 aircraft · Substantial damageNTSB FTW93LA239Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Garwood, TXThe partial power loss for undetermined reasons. A factor was the lack of suitable terrain onto which a forced landing could be executed.Aug 13, 1993 · N7993 · Substantial damageNTSB ANC93LA142Accident · No injuriesLimited investigationFinal reportCessna 172 · Black Rapids, AKThe pilot's improper in-flight planning/decision, and his delay in taking remedial action. Factor was the rough, uneven terrain.Aug 13, 1993 · N65626 · Substantial damageNTSB SEA93LA176Accident · No injuriesLimited investigationFinal reportCessna 185C · Stibnite, IDLeakage of hydraulic brake fluid and improper maintenance by the pilot in command. A factor contributing to the accident was inadequate inspection by the mechanic.Aug 12, 1993 · N2690Z · Substantial damageNTSB SEA93LA175Accident · No injuriesLimited investigationFinal reportEkins Protech PT2C Prostar · Nephi, UTThe pilot's inadequate preflight inspection which resulted in loss of engine power due to fuel contamination. Factors contributing to the accident was the wet landing surface and terrain condition - ditch.Aug 12, 1993 · N123EK · Substantial damageNTSB NYC93GA151Accident · Serious injuriesFinal reportEnstrom F-28C · Gallipolis, OHThe pilot's improper use of the collective and throttle which resulted in a low rotor rpm condition and a loss of control, and an inflight collision with the terrain.Aug 12, 1993 · N51786 · Substantial damageNTSB MIA93LA174Accident · No injuriesLimited investigationFinal reportCessna 150F · Pembroke Pines, FLTotal loss of engine power caused by fuel exhaustion and inadequate preflight planning/preparation by the pilot-in-command. Contributing to the accident was the inaccurate fuel quantity gauges and the lack of suitable terrain for the forced landing.Aug 12, 1993 · N7873F · Substantial damageNTSB FTW93LA238Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Pioneer, LAThe failure by both pilots to maintain visual lookout. Factors were the inadequate radio communications by both pilots, and the departing pilot's failure to follow procedures and directives.Aug 12, 1993 · N8227K · 2 aircraft · Substantial damageNTSB CHI93LA321Accident · No injuriesLimited investigationFinal reportR.D. Bell/Pietenpol Aircamper · Pontiac, MIThe pilot in command not maintaining a proper descent rate during the final approach and landing flare phase of flight.Aug 12, 1993 · N194BB · Substantial damageNTSB CHI93LA320Accident · Minor injuriesLimited investigationFinal reportBell 47-G5 · Schaumburg, ILthe pilot's improper autorotation techniques.Aug 12, 1993 · N1347X · Substantial damageNTSB NYC93LA152Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Erwinna, PAThe pilot's failure to maintain aircraft control which resulted in a nose over. A rough uneven runway, and the pilot's diverted attention are contributing factors.Aug 11, 1993 · N777DD · Substantial damageNTSB NYC93LA150Accident · No injuriesLimited investigationFinal reportErco 415D · Thomaston, METhe improper weather evaluation by the non-instrument-rated pilot, and the subsequent VFR flight into instrument meteorologial conditions, resulting in a collision with the terrain.Aug 11, 1993 · CFJUB · Substantial damageNTSB NYC93LA147Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Stonington, CTThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/spin, and the pilot's improper use of the carburetor heat which resulted in the accretion of carburetor ice. A factor was carburetor icing conditions.Aug 11, 1993 · N98382 · Substantial damageNTSB MIA93T#A03Accident · No injuriesClass 3Final reportBell 206B · Cooper City, FLAug 11, 1993 · N4MS · Substantial damageNTSB LAX93LA320Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Delano, CAthe pilot's inadequate preflight inspection and his failure to refuel the aircraft.Aug 11, 1993 · N300GW · Substantial damageNTSB LAX93LA319Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Dixon, CAthe failure of the pilot to visually detect and avoid the guy wire.Aug 11, 1993 · N100LM · DestroyedNTSB LAX93FA318Accident · 2 fatalField investigationFinal reportRobinson R-22 Beta · Honolulu, HIA divergence of the main rotor from its normal plane of rotation for an undetermined reason(s) which resulted in rotor contact with the airframe.Aug 11, 1993 · N4017J · DestroyedNTSB FTW93LA237Accident · No injuriesLimited investigationFinal reportBeech 58 · Little Rock, ARThe inadvertent landing gear retraction by the pilot. A factor was the pilot's negative habit interference.Aug 11, 1993 · N7222V · Substantial damageNTSB FTW93LA236Accident · No injuriesLimited investigationFinal reportBeech F35 · Mena, ARThe inflight separation of the ruddervator as result of improper balancing.Aug 11, 1993 · N5064B · Substantial damageNTSB BFO93WA146Accident · No injuriesForeign investigationBell 212 · Marjan, Saudi ArabiaAug 11, 1993 · N709H · Substantial damageNTSB SEA93LA173Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sheridan, WYThe dual student's failure to maintain directional control. A factor contributing to the accident was the instructor's delayed remedial action.Aug 10, 1993 · N116BH · Substantial damageNTSB LAX93LA317Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Julian, CAThe pilot's poor inflight decision in selecting an altitude insufficient to ensure adequate terrain clearance.Aug 10, 1993 · N45552 · DestroyedNTSB CHI93LA318Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Minto, NDThe pilot's failure to maintain adequate aircraft control during ground maneuvering. Inadequate visual outlook by the pilot and the pilot of the other aircraft was a contributing factor.Aug 10, 1993 · N8813B · Substantial damageNTSB CHI93LA316Accident · No injuriesLimited investigationFinal reportCessna A188B · Lexington, NEobstacle clearance not maintained by the pilot-in-command.Aug 10, 1993 · N4802Q · DestroyedNTSB CHI93LA315Accident · No injuriesLimited investigationFinal reportCessna 152 · Montgomery, ILThe pilot became disoriented resulting in loss of engine power due to fuel exhaustion. The dark night light condition was a factor.Aug 10, 1993 · N102CF · Substantial damageNTSB SEA93LA172Accident · No injuriesLimited investigationFinal reportBeech 76 · Portland, ORJamming of the nose landing gear assembly and the pilot-in-command not maintaining the proper glidepath during the nose gear up landing.Aug 9, 1993 · N3692X · Substantial damageNTSB NYC93LA149Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Portsmouth, OHThe pilot's inadequate start procedure which resulted in the airplane taxiing unmanned and its subsequent collision with a building. A factor is the pilot's failure to obtain assistance.Aug 9, 1993 · N1844E · Substantial damageNTSB MIA93LA173Accident · No injuriesLimited investigationFinal reportCessna 152 · Opa-Locka, FLFailure of the pilot-in-command to apply right rudder while applying power during the touch-and-go landing. Contributing to the accident was the pilot-in-command's lack of total experience.Aug 9, 1993 · N757UY · Substantial damageNTSB LAX93LA321Accident · No injuriesLimited investigationFinal reportCessna 170B · Lakeport, CAthe pilot's inadequate compensation for the existing wind conditions and his failure to maintain directional control.Aug 9, 1993 · N2294D · Substantial damageNTSB FTW93LA234Accident · No injuriesLimited investigationFinal reportCessna 177B · Grand Prairie, TXLoss of engine power due to fuel starvation as a result of a leaking fuel line. The fuel line was not the correct part as a result of a misidentification by Cessna.Aug 9, 1993 · N34293 · Substantial damageNTSB FTW93FA235Accident · 1 fatalField investigationFinal reportMooney M20C · Big Lake, TXThe pilot's failure to maintain terrain clearance.Aug 9, 1993 · N5672Q · Destroyed