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 CHI92FA110Accident · 2 fatalField investigationFinal reportCessna 310R · Superior, WIInadequate airspeed, which resulted in an inadvertent stall/spin, and failure of the instructor pilot to take sufficient remedial action to prevent the loss of control.Mar 11, 1992 · N1328G · DestroyedNTSB ATL92LA059Accident · No injuriesLimited investigationFinal reportCessna 310R · Tuscaloosa, ALThe instructor's inadequate supervision and the student pilot's failure to follow instructions.Mar 11, 1992 · N87355 · Substantial damageNTSB ATL92LA058Accident · No injuriesLimited investigationFinal reportPiper PA-46-310 · Aiken, SCThe unexpected, gusting crosswind.Mar 11, 1992 · N4387V · Substantial damageNTSB ANC92T#A03Accident · No injuriesClass 3Final reportPiper PA-18 · Anchorage, AKMar 11, 1992 · N96613 · Substantial damageNTSB NYC92LA054Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Falmouth, KYThe failure of the pilot to adequately monitor his fuel consumption which resulted in a power loss from fuel exhaustion over unsuitable terrain. A factor related to the accident was the failure of the pilot to adequately determine the amount of fuel onboard…Mar 10, 1992 · N2460C · Substantial damageNTSB MIA92LA095Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Deland, FLFailure of the pilot-in-command to maintain the proper airspeed (vs) resulting in an inadvertent stall. Factors in the accident were incorrect fuel selector position resulting in the total loss of engine power due to fuel starvation and fatigue of the pilot.Mar 10, 1992 · N6418A · Substantial damageNTSB MIA92IA093Incident · No injuriesIncident investigationFinal reportDouglas DC-3C · San Juan, PRThe pilot-in-command's improper loading of personnel, and improper supervision of the first officer/co-pilot while calculating the center of gravity limits for the flight. This resulted in the forward center of gravity limit being exceeded and subsequent nose…Mar 10, 1992 · N135FS · Minor damageNTSB BFO92LA037Accident · No injuriesLimited investigationFinal reportPiper 46-310P · Lima, OHThe pilot failure to maintian adequate airspeed during final approach which resulted in a stall. Contributing to the accident was ice on the wings.Mar 10, 1992 · N4321L · Substantial damageNTSB ANC92LA046Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A-150 · Golovin, AKProper altitude was not maintained. Factors to the accident were: inadvertent VFR flight into IMC, fog, snow, and night.Mar 10, 1992 · N7685D · Substantial damageNTSB LAX92LA140Accident · No injuriesLimited investigationFinal reportCessna 172P · Santa Monica, CAThe pilot's misjudged landing flare and her improper bounced landing recovery technique. Contributing factors were the airplane's excessive approach airspeed and the student's lack of experience.Mar 9, 1992 · N98662 · Substantial damageNTSB LAX92LA139Accident · No injuriesLimited investigationFinal reportCessna 210G · Livermore, CAThe failure of the left main landing gear saddle.Mar 9, 1992 · N5885F · Substantial damageNTSB FTW92LA086Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Harrison, ARThe pilot's failure to attain the proper touchdown point, and his failure to maintain the proper descent rate.Mar 9, 1992 · N54956 · Substantial damageNTSB FTW92LA085Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Valley Mills, TXPower loss due inadequate maintenance and the resultant multiple maintenance discrepancies. A factor was the wet terrain.Mar 9, 1992 · N9828 · Substantial damageNTSB CHI92LA109Accident · No injuriesLimited investigationFinal reportCessna 177BII · Bloomington, ILPilot's improper recovery from a bounced landing. Factors in the accident were excessive airspeed at landing and habit interference.Mar 9, 1992 · N35151 · Substantial damageNTSB SEA92LA057Accident · 2 fatalLimited investigationFinal reportRobert L. Rice Davis DA-2A · Billings, MTThe failure of the pilot to maintain terrain clearance. Factors relating to the accident were the pilot's lack of experience and the rising terrain in the area.Mar 8, 1992 · N48BR · DestroyedNTSB SEA92LA056Accident · 1 fatalLimited investigationFinal reportAero Commander S-2R · Dufur, ORThe pilot in command's misjudgment of clearance with the power lines. Factors contributing to the accident were: object (transmission wire) and safety system (not installed).Mar 8, 1992 · N1763S · DestroyedNTSB MIA92LA092Accident · No injuriesLimited investigationFinal reportCessna 170A · Miami, FLFailure of the pilot in command to maintain directional control. Contributing to the accident was the unfavorable wind (windshift).Mar 8, 1992 · N9998A · Substantial damageNTSB FTW92LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Mangum, OKThe pilot's failure to maintain proper airplane altitude. A factor was the dark night.Mar 8, 1992 · N8287W · Substantial damageNTSB FTW92LA082Accident · No injuriesLimited investigationFinal reportCessna 172B · Golden, TXFuel exhaustion due to the pilot's failure to refuel. Factors were false fuel sensor indications and a fence.Mar 8, 1992 · N6938X · Substantial damageNTSB FTW92DPG01Accident · 1 fatalFinal reportWind Ryder · Little Rock, ARA loss of control for undetermined reason(s).Mar 8, 1992 · N123ZT · DestroyedNTSB CHI92LA106Accident · Minor injuriesLimited investigationFinal reportSocata TB-10 · Elkhart, INProper glidepath was not maintained and minimum descent altitude was not maintained by the pilot resulting in collision with trees. Factors relate to the accident were the pilot's lack of total experience in type of operation and over confidence in personal…Mar 8, 1992 · N105A · Substantial damageNTSB CHI92LA105Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Romeoville, ILThe pilot selected unsuitable terrain to make a precautionary landing when he did not receive a safe indication that the landing gear was down and locked. A factor in the accident was inability of the pilot to restart the left engine after intentionally…Mar 8, 1992 · N242CF · Substantial damageNTSB ATL92LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Lawrenceville, GALoss of engine power for undetermined reasons.Mar 8, 1992 · N67772 · Substantial damageNTSB ATL92LA056Accident · Serious injuriesLimited investigationFinal reportJR. Ace E · Statesville, NCThe pilot's failure to maintain altitude during a steep turn at low level.Mar 8, 1992 · N1337M · Substantial damageNTSB ANC92T#A02Accident · No injuriesClass 3Final reportCessna 185 · Barrow, AKMar 8, 1992 · N60945 · Substantial damageNTSB SEA92LA055Accident · 1 fatalLimited investigationFinal reportRobinson R-22 Beta · Oxbow, ORFailure of the pilot to maintain a proper visual lookout. A factor in the accident was the pilot's poor judgement in operating at low altitude along the river.Mar 7, 1992 · N2645W · DestroyedNTSB MIA92LA094Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Hollandale, MSFailure of the pilot in command to check the fuel tank for contaminants before departure, which resulted in the total loss of engine power due to water contamination.Mar 7, 1992 · N4942X · Substantial damageNTSB FTW92LA087Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Santa Fe, NMThe pilot's failure to maintain directional control during the takeoff roll phase of a touch and go.Mar 7, 1992 · N39866 · Substantial damageNTSB FTW92LA083Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Whitehouse, TXThe pilot's inadequate preflight inspection and the engine power loss due to fuel contamination with water. A factor was the lack of suitable terrain available for the forced landing.Mar 7, 1992 · N94063 · Substantial damageNTSB FTW92LA081Accident · No injuriesLimited investigationFinal reportCameron 084 · Maumelle, ARThe pilots improper fuel consumption planning. A factor was a lack of suitable terrain for landing.Mar 7, 1992 · N6008J · DestroyedNTSB DEN92LA041Accident · Minor injuriesLimited investigationFinal reportEnstrom F28 · Lakewood, COThe premature use of collective by the pilot during an autorotation. Factors were: the disconnection and subsequent collapse of the induction air line.Mar 7, 1992 · N95NR · Substantial damageNTSB CHI92LA107Accident · No injuriesLimited investigationFinal reportBeech C23 · Ozark, MOThe CFI pilot-in-command's failure to provide adequate supervision of a dual student. A factor contributing to the accident was the student pilot's failure to maintain airspeed.Mar 7, 1992 · N9183S · Substantial damageNTSB BFO92LA033Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Qioquinton, VAEngine failure due to fuel exhaustion because of an open crossfeed fuel line drain valve.Mar 7, 1992 · N27613 · Substantial damageNTSB BFO92FA032Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Sandston, VAThe pilot's improper in-flight planning/decision failure to follow the missed approach procedure.Mar 6, 1992 · N100LC · DestroyedNTSB BFO92FA031Accident · 2 fatalField investigationFinal reportCessna 210K · Frederick, MDThe pilot's improper IFR operation and descent below the ILS glideslope and decision height, which resulted in an inflight collision with trees. The weather condition and lack of a recent weather briefing were related factors.Mar 6, 1992 · N8104G · DestroyedNTSB ANC92FA044Accident · Serious injuriesField investigationFinal reportBell 214B-1 · Hobart Bay, AKFatigue failure of the compressor assembly impeller, and inadequate quality control by the manufacturer. A factor which contributed to the accident was the mountainous/hilly terrain.Mar 6, 1992 · N314RM · Substantial damageNTSB LAX92FA136Accident · 2 fatalField investigationFinal reportAerospatiale AS-350D · Ft. Grant, AZ1) The pilot inadequately evaluating the enroute weather conditions, and, 2) the pilot making the inflight decision to continue VFR flight into adverse weather conditions. Factors in this accident were the inability of the pilot to see the mountainous terrain…Mar 5, 1992 · N350AH · DestroyedNTSB FTW92IA092Incident · No injuriesIncident investigationFinal reportBell 206L-3 · Sabine Pass #18The pilot's cardiovascular disease.Mar 5, 1992 · N41791 · No damageNTSB DEN92FA040Accident · 6 fatalField investigationFinal reportMitsubishi MU-2B-60 · New Castle, COAn inadvertent stall during an instrument approach with the autopilot engaged. A factor was: the pilot's physical impairment from a prescription drug.Mar 5, 1992 · N303CA · DestroyedNTSB CHI92FA104Accident · 3 fatalField investigationFinal reportCessna 414 · Freeland, MIThe pilot's poor judgement in attempting flight after the airplane's fuselage was damaged during a loading operation. Factors which contributed to the accident were: the operator's failure to provide proper weight and balance data for the airplane, the…Mar 5, 1992 · N69662 · DestroyedNTSB BFO92LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201T · Brewer, METhe pilot's decision to land on an icy runway and then attempt to take off. Contributing to the accident was the pilot's decision to completely raise the flaps after the balked landing.Mar 5, 1992 · N3768M · DestroyedNTSB MIA92LA091Accident · No injuriesLimited investigationFinal reportCessna 150K · Gainesville, FLThe improper in flight decision by the pilot-in-command to land with an excessive rate of descent and airspeed. Contributing to the accident was the pilot-in-command's improper recovery from a bounced landing which resulted in an on ground loss of control…Mar 4, 1992 · N40SA · Substantial damageNTSB LAX92FA137Accident · 1 fatalField investigationFinal reportRobinson R22 · Maricopa, AZDestructive mast bumping for an undetermined reason(s).Mar 4, 1992 · N8413Q · DestroyedNTSB LAX92FA135Accident · 2 fatalField investigationFinal reportCessna 150 · Williams, AZThe pilot inadequately evaluating the weather condition, and the pilot's inflight decision to continue flight into adverse weather conditions. Factors in this accident were the pilot's visual lookout ability being restricted by the prevailing weather…Mar 4, 1992 · N7933E · DestroyedNTSB BFO92LA029Accident · No injuriesLimited investigationFinal reportCessna 195 · Charleston, WVFailure of the pilot to maintain clearance from the taxiway sign.Mar 4, 1992 · N4495C · Substantial damageNTSB FTW92GA080Accident · No injuriesFinal reportBell 206B III · Falfurrias, TXThe pilot's failure to maintain directional control due to his ability to maintain an adequate visual lookout being restricted. Factors were the observer's delay in informing the pilot of the rearward drift and the dark night conditions.Mar 3, 1992 · N3201R · Substantial damageNTSB CHI92LA102Accident · No injuriesLimited investigationFinal reportStinson 108 · Heyworth, ILImproper use of the carburetor heat control which resulted in carburetor ice and subsequent loss of power. A factor related to the accident was the carburetor icing conditions which existed at the time of the accident.Mar 3, 1992 · N97599 · Substantial damageNTSB CHI92IA101Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Chicago, ILContaminated anti-skid braking system electrical connectors which resulted in a partial loss of the anti-skid system and locking up of the brakes on the left main gear.Mar 3, 1992 · N1820U · Minor damageNTSB ATL92LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Starr, SCThe pilot's inadequate pre-flight planning.Mar 3, 1992 · N2862Q · Substantial damageNTSB ANC92LA043Accident · Minor injuriesLimited investigationFinal reportDouglas DC-6B · Selawik, AKThe pilot's inadequate pre flight planning and disregarding the aircraft performance data. Contributing factors were the extreme outside air temperatures, the icy runway, and the tailwind.Mar 3, 1992 · N151 · Substantial damage