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 DFW06FA140Accident · 2 fatalField investigationFinal reportAviat A-1B · Edna, TXThe pilot's ostentatious display while maneuvering at low altitude which resulted in an inadvertent stall/spin and subsequent impact with the water.NTSB DFW06CA143Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Justin, TXThe pilot's improper compensation for the prevailing high wind conditions.NTSB ATL06LA086Accident · No injuriesLimited investigationFinal reportCessna 150M · Bishopville, SCThe loss of engine power for undetermined reasons during the approach to land, which resulted in an off-airport emergency landing.NTSB ATL06CA087Accident · Minor injuriesData collectionFinal reportBeech B36TC · Brevard, NCThe pilot's failure to attain the proper touchdown point during landing.NTSB LAX06LA183Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Oxnard, CAThe loss of engine power for undetermined reasons.NTSB LAX06LA182Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Eagar, AZthe flight instructor's failure to attain and maintain the proper climb airspeed, which resulted in a stall/mush.NTSB CHI06LA137Accident · No injuriesLimited investigationFinal reportMaule MT-7-235 · Flushing, MIThe pilot's selection of unsuitable terrain for landing, which resulted in the collapse of the amphibian float's nose wheels, and a nose over during the landing roll. Factors associated with the accident were the soft grass runway, and the collapse of the…NTSB ATL06LA085Accident · No injuriesLimited investigationFinal reportHughes 269A · Concord, NCThe loss of engine power for undetermined reasons while maneuvering, resulting in a forced landing to uneven terrain and a roll over.NTSB ANC06CA063Accident · No injuriesData collectionFinal reportGrumman G-44 · Willow, AKThe pilot's failure to retract the amphibian airplane's main landing gear prior to landing on a lake, which resulted in a nose over during touchdown.NTSB NYC06WA132Accident · 2 fatalForeign investigationCessna 150M · Raharney, IrelandNTSB MIA06LA116Accident · No injuriesLimited investigationFinal reportTecnam P92 Super Echo · Sebring, FLThe loss of engine power for undetermined reasons resulting in a forced landing and collision with a fence.NTSB CHI06LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hale, MIThe pilot's inadequate compensation for the crosswind condition and failure to maintain clearance from the tree. Factors were the crosswind and the tree.NTSB ANC06CA062Accident · No injuriesData collectionFinal reportCessna 180 · Anchorage, AKThe pilot's inadequate recovery from a bounced landing during the landing flare/touchdown, which resulted in a loss of control, the right wing striking the runway, and subsequent nose down when the airplane departed the runway.NTSB NYC06CA120Accident · No injuriesData collectionFinal reportPiper PA-28-280 · Tangier Island, VAThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with a ditch. A factor was the rough runway condition.NTSB NYC06CA118Accident · Minor injuriesData collectionFinal reportEspinal Velocity Jet 900 · Millbrook, NYThe pilot/owner's inadequate preflight which resulted in a partial loss of engine power due to a clogged fuel vent.NTSB MIA06WA115Accident · Minor injuriesForeign investigationIsrael Aircraft Industries 1124 · Georgetown, BahamasNTSB LAX06CA181Accident · No injuriesData collectionFinal reportCessna 152 · Buckeye, AZthe pilot's failure to maintain directional control during landing.NTSB DFW06CA139Accident · Minor injuriesData collectionFinal reportAllstar PZL SZD 51-1 Junior · Cherry Valley, ARThe pilot's failure to maintain clearance from a tree while on final to approach to landing. A contributing factor was the loss of thermal lift on final approach.NTSB ANC06CA060Accident · No injuriesData collectionFinal reportCessna 180 · Sterling, AKThe pilot's inadequate compensation for a crosswind during the landing roll, which resulted in an on-ground encounter with the runway surface. Factors contributing to the accident were a crosswind, and an inadvertent ground loop.NTSB NYC06CA117Accident · Serious injuriesData collectionFinal reportCameron Balloons Z-120 · Montvale, VAThe pilot's failure to arrest an excessive descent rate prior to ground contact, which resulted in a hard landing. A factor in the accident were the wind gusts.NTSB NYC06CA105Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Laconia, NHThe pilot's failure to maintain directional control during the landing.NTSB MIA06IA110Incident · No injuriesIncident investigationFinal reportCessna 172S · St. Augustine, FLThe loss of engine power due to separation of the crankshaft as a result of lack of adequate oil lubrication to the #2 main bearing. The lack of oil lubrication was most likely the result of improper assembly (fitting) of the bearing shells to the crankshaft.NTSB LAX06CA180Accident · No injuriesData collectionFinal reportBell 47-G5 · Soledad, CAfuel exhaustion due to the pilot's inaccurate fuel consumption calculations and failure to refuel the helicopter which resulted in a loss of engine power.NTSB DFW06CA138Accident · No injuriesData collectionFinal reportMaule MX-7-180B · Melbourne, ARThe pilot's failure to maintain directional control while landing resulting in a ground loop. A contributing factor was the prevailing crosswind.NTSB CHI06CA136Accident · No injuriesData collectionFinal reportMiller Rutan Long-Ez · Morris, ILThe partial loss of engine power during the final approach to landing for undetermined reasons, and the unsuitable terrain for landing encountered by the pilot. The tall grass was a factor.NTSB CHI06CA135Accident · No injuriesData collectionFinal reportCessna 172SP · Indianapolis, INThe pilot's improper flare during landing.NTSB ATL06LA083Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Blacksburg, SCThe pilot's failure to abort the takeoff after the airplane failed to achieve adequate airspeed on the takeoff roll for undetermined reasons. This resulted in an abrupt pull up, inadvertent stall, and in flight collision with wires, trees and the ground.NTSB ATL06CA084Accident · No injuriesData collectionFinal reportCessna 172L · Lexington, TNThe pilot's failure to attain the proper touchdown point during landing.NTSB ANC06CA061Accident · No injuriesData collectionFinal reportPiper J-3 · Hollywood, FLThe flight instructor's inadequate supervision of the instructional flight during the landing roll in crosswind conditions, which resulted in a collision with a runway sign. Factors contributing to the accident were a crosswind, and the student pilot's…NTSB DFW06FA136Accident · 2 fatalField investigationFinal reportCessna 150F · Levelland, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall. Contributing factors were low altitude and the gusting wind.NTSB ANC06LA059Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-2 · Kodiak, AKThe pilot's inadequate evaluation of the weather conditions, and his selection of unsuitable terrain (rough water) for takeoff, which resulted in a collision with ocean swells during takeoff initial climb, and a hard emergency landing and a roll over. Factors…NTSB SEA06WA104Accident · No injuriesForeign investigationCessna 210G · Seoul, South KoreaNTSB SEA06CA106Accident · No injuriesData collectionFinal reportCessna 170B · West Glacier, MTThe pilot's failure to attain sufficient airspeed for flight, his attempt to abort the takeoff, and the airplane's subsequent departure off the end of the runway. Contributing factors were the impacted fence and vegetation, and his total lack of experience in…NTSB DFW06CA134Accident · No injuriesData collectionFinal reportCessna P210N · Weslaco, TXThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight planning. A contributing factor was the lack of suitable terrain available to the pilot for the forced landing,NTSB DFW06CA132Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Marietta, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Contributing factors were the dark night conditions and the pilot's inadequate preflight planning and preparation.NTSB DFW06CA131Accident · No injuriesData collectionFinal reportCessna 150M · Ardmore, OKThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight planning.NTSB ANC06LA058Accident · No injuriesLimited investigationFinal reportBoeing A75-L3 · Lake Wales, FLThe pilot's failure to maintain proper runway alignment during the takeoff roll, which resulted in a collision with trees during a precautionary landing when the airplane touched down to the right of the runway edge. A factor contributing to the accident was…NTSB SEA06CA103Accident · No injuriesData collectionFinal reportCessna 172M · Hamilton, MTThe pilot's inadequate compensation for the wind conditions during the landing roll which resulted in his failure to maintain directional control. Factors included variable winds and gusty crosswinds.NTSB SEA06CA101Accident · Minor injuriesData collectionFinal reportErcoupe 415-C · Vaughn, WAThe loss of engine power due to carburetor ice. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX06CA179Accident · No injuriesData collectionFinal reportCessna A185F · Columbia, CAthe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control during the landing rollout.NTSB DFW06LA135Accident · No injuriesLimited investigationFinal reportBoeing A75 · Jennings, LAThe partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI06CA133Accident · Serious injuriesData collectionFinal reportCirrus Design SR22 · Verdigre, NEThe pilot's decision to land on a wet grass runway that had insufficient length available for landing roll. An additional cause was the pilot's failure to properly retract the flaps during the aborted landing, resulting in diminished climb performance and the…NTSB ATL06CA082Accident · Minor injuriesData collectionFinal reportErcoupe 415C · Crossville, TNInadequate maintenance inspection resulting in fuel system contamination going undetected resulting in a total loss of engine power while on final approach to land.NTSB ANC06LA072Accident · No injuriesLimited investigationFinal reportHelio H-250 · Anchorage, AKThe pilot's improper use of the carburetor heat control during takeoff, which resulted in a partial loss of engine power, a hard landing, and an on ground encounter with terrain. A factor contributing to the accident was an inadvertent ground loop.NTSB SEA06LA100Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Battle Ground, WAthe pilot's excessive airspeed and exceeding the proper touchdown point during landing, which resulted in a hard landing and subsequent overrun of the runway. Factors contributing to the accident included the fence, the trees and the pilot's failure to…NTSB SEA06CA102Accident · No injuriesData collectionFinal reportHughes 369A · Banks, ORThe pilot's failure to maintain rotor rpm while performing a simulated autorotation, which resulted in a hard landing. A contributing factor was the pilot's incorrect interpretation of the examiner's instruction to add power.NTSB LAX06CA176Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Carson City, NVThe loss of engine power due to the pilot's inadequate fuel system management, which resulted in fuel starvation and the loss of engine power.NTSB DFW06CA137Accident · No injuriesData collectionFinal reportAyres S2R-T34 · Winchester, ARThe pilot's failure to abort the takeoff following the partial loss of engine power for undetermined reasons. A contributing factor was the rising embankment at the end of the runway.NTSB DFW06CA133Accident · Minor injuriesData collectionFinal reportPiper PA-38-112 · La Porte, TXThe student pilot's inadequate weather evaluation and his failure to maintain airspeed which resulted in a stall. A contributing factor was the prevailing tailwind.NTSB ANC06LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Naknek, AKA loss of engine power during cruise flight for an undetermined reason, which resulted in a forced landing and subsequent collision with high vegetation and the ground.