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 ATL05CA063Accident · Minor injuriesData collectionFinal reportCessna 175 · Charlotte, NCThe pilot's failure to follow the checklist by his failure to verify the fuel selector was in the on position which resulted in fuel starvation and the loss of engine power.NTSB NYC05LA061Accident · No injuriesLimited investigationFinal reportBoeing 737-72T · Newark, NJThe Boeing flightcrew's misjudged clearance of the parked Gulfstream during taxi, which resulted in a ground collision.NTSB IAD05LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Port Royal, VAA loss of engine power due to the pilot's inadequate preflight planning which resulted in fuel exhaustion.NTSB LAX05LA116Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Flagstaff, AZthe loss of directional control during landing for undetermined reasons.NTSB DEN05CA062Accident · No injuriesData collectionFinal reportBeech A36 · Farmington, NMthe student pilot's failure to maintain airspeed which resulted in a stall and loss of control. Contributing factors were wind gusts, instructor's delay in taking remedial action, and the instructor's inadequate supervision of the flight.NTSB ANC05CA071Accident · No injuriesData collectionFinal reportAerospatiale AS350-B2 · Valdez, AKThe pilot's failure to maintain clearance from an object while hover taxiing, which resulted in the main rotor blades striking a sign.NTSB ANC05CA049Accident · No injuriesData collectionFinal reportBell 206B · Elim, AKThe pilot's continued flight into adverse weather conditions, and his failure to maintain adequate clearance while maneuvering, which resulted in an in-flight collision with terrain. Factors associated with the accident are flat light, whiteout conditions,…NTSB NYC05LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Millersburg, OHThe pilot's inadequate preflight which resulted in a loss of engine power due to fuel contamination. A factor in the accident was the deteriorated fuel cap seals.NTSB LAX05LA115Accident · No injuriesLimited investigationFinal reportSukhoi SU-26 · Tucson, AZthe pilot's inadequate in-flight planning and fuel consumption calculations, which resulted in fuel exhaustion.NTSB DCA05WA043Incident · Minor injuriesForeign investigationBoeing B767 · Buenos Aires, ArgentinaNTSB SEA05LA065Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Graham, WAThe failure of the right main gear due to separation of the attachment hardware.NTSB SEA05LA064Accident · No injuriesLimited investigationFinal reportCessna 182Q · Shelton, WAThe pilot's improper flare which resulted in a hard landing.NTSB SEA05CA059Accident · No injuriesData collectionFinal reportCessna 182A · Manzanita, ORThe pilot's inadequate compensation for the wind, which resulted in an inflight loss of control, a subsequent uncontrolled descent into the tree stump and guy wire, and the resultant nose over. A factor contributing to the accident was the downdraft.NTSB NYC05FA058Accident · 3 fatalField investigationFinal reportGrumman American AA-5 · Chesapeake, OHThe pilot's failure to maintain airspeed during the aborted landing, which resulted in an inadvertent stall.NTSB MIA05LA077Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · DeLand, FLThe failure of the pilot to maintain sufficient airspeed during landing, resulting in an inadvertent stall, undershoot and collision with the ground.NTSB MIA05LA076Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Bradfordville, FLThe failure of ATC to provide traffic advisories and safety alerts required in class C airspace and the inability of both pilots to see and avoid each other (low wing on top, high wing below), resulting in the midair collision.NTSB MIA05CA078Accident · No injuriesData collectionFinal reportCessna 180A · Orange Springs, FLThe pilot's failure to abort the landing and his misjudgment of the runway distance needed to complete the landing.NTSB LAX05FA114Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Big Bear City, CAThe pilot's failure to maintain adequate airspeed that resulted in an inadvertent stall/mush during initial climb. Contributing factors were the pilot's inadequate preflight preparations and the high density altitude.NTSB DFW05CA088Accident · Serious injuriesData collectionFinal reportBell B-206L-1 · Galliano, LAThe pilot's abrupt input of the collective while the main rotor RPM was at idle, which resulted in a separation of the tail boom.NTSB SEA05FA061Accident · Serious injuriesField investigationFinal reportNavion Navion H · Hubbard, ORThe total loss of engine power immediately after takeoff for undetermined reason.NTSB SEA05CA063Accident · No injuriesData collectionFinal reportJeffs J-Bird · St. Paul, ORThe pilot's failure to maintain airspeed while maneuvering at low altitude, which resulted in an inadvertent stall and subsequent collision with terrain. A contributing factor was the pilot's decision to fly at low altitude.NTSB SEA05CA062Accident · No injuriesData collectionFinal reportCessna 172 · Gooding, IDThe pilot's inadequate compensation for the wind conditions which resulted in a loss of control during taxi. A contributing factor was the wind gusts.NTSB MIA05LA079Accident · No injuriesLimited investigationFinal reportRockwell Aero Commander 500 · San Juan, PRThe failure of the pilot to follow the emergency checklist and his inadvertent operation of the airplane with known discrepancies resulting in landing overrun and on-ground collision with a ditch during the landing roll.NTSB LAX05LA178Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-26A · Blythe, CAthe pilot's failure to lower the landing gear prior to landing. A factor to the accident was the pilot's diverted attention due to the flap system anomaly.NTSB LAX05LA112Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Thermal, CAthe pilot's inadequate in-flight planning and failure to refuel the helicopter, which resulted in fuel exhaustion.NTSB DFW05CA087Accident · No injuriesData collectionFinal reportCessna TU206G · Lancaster, TXThe pilot's mismanagement of the available fuel supply, which resulted in a total loss of engine power due to fuel starvation.NTSB CHI05FA077Accident · No injuriesField investigationFinal reportBombardier CL-600-2B19 · Milwaukee, WIthe captain's failure to adequately compensate for the crosswind conditions, and his failure to maintain directional control during landing. Contributing factors include the captain's failure to land at the nearest suitable airport after an in-flight…NTSB ATL05CA062Accident · Minor injuriesData collectionFinal reportCessna 172P · Redstone Arsnl, ALThe pilot's failure to maintain adequate airspeed during approach, which resulted in an inadvertent stall and subsequent collision with the runway. Factors were the turbulence and crosswind conditions.NTSB SEA05CA060Accident · No injuriesData collectionFinal reportBirtch Kitfox II · Dillard, ORThe pilot's failure to maintain clearance from obstacles while in cruise flight at low altitude, which resulted in an inflight collision with a power line. A factor was the pilot's decision to fly at low altitude.NTSB NYC05LA059Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · Cameron, WVA loss of engine power due to carburetor icing, which resulted in a forced landing. A factor in this accident was the carburetor icing conditions.NTSB MIA05IA087Incident · No injuriesIncident investigationFinal reportCirrus Design SR20 · Jacksonville, FLInadequate welding procedure by the manufacturer resulting in a poor weld of the nose landing gear and collapse of the nose landing gear during a porpoised landing.NTSB LAX05LA227Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Phoenix, AZsubstantial damage to the airplane during an unknown phase of flight for undetermined reasons.NTSB LAX05CA111Accident · No injuriesData collectionFinal reportCessna 172A · Emigrant Gap, CAthe pilot's inadequate preflight planning and his selection of an unsuitable landing area, resulting in an encounter with a snow-covered runway.NTSB DFW05CA095Accident · No injuriesData collectionFinal reportAyres S-2R · Marvell, ARThe pilot's failure to maintain directional control while landing. A contributing factor was gusty winds.NTSB DCA05WA042Accident · Minor injuriesForeign investigationBoeing B777 · Buenos Aires, ArgentinaNTSB SEA05LA058Accident · Minor injuriesLimited investigationFinal reportRotorway Exec 162F · Coos Bay, ORThe disintegration, for undetermined reasons, of the upper main drive pulley assembly bearing, while in cruise flight, leading to the decoupling of the main rotor drive assembly from the engine drive assembly. Factors include the absence of any suitable…NTSB MIA05CA075Accident · No injuriesData collectionFinal reportSchleicher ASW 27 · Clermont, FLThe pilot's inadvertent deploying of the spoilers, while on final approach, resulting in the glider descending and impacting trees.NTSB IAD05LA043Accident · No injuriesLimited investigationFinal reportCessna 172N · Frederick, MDThe inadequate visual lookout of the pilots in each airplane, which resulted in a ground collision.NTSB DFW05LA085Accident · No injuriesLimited investigationFinal reportCessna 182G · Fort Worth, TXThe loss of engine power due to carburetor ice. Contributing factors were the weather conditions conducive for carburetor icing, lack of suitable terrain for a forced landing, and the prevailing dark night conditions.NTSB DFW05FA086Accident · 3 fatalField investigationFinal reportBell 206B-3 · Shelbyville, TXThe pilot's failure to maintain altitude and clearance for undetermined reasons.NTSB DFW05CA084Accident · No injuriesData collectionFinal reportGrumman G-164A · Gilbert, LAThe pilot's failure to maintain control of the airplane during landing. A contributing factor was a deflated right main tire.NTSB DCA05RA049Accident · No injuriesForeign investigationBoeing B757-200 · Beijing, ChinaNTSB NYC05IA055Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE-125-700A · Teterboro, NJThe pilot in command's inadequate in-flight planning, which resulted in an overrun landing on a contaminated runway. Factors were inadequate crew coordination, gusty winds, and a slush covered runway.NTSB LAX05LA110Accident · No injuriesLimited investigationFinal reportCessna A185E · Tucson, AZa loss of directional control due to the failure of unknown maintenance personnel to install the tailwheel-locking collar, and the inadequate maintenance inspection of the worn tailwheel steering arm.NTSB DFW05WA089Accident · Serious injuriesForeign investigationCessna 208B · Belize City, BelizeNTSB ATL05FA061Accident · No injuriesField investigationFinal reportCanadair CL-600 · Tupelo, MSThe inadequate design of the microphone jack assembly Supplemental Type Certificate by production design personnel resulting in the aft restriction of the control column at rotation airspeed, aborted takeoff, and collapse of the nose gear on the overrun.NTSB ATL05CA060Accident · Minor injuriesData collectionFinal reportSavage RV-8 · Goldsboro, NCThe pilot's excessive braking during landing roll, which resulted in a nose-over. A factor was the tailwind.NTSB ANC05IA048Incident · No injuriesIncident investigationFinal reportReims F406 · Nome, AKThe failure of the nose gear up lock actuator bracket during the landing approach due to fatigue cracking, which resulted in a nose wheel up landing. A factor associated with the incident is the mechanical binding of the nose wheel locking mechanism.NTSB SEA05LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Covington, WAThe failure of connecting rods during cruise flight resulting in a loss of engine power. Trees were a factor.NTSB MIA05WA073Accident · 2 fatalForeign investigationCessna 500 · Caracas, Venezuela