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 MKC90LA110Accident · Serious injuriesLimited investigationFinal reportBeech S35 · Gardner, KSAn in-flight fire of undetermined origin.NTSB MIA90LA127Accident · No injuriesLimited investigationFinal reportCessna 140 · Opa-Locka, FLLoss of control during the landing roll due to the instructor pilot's lack of experience in tailwheel equipped aircraft.NTSB MIA90LA125Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Lake Wales, FLThe pilot's failure to maintain adequate clearance between the main rotor blades and a power line pole while maneuvering during an aerial application flight.NTSB CHI90FA131Accident · 1 fatalField investigationFinal reportRockwell 114 · Willoughby Hill, OHFailure of the pilot to follow the IFR procedure and to identify the decision height (and/or make a timely missed approach). The adverse weather was a related factor.NTSB ATL90FA115Accident · 6 fatalField investigationFinal reportPiper PA-32R-300 · Frankfort, KYThe pilot's failure to operate the aircraft within the center of gravity limitations of the aircraft.NTSB ANC90LA073Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKCollapse of the left main landing gear due to an overload failure induced by previous damage which occurred during an improper level-off by the pilot.NTSB SEA90FA080Accident · 1 fatalField investigationFinal reportSwearingen SA226-T(B) · Coeur D'Alene, IDInadequate coordination between the pilot and the ground lineman. A factor related to the accident was: impairment of the ground lineman from consumption of alcohol.NTSB MKC90LA113Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Creve Coeur, MOFuel contamination and inadequate preflight.NTSB MKC90LA111Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Bald Knob, ARThe powerplant failure for undetermined causes. Contributing factor was unsuitable terrain.NTSB MIA90LA124Accident · No injuriesLimited investigationFinal reportCessna 150G · Marianna, FLThe pilot's delay in the application of carburetor heat. The carburetor icing condition was a related factor.NTSB LAX90LA192Accident · No injuriesLimited investigationFinal reportCessna 150F · Franklin, CAThe fixed base operator mechanic used improper bolt/nut during repair of the elevator system.NTSB LAX90LA184Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Terra Bella, CAThe pilot's preflight planning and preparation was poor. Contributing to this accident was the high vegetation field.NTSB LAX90FA181Accident · 2 fatalField investigationFinal reportLuscombe 8A · Strawberry, CAThe pilot's decision to continue VFR flight in a confined mountain pass area which was in instrument meteorological conditions; and the pilot's inflight loss of control while attempting a course reversal in the narrow confined canyon.NTSB DEN90LA112Accident · No injuriesLimited investigationFinal reportCessna 182RG · Sioux Falls, SDThe pilot's loss of directional control during landing roll.NTSB DEN90LA111Accident · Minor injuriesLimited investigationFinal reportErco 415G · Peyton, COPilot's failure to maintain obstacle clearance during a landing.NTSB DEN90LA110Accident · No injuriesLimited investigationFinal reportCessna 205 · Bluff, UTFailure of the pilot to properly select and survey his landing site.NTSB CHI90FA130Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · East Lansing, MIThe failure of the pilot to maintain aircraft control while flying in clouds during an instrument approach. Factors were: instrument meteorological conditions, self-induced pressure, operation with known deficiencies in equipment, and anxiety/apprehension.NTSB BFO90LA048Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Evans, WVFailure of the engine due to carburetor float chaffing resulting in a forced landing on unsuitable terrain. Contributing to the accident was failure of the operator to comply with a service bulletin.NTSB BFO90LA047Accident · No injuriesLimited investigationFinal reportRobinson R-22M · Stevensville, MDThe pilot failed to maintain control while taxiing on turbulent water.NTSB ATL90LA114Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Jacksonville, NCThe pilot's decision to land downwind and his delay in executing a go-around.NTSB ANC90LA072Accident · No injuriesLimited investigationFinal reportCessna C-140 · Minto, AKUncertificated pilot's failure to become qualified to operate an aircraft and gain the ability to recognize and respond to crosswind situations.NTSB NYC90LA120Accident · Minor injuriesLimited investigationFinal reportNavion H · Readington, NJThe failure of the pilot to maintain minimum flying airspeed which led to an inadvertent stall/mush. Factors related to the accident were the pilot's decision to land with a tailwind, and his failure to monitor his airspeed on final.NTSB NYC90LA119Accident · Minor injuriesLimited investigationFinal reportGrumman American AA5-A · Plainfield, MAThe pilot's failure to switch the fuel selector to the proper tank. A factor to the accident was the high obstructions near the field.NTSB NYC90LA118Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Albany, NYThe pilot's poor judgement in attempting to land the airplane under the existing wind conditions.NTSB MIA90LA123Accident · Serious injuriesLimited investigationFinal reportBell TH-13T · Biloxi, MSThe passenger's intentional act of jumping in the air with his arm raised while under the main rotor.NTSB LAX90LA183Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Santa Ynez, CAThe pilot's failure to properly preflight the aircraft and secure the fuel system caps which resulted in fuel siphoning and loss of engine power.NTSB FTW90DQG02Accident · No injuriesFinal reportBellanca BL-DW-1 · Petersberg, TXLoss of directional control as the result of an encounter with a dust devil.NTSB DEN90LA113Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Delta, UTThe pilot's loss of directional control during landing. Factors were gusting tailwinds and the pilot selected the wrong runway.NTSB DEN90FA109Accident · Serious injuriesField investigationFinal reportCessna 210L · Telluride, COThe pilot's ffailure to maintain flying speed which resulted in a stall. Factor was wind shear reported off departure end of rwy.NTSB DEN90DTG01Accident · No injuriesFinal reportAdams Boredom Fighter · Finley, NDA power loss due to fuel exahustion and the pilot's inadequate fuel planning. A factor was the ditch in which touchdown occurred.NTSB BFO90FA046Accident · 2 fatalField investigationFinal reportDouglas DC-3 · Capon Bridge, WVInadequate visual lookout by the pilots of the DC-3, which resulted in their failure to see-and-avoid the powerlines. Factors related to the accident were: the obstruction (transmission wires), and the lack of visual cues for the pilots.NTSB ANC90LA070Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Caribou Creek, AKThe pilot's failure to adequately compensate for the existing wind conditions.NTSB LAX90LA222Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Fresno, CAFuel exhaustion due to the pilot's inadequate pre-flight planning.NTSB LAX90LA189Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Hilo, HIImproper supervision and absence of assistance by the company to passengers disembarking the helicopter.NTSB LAX90LA185Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Novato, CAThe pilot's failure to maintain directional control.NTSB LAX90LA182Accident · 2 fatalLimited investigationFinal reportCessna 150H · Goleta, CAThe pilot's failure to maintain control of the airplane. Factors which contributed to the accident were the dark night and the pilot's lack of night flying experience.NTSB LAX90FA180Accident · 2 fatalField investigationFinal reportCessna 172N · Salinas, CAThe pilot's failure to maintain clearance with terrain while attempting visual flight in instrument meteorological conditions. Self induced pressure to adhere to the proposed flight route in instrument meteorological conditions was a factor.NTSB LAX90FA179Accident · 1 fatalField investigationFinal reportCessna 152 · San Diego, CAThe failure of the pilot to maintain adequate airspeed on final approach resulting in an aerodynamic stall. Contributing to the accident was the pilot's delayed use of flaps.NTSB CHI90LA132Accident · Minor injuriesLimited investigationFinal reportCessna 205A · Piqua, OHThe pilot-in-command's inadequate compensation for wind conditions, and his failure to maintain directional control.NTSB CHI90DEV04Accident · No injuriesFinal reportGrumman G-164B · Princeton, ILThe pilot-in-command's failure to maintain adequate clearance from obstacles during flight at low altitude, resulting in wire strike.NTSB ATL90LA113Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Woodstock, GAAn inadequate preflight.NTSB ANC90LA071Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Big Mountain, AKPilot-in-command failed to compensate for gusty wind conditions and control of the aircraft during the take off roll.NTSB SEA90LA078Accident · No injuriesLimited investigationFinal reportCessna 170B · Haines, AKFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. Factors related to the accident were: the gusty crosswind condition, and pilot fatigue.NTSB MKC90LA109Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Searcy, ARPilot impairment from consumption of alcohol, inadequate preflight by the pilot, and fuel contamination with water and dirt (mud) in the system.NTSB LAX90LA178Accident · Serious injuriesLimited investigationFinal reportBeech H35 · San Marcos, CAThe pilot's improper fuel management.NTSB LAX90DUM02Accident · 1 fatalFinal reportCunningham Prescott Pusher · San Diego, CAEngine failure due to mechanical failure of he internal components to the engine.NTSB MKC90LA108Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Dubuque, IAWeather evaluation misjudged resulting in uncontrolled descent by the pilot in command and aircraft control not maintained by the pilot in command.NTSB LAX90LA176Accident · No injuriesLimited investigationFinal reportCessna 172N · Sedona, AZThe failure of the student pilot to maintain an appropriate airspeed during the attempted go-around.NTSB ANC90LA089Accident · No injuriesLimited investigationFinal reportCessna C-150M · Chakachamna, AKPilot-in-command's failure to properly survey the landing area and ensure the appropriate width for his airplane.NTSB NYC90FA107Accident · 1 fatalField investigationFinal reportCessna 182D · Numidia, PAInflight collision with trees while attempting to maintain visual reference with the ground in instrument meteorological flight conditions. Contributing to the accident was the pilot's decision to continue the flight in deteriorating weather conditions in an…