NTSB investigations, 2006
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 2006 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") = 2006 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 LAX07LA027Accident · 2 fatalLimited investigationFinal reportAir Creations Tanarg 912 · Bisbee, AZThe pilot's failure to maintain clearance from the mountainous terrain.NTSB SEA07LA013Accident · No injuriesLimited investigationFinal reportCessna 172S · Richfield, UTThe student pilot's inability to compensate for the gusty crosswinds during the initial part of the landing roll, which resulted in a loss of control and a noseover. Factors associated with the accident are gusty crosswinds, and a mound/berm of dirt alongside…NTSB NYC07LA020Accident · No injuriesLimited investigationFinal reportCessna 182RG · Toms River, NJThe private pilot's failure to attain the proper touchdown point, and the flight instructor's inadequate remedial action, which resulted in a landing short of the runway. A contributing factor was the gusty wind conditions.NTSB NYC07LA018Accident · Serious injuriesLimited investigationFinal reportBombardier CL-600-2B16 · Teterboro, NJThe pilot's excessive maneuver while in cruise flight in response to a traffic collision alert, and failure to follow company procedures.NTSB NYC07LA017Accident · No injuriesLimited investigationFinal reportBoeing 747-400 · Newark, NJThe failure of the Boeing 747 crew to maintain an adequate visual lookout. Contributing to the accident were the night lighting conditions, the back lighting from the apron lights, and the crew's diverted attention in focusing on a Boeing 757 that they were…NTSB NYC07CA019Accident · No injuriesData collectionFinal reportCessna 172M · Wakefield, VAThe student pilot's failure to maintain control during the landing. A factor to the accident was the wind gusts.NTSB NYC07CA016Accident · No injuriesData collectionFinal reportJahns RV-7 · Farmingdale, NJA loss of engine power due to a disconnected throttle/power lever linkage. A contributingfactor was the owner/builder's improper installation of the throttle linkage.NTSB DFW07LA021Accident · No injuriesLimited investigationFinal reportPiper PA32-301XTC · San Marcos, TXThe pilot's improper recovery from a bounced landing.NTSB DFW07LA017Accident · No injuriesLimited investigationFinal reportMooney M20E · Nacogdoches, TXThe loss of engine power for undetermined reasons.NTSB DEN07WA018Accident · 1 fatalForeign investigationRobinson R-44 · Katrineholm, SwedenNTSB DCA07IA008Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Seattle, WAthe flight crew's failure to cross-check and verify that the airplane was on the correct runway before takeoff. Contributing to the incident was the flight crew's self-induced pressure to heed the takeoff clearance during a period of increased workload.NTSB WAS07RA004Accident · 96 fatalForeign investigationBoeing 737-200 · Abuja, NigeriaNTSB NYC07CA014Accident · No injuriesData collectionFinal reportCessna 172N · Morgantown, WVThe student pilot's failure to maintain directional control and the flight instructor's improper planning and supervision of the student's solo cross country flight. A contributing factor was the wind gusts.NTSB CHI07LA010Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Monroe City, INThe student pilot not maintaining clearance from the tree during climb. Factors were the tree and the student pilot's lack of total experience.NTSB CHI07CA019Accident · No injuriesData collectionFinal reportAviat S2B · Larimore, NDThe pilot's failure to maintain proper alignment with the runway which resulted in the airplane nosing over. A factor associated with the accident was the soft terrain encountered.NTSB CHI07CA012Accident · Minor injuriesData collectionFinal reportCessna 172 · Maryville, MOThe pilot's inadequate recovery from a bounced landing leading to the nose gear overload.NTSB NYC07IA015Incident · No injuriesIncident investigationFinal reportBoeing 757-224 · Newark, NJThe flight crew's misidentification of the parallel taxiway as the active runway, resulting in the flight crew executing a landing on the taxiway. Contributing was the night lighting conditions.NTSB LAX07LA023Accident · 1 fatalLimited investigationFinal reportMoyes Dragonfly · Brentwood, CAthe pilot's failure to obtain and maintain an adequate airspeed during the initial climb resulting in a stall and uncontrolled descent into terrain.NTSB LAX07LA022Accident · Serious injuriesLimited investigationFinal reportFish Vans RV-6 · Turlock, CAa partial loss of engine power due to the broken piston rings in the no. 4 cylinder. Also causal was the pilot's failure to maintain adequate airspeed while maneuvering for a forced landing, which resulted in a stall/mush.NTSB CHI07LA013Accident · Serious injuriesLimited investigationFinal reportCessna 180B · Forest Lake, MNthe altitude/clearance with terrain not maintained by the pilot.NTSB NYC07CA013Accident · No injuriesData collectionFinal reportCessna 152 · Lancaster, PAThe student pilot's inadequate flare, which resulted in a nosegear collapse during landing.NTSB LAX07LA019Accident · No injuriesLimited investigationFinal reportCessna 310N · Lake Havasu Cit, AZthe pilot's failure to extend the landing gear prior to touchdown.NTSB DFW07CA014Accident · Minor injuriesData collectionFinal reportChampion 7ECA · Ethel, ARThe pilot's failure to maintain clearance with the trees and terrain. Contributing factors were the prevailing fog and the dark night conditions.NTSB CHI07FA009Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Lawrenceville, ILThe improper judgment by the pilot to conduct a flight to, and execute an approach to, an airport with weather conditions that were below the required minimums. Also causal was the pilot's continued descent below the approach minimum descent altitude.…NTSB CHI07CA014Accident · No injuriesData collectionFinal reportBellanca 7ECA · Eden Prairie, MNThe pilot not maintaining directional control of the tailwheel airplane during the landing roll. A factor was the runway sign that was impacted.NTSB ATL07FA013Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Statesville, NCThe pilot's failure to maintain airspeed while maneuvering with a low ceiling in instrument flight conditions, resulting in an inadvertent stall, and collision with trees and the ground. Factors in the accident were the pilot's failure to follow the published…NTSB DFW07LA016Accident · No injuriesLimited investigationFinal reportBeech F33 · Houston, TXThe loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.NTSB DFW07CA015Accident · No injuriesData collectionFinal reportMaule M5 · New Braunfels, TXThe failure of the right main landing gear attachment during the landing roll, which resulted in a ground loop. A contributing factor was a crosswind.NTSB DEN07WA016Accident · 5 fatalForeign investigationCASA C-212-CE · Skanoer, SwedenNTSB WAS07WA003Accident · 6 fatalForeign investigationCessna 425 · Tulear, MadagascarNTSB SEA07FA012Accident · 1 fatalField investigationFinal reportCessna 172M · Escalante, UTThe pilot's failure to maintain aircraft control. Contributing factors were the pilot's lack of experience of flying on instruments on a dark night and in rainy weather.NTSB LAX07FA021Accident · 4 fatalField investigationFinal reportCirrus SR22 · Meadview, AZThe pilot's inadequate weather evaluation and continued flight into forecasted icing conditions. Contributing to the severity of the accident was the pilot's failure to follow proper operating procedures and deploy the CAPS when the airplane entered a spin.…NTSB DEN07CA014Accident · No injuriesData collectionFinal reportChampion 7GCB · Farmington, NMthe pilot's failure to maintain directional control during the landing.NTSB CHI07IA017Incident · No injuriesIncident investigationFinal reportPiper PA-24-250 · Sherman, ILThe loose connecting rod bolt due to a loss of torque and subsequent failure of the connecting rod during cruise flight.NTSB LAX07LA024Accident · No injuriesLimited investigationFinal reportCessna U206G · Willcox, AZThe pilot's misjudged flare and porpoising during landing.NTSB LAX07LA020Accident · Serious injuriesLimited investigationFinal reportAero Commander 112 · Chino, CAA loss of engine power during the initial climb after takeoff due to blocked fuel vent lines that resulted in fuel starvation. Contributing to the accident was an inadequate preflight inspection by the pilot-in-command (CFI).NTSB DEN07IA027Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-111 · Denver, COThe inadvertent activation of the priority pushbutton on the sidestick by the first officer resulting in a nose down pitch and loss of aircraft control during the landing flare.NTSB DEN07CA015Accident · No injuriesData collectionFinal reportCessna T210G · Delta, COthe pilot's failure to maintain aircraft control and a proper descent rate during the landing.NTSB ANC07CA004Accident · No injuriesData collectionFinal reportPiper PA-20-135 · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop and encounter with terrain. Factors associated with the accident were the ground loop and inadequate main wheel brakes.NTSB SEA07CA010Accident · No injuriesData collectionFinal reportAlexander Lancair 320 · Scappoose, ORThe pilot's failure to maintain aircraft control during a go-around.NTSB NYC07LA011Accident · 1 fatalLimited investigationFinal reportBishop Bakeng Duce · South Boston, VAThe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall. Contributing was the deteriorating weather and diminishing light conditions, the pilot's decision to take off despite the weather advisory, and the pilot's…NTSB MIA07CA010Accident · No injuriesData collectionFinal reportBeech A36 · St. Augustine, FLThe pilot's misjudged distance/altitude during landing, which resulted in an undershoot and on ground collision with a dirt bank.NTSB LAX07LA017Accident · 2 fatalLimited investigationFinal reportWilson Quicksilver Sport 2S · Buckeye, AZFailure of the pilot to maintain adequate clearance from obstacles.NTSB LAX07LA016Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Prunedale, CATotal loss of engine power due to failure of connecting rod cap during cruise flight for undetermined reasons.NTSB DFW07LA011Accident · Minor injuriesLimited investigationFinal reportSikorsky S-76A++ · Eugene Isl 259The flight crew's failure to maintain clearance with the water and their diverted attention to secondary tasks while preparing to land. Contributing factor were the low ceilings and the heavy rains restricting their visibility.NTSB DFW07FA008Accident · 1 fatalField investigationFinal reportNorth American T-28C · Georgetown, LAThe pilot's failure to maintain control of the airplane which led to an aerodynamic stall. A contributing factor was the dark night.NTSB DFW07FA007Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Dry Prong, LAThe loss of engine power during cruise flight due to oil starvation, resulting in an emergency off-airport forced landing. A factor associated with the accident was the instructor's improper in-flight decision in delaying to seek an emergency landing site…NTSB CHI07LA011Accident · No injuriesLimited investigationFinal reportCessna R182 · Ames, IAThe fatigue failure of the landing gear actuator pin and the exterior visual maintenance inspection for cracks not possible by company maintenance personnel.NTSB ATL07FA010Accident · 2 fatalField investigationFinal reportCessna 182T · Rocky Mount, NCThe pilot's failure to maintain aircraft control.NTSB SEA07LA009Accident · Serious injuriesLimited investigationFinal reportHelio H-295 · Lake Isabel, WAThe pilot's failure to maintain airspeed while maneuvering for a precautionary landing following a partial loss of engine power, which resulted in an inadvertent stall/mush and subsequent hard landing. A contributing factor was the partial loss of engine…