NTSB investigations, 2007
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 WHERE year(c.\"eventDate\") = 2007 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 WHERE year(c."eventDate") = 2007 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 SEA08LA035Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Newberg, ORThe student pilot's inadvertent application of the fuel shut off valve during flight. Contributing to the accident were the locations of the heater and fuel shutoff controls.NTSB SEA08CA037Accident · No injuriesData collectionFinal reportBell 206A · Twin Falls, IDThe pilot misjudged the flare which resulted in a hard landing.NTSB NYC08FA041Accident · 1 fatalField investigationFinal reportCirrus Design SR20 · New Windsor, NYThe pilot's failure to maintain the proper glidepath during an instrument-landing-system approach in fog. Contributing to the accident were pilot fatigue and air traffic control's failure to issue a minimum safe altitude warning.NTSB NYC08CA042Accident · No injuriesData collectionFinal reportCessna 172N · Hamilton, NJThe pilot's inadequate fuel consumption calculations which resulted in fuel exhaustion.NTSB DCA08WA016Incident · No injuriesForeign investigationBoeing B737-400 · Jakarta, IndonesiaNTSB SEA08LA031Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Tacoma, WAThe failure of both pilots to maintain an adequate visual lookout during cruise flight.NTSB SEA08CA032Accident · Serious injuriesData collectionFinal reportRobinson R22 Beta · Ramona, CAAn excessive descent rate during a simulated 180-degree power-off autorotation, and the flight instructor's failure to initiate corrective action in time to keep the helicopter from impacting the terrain.NTSB NYC08FA039Accident · 1 fatalField investigationFinal reportMooney M20K · Maine, NYThe pilot's spatial disorientation, which resulted in a loss of control and subsequent collision with trees.NTSB SEA08CA034Accident · No injuriesData collectionFinal reportAyres S2R-G1 · Calexico, CAThe pilot's failure to maintain directional control while landing. A factor in the accident was the close proximity of the drainage ditch to the edge of the private airstrip's runway.NTSB MIA08CA018Accident · No injuriesData collectionFinal reportCessna 172 · McKinnon, TNThe pilot's failure to perform a go around.NTSB DFW08CA032Accident · No injuriesData collectionFinal reportCessna 150 · Muskogee, OKThe pilot's failure to maintain directional control while landing.NTSB ANC08CA020Accident · No injuriesData collectionFinal reportCessna 170B · Nikolai, AKThe pilot's continued flight into adverse weather (icing conditions), which resulted in a loss of engine power during a go-around. Factors contributing to the accident were icing conditions, and carburetor/induction icing.NTSB SEA08CA030Accident · Minor injuriesData collectionFinal reportCessna 172N · Atwater, CAThe failure of the student pilot to maintain directional control during the landing roll. Factors contributing to the accident included the sign and the ditch.NTSB NYC08CA037Accident · No injuriesData collectionFinal reportCessna 172N · Statesboro, GAThe student pilot's failure to maintain a proper flare at touchdown.NTSB LAX08WA131Accident · 4 fatalForeign investigationCessna 337G · Inverloch, AustraliaNTSB ENG08IA002Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Greenville, TXA total loss of engine power due to the No. 2 engine experiencing a release of its fan spinner through the fan cowl as a result of an unidentified object striking the spinner, separating it from the fan disk and causing the spinner to be ingested into the fan…NTSB SEA08LA028Accident · No injuriesLimited investigationFinal reportCessna 210L · Santa Barbara, CAThe left main landing gear's down limit switch plunger being bent and stuck in the closed position, which resulted in the collapse of the landing gear during the landing roll. The reason for the down limit switch plunger being bent could not be determined.NTSB NYC08CA040Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Murfreesboro, TNThe flight instructor's inadequate remedial action and failure to maintain runway alignment.NTSB ENG08RA003Incident · No injuriesForeign investigationBoeing 777 · Roissy, France, FranceNTSB DEN08LA032Accident · Minor injuriesLimited investigationFinal reportGomory Long EZ · LeRoy, KSThe loss of engine power due to fuel starvation. Contributing factors were the pilot's improper fuel calculations and in-flight planning.NTSB CHI08LA037Accident · 2 fatalLimited investigationFinal reportPadelt PG37-1 · Hampton, IAThe pilot's inadequate in-flight planning which resulted in the failure to maintain clearance with the power lines. Contributing to the accident was the power line.NTSB SEA08CA027Accident · No injuriesData collectionFinal reportEurocopter France EC 130 B4 · Meadview, AZThe downward flexing of the standing helicopter's main rotor blades and subsequent impact with its tail boom as a result of another helicopter's rotor blade's vortices. .NTSB DFW08FA031Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Ranger, TXThe pilot's intentional performance of aerobatic maneuvers that exceeded the design limits of the airplane structure.NTSB DEN08LA031Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar Plus · Erie, COThe student pilot's failure to maintain directional control during landing. Contributing factors were the delayed remedial action and inadequate supervision by the flight instructor, and the ditch.NTSB CHI08LA044Accident · No injuriesLimited investigationFinal reportAero Commander GA-500-B · Kansas City, MOThe pilot delayed lowering the landing gear in the landing sequence and the main gear were not in the down and locked position upon touchdown.NTSB ANC08WA021Accident · 2 fatalForeign investigationCessna 404 · Nakatsugawa, JapanNTSB ANC08CA019Accident · No injuriesClass 4 · Data collectionFinal reportAmerican Champion 8GCBC · Wasilla, AKThe pilot's misjudged touchdown point during landing.NTSB SEA08LA033Accident · No injuriesLimited investigationFinal reportBeech A36 · El Centro, CAThe failure of maintenance personnel to properly secure the #2 cylinder through bolts. A contributing factor was the lack of suitable terrain for landing.NTSB SEA08LA029Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Byron, CAThe failure of the right main landing gear aft trunnion attach fitting due to overload during the landing roll.NTSB MIA08CA017Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Hyannis, MAThe student pilot's mismanagement of the fuel supply and the flight instructor's inadequate supervision.NTSB CHI08LA040Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Sport Cruiser · Waukegan, ILThe pilot's failure to assure that all of his tools were accounted for prior to takeoff which resulted in the foreign object jamming the control stick and the pilot's inability to maintain control of the airplane. A factor associated with the accident was the…NTSB NYC08CA036Accident · Minor injuriesData collectionFinal reportCessna 120 · Ocala, FLThe pilot's failure to maintain proper runway alignment during landing.NTSB DEN08LA038Accident · No injuriesLimited investigationFinal reportRotorway Exec 162-F · New Century, KSWhile on approach the tail rotor spar failed due to metal fatigue .NTSB SEA08LA025Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Salt Lake City, UTThe pilot's failure to lower the landing gear prior to landing. Contributing to the accident was the pilot's failure to use a written checklist.NTSB SEA08CA026Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Sedona, AZThe pilot's inadequate compensation for the wind condition, which resulted in his failure to maintain directional control during takeoff. Factors associated with the accident included the gusty crosswind condition and the taxiway sign.NTSB NYC08CA035Accident · Minor injuriesData collectionFinal reportCessna 180 · Orlando, FLThe pilot's loss of control on the water after landing, which resulted in the bow of the right float submerging , and a nose-over event.NTSB SEA08LA066Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Benson, AZThe pilot's inadequate compensation for wind conditions, and his failure to maintain sufficient airspeed to avoid a stall. Contributing to the accident was a variable tailwind.NTSB SEA08LA024Accident · Serious injuriesLimited investigationFinal reportTitan Tornado I · McMinnville, ORThe failure of the pilot to maintain an adequate airspeed during the initial climb after takeoff that resulted in an inadvertent stall. Contributing to the accident was the pilot's unfamiliarity with the accident airplane.NTSB NYC08CA032Accident · No injuriesData collectionFinal reportBrand, Richard Bateleur 2000 · West Ossipee, NHThe pilot's failure to maintain aircraft control, while practicing aerobatics.NTSB NYC08CA031Accident · No injuriesData collectionFinal reportLet L-33 Solo · Louisburg, NCThe flight's encounter with an area of no thermal lift. Contributing factors to the accident were the pilot's inadvertent selection of unsuitable terrain with a hidden obstruction.NTSB LAX08CA030Accident · No injuriesData collectionFinal reportMaule MX-7-180A · Overgaard, AZThe student pilot's failure to maintain directional control during the landing roll.NTSB LAX08CA014Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Napa, CAThe pilot's failure to latch the cargo door during preflight.NTSB DFW08LA030Accident · No injuriesLimited investigationFinal reportGulfstream Aerospace G-IV · Sugar Land, TXThe collapsed of the nose landing gear due to shimmy as the result of the improper installation of the nose landing gear upper torque arm pin by the flight crew during the preflight inspection of the aircraft.NTSB CHI08CA042Accident · Minor injuriesData collectionFinal reportCessna 180 · Becker, MNThe pilot maintained excessive airspeed during the landing approach and failed to achieve a proper touchdown point. A factor associated with the accident was the fence that the airplane contacted.NTSB NYC08LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Sacramento, KYA total loss of engine power during initial climb for undetermined reasons.NTSB NYC08LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Hollywood, FLThe pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall. Contributing to the accident were an inoperative stall warning system and an erroneous airspeed indicator.NTSB NYC08CA030Accident · Minor injuriesData collectionFinal reportSea & Air Sales Searey · Sanford, FLThe pilot's failure to raise the landing gear prior to a water landing. Contributing was the pilot's diverted attention.NTSB DFW08LA029Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Midland, TXThe pilot's failure to maintain directional control during the landing roll. Contributing factors were the prevailing tailwind and an airport sign.NTSB SEA08FA023Accident · 2 fatalField investigationFinal reportCessna T182T · Las Vegas, NVThe pilot's failure to maintain an adequate terrain clearance/altitude during climb to cruise. Contributing to the accident were rising mountainous terrain, the dark nighttime lighting condition, the pilot's loss of situational awareness, and the Federal…NTSB NYC08LA028Accident · 1 fatalLimited investigationFinal reportBell 407 · Morristown, TNThe pilot's failure to maintain adequate clearance from the idling main rotor blade. Contributing to the accident was the pilot's failure to comply with the manufacturer's procedure for securing the helicopter.