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 MKC90LA110Accident · Serious injuriesLimited investigationFinal reportBeech S35 · Gardner, KSAn in-flight fire of undetermined origin.May 21, 1990 · N5892J · DestroyedNTSB 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.May 21, 1990 · N76464 · Substantial damageNTSB 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.May 21, 1990 · N1390X · DestroyedNTSB 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.May 21, 1990 · N4859W · DestroyedNTSB 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.May 21, 1990 · N5661F · DestroyedNTSB 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.May 21, 1990 · N2515A · Substantial damageNTSB 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.May 20, 1990 · N161RS · Minor damageNTSB MKC90LA113Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Creve Coeur, MOFuel contamination and inadequate preflight.May 20, 1990 · N9071D · Substantial damageNTSB MKC90LA111Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Bald Knob, ARThe powerplant failure for undetermined causes. Contributing factor was unsuitable terrain.May 20, 1990 · N8852H · Substantial damageNTSB 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.May 20, 1990 · N6348S · Substantial damageNTSB LAX90LA192Accident · No injuriesLimited investigationFinal reportCessna 150F · Franklin, CAThe fixed base operator mechanic used improper bolt/nut during repair of the elevator system.May 20, 1990 · N27G · Substantial damageNTSB 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.May 20, 1990 · N1211F · Substantial damageNTSB 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.May 20, 1990 · N71653 · DestroyedNTSB DEN90LA112Accident · No injuriesLimited investigationFinal reportCessna 182RG · Sioux Falls, SDThe pilot's loss of directional control during landing roll.May 20, 1990 · N4850S · Substantial damageNTSB DEN90LA111Accident · Minor injuriesLimited investigationFinal reportErco 415G · Peyton, COPilot's failure to maintain obstacle clearance during a landing.May 20, 1990 · N87212 · Substantial damageNTSB DEN90LA110Accident · No injuriesLimited investigationFinal reportCessna 205 · Bluff, UTFailure of the pilot to properly select and survey his landing site.May 20, 1990 · N4807U · Substantial damageNTSB 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.May 20, 1990 · N24PT · DestroyedNTSB 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.May 20, 1990 · N2411G · Substantial damageNTSB BFO90LA047Accident · No injuriesLimited investigationFinal reportRobinson R-22M · Stevensville, MDThe pilot failed to maintain control while taxiing on turbulent water.May 20, 1990 · N4003K · Substantial damageNTSB ATL90LA114Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Jacksonville, NCThe pilot's decision to land downwind and his delay in executing a go-around.May 20, 1990 · N5290W · Substantial damageNTSB 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.May 20, 1990 · N76607 · Substantial damageNTSB 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.May 19, 1990 · N2502T · Substantial damageNTSB 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.May 19, 1990 · N26302 · Substantial damageNTSB 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.May 19, 1990 · N47566 · Substantial damageNTSB 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.May 19, 1990 · N67223 · No damageNTSB 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.May 19, 1990 · N3157F · Substantial damageNTSB FTW90DQG02Accident · No injuriesFinal reportBellanca BL-DW-1 · Petersberg, TXLoss of directional control as the result of an encounter with a dust devil.May 19, 1990 · N8803E · Substantial damageNTSB 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.May 19, 1990 · N6392Q · Substantial damageNTSB 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.May 19, 1990 · N2403S · Substantial damageNTSB 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.May 19, 1990 · N317MA · Substantial damageNTSB 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.May 19, 1990 · N1FN · DestroyedNTSB ANC90LA070Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Caribou Creek, AKThe pilot's failure to adequately compensate for the existing wind conditions.May 19, 1990 · N4363A · Substantial damageNTSB LAX90LA222Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Fresno, CAFuel exhaustion due to the pilot's inadequate pre-flight planning.May 18, 1990 · N3709D · Substantial damageNTSB LAX90LA189Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Hilo, HIImproper supervision and absence of assistance by the company to passengers disembarking the helicopter.May 18, 1990 · N1602N · No damageNTSB LAX90LA185Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Novato, CAThe pilot's failure to maintain directional control.May 18, 1990 · N6816E · Substantial damageNTSB 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.May 18, 1990 · N7156S · DestroyedNTSB 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.May 18, 1990 · N9993G · DestroyedNTSB 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.May 18, 1990 · N783G · DestroyedNTSB CHI90LA132Accident · Minor injuriesLimited investigationFinal reportCessna 205A · Piqua, OHThe pilot-in-command's inadequate compensation for wind conditions, and his failure to maintain directional control.May 18, 1990 · N4841U · Substantial damageNTSB 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.May 18, 1990 · N6695Q · Substantial damageNTSB ATL90LA113Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Woodstock, GAAn inadequate preflight.May 18, 1990 · N201FM · Substantial damageNTSB 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.May 18, 1990 · N407WB · Substantial damageNTSB 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.May 17, 1990 · N2300D · Substantial damageNTSB 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.May 17, 1990 · N2628H · Substantial damageNTSB LAX90LA178Accident · Serious injuriesLimited investigationFinal reportBeech H35 · San Marcos, CAThe pilot's improper fuel management.May 17, 1990 · N5586D · Substantial damageNTSB LAX90DUM02Accident · 1 fatalFinal reportCunningham Prescott Pusher · San Diego, CAEngine failure due to mechanical failure of he internal components to the engine.May 17, 1990 · N58PP · DestroyedNTSB 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.May 16, 1990 · N111AY · Substantial damageNTSB LAX90LA176Accident · No injuriesLimited investigationFinal reportCessna 172N · Sedona, AZThe failure of the student pilot to maintain an appropriate airspeed during the attempted go-around.May 16, 1990 · N738UC · Substantial damageNTSB 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.May 16, 1990 · N9477U · Substantial damageNTSB 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…May 15, 1990 · N8757X · Destroyed