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 WAS07WA002Accident · 3 fatalForeign investigationBeech V35 · Himeville, South AfricaNTSB DEN07WA006Accident · No injuriesForeign investigationBeech 200 · Courchevel, FranceNTSB DEN07LA040Accident · No injuriesLimited investigationFinal reportBeech A-36 · Great Bend, KSThe pilot's spatial disorientation and subsequent loss of aircraft control while changing radio frequencies and abruptly applying control forces in excess of the design limits of the airframe.NTSB DCA07WA002Accident · 4 fatalForeign investigationBritish Aerospace BAe-146-200A · Stord-Sorstokke, NorwayNTSB CHI07CA007Accident · No injuriesData collectionFinal reportSteinbaum Kitfox IV · Proctorville, OHThe blocked fuel filter which resulted in the loss of engine power. The residential area where the power loss occurred, the trees, the sloped landing site, and the unsuitable terrain encountered during the forced landing were contributing factors.NTSB ANC07CA005Accident · No injuriesData collectionFinal reportLetecky Zavody L-23 Super Blanik · Chugiak, AKThe pilot's failure to maintain control of the glider while landing in gusty crosswind conditions, which resulted in a hard landing and structural damage to the fuselage. Factors associated with the accident were turbulence, a crosswind and wind gusts, and…NTSB NYC07FA003Accident · 2 fatalField investigationFinal reportMooney M20F · Brownsville, PAA loss of aircraft control, for unknown reasons, while maneuvering.NTSB ENG07RA001Incident · No injuriesForeign investigationBoeing 747-400 Cargo · Seoul, South KoreaNTSB CHI07CA006Accident · No injuriesData collectionFinal reportCessna 172N · Grand Rapids, MNThe student pilot's misjudged landing flare and improper recovery from the bounced landing which led to the failure of the nose landing gear. The overload failure of the nose landing gear was a factor.NTSB ATL07FA005Accident · 1 fatalField investigationFinal reportBeech BE-19A · Gunthertown, ALThe pilot's continued flight from VMC into IMC conditions which resulted in an in-flight collision with rising terrain.NTSB ANC07LA001Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Port Alsworth, AKThe pilot's inadequate compensation for wind conditions, which resulted in a loss of control while maneuvering, and an in-flight collision with tree covered terrain. Factors associated with the accident are the pilot's inadequate evaluation of weather…NTSB SEA07FA006Accident · 1 fatalField investigationFinal reportRobinson R44 · Sumner, WAThe complete loss of engine power, for undetermined reasons, while on final approach, and the pilot's loss of control of the helicopter after the power loss. Factors include a lake below the final approach to the private landing pad.NTSB LAX07LA005Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Upland, CADisconnection of the throttle control linkage due to improper maintenance, which resulted in a loss of engine power during initial climb.NTSB LAX07LA004Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Oakdale, CAA total loss of engine power resulting from lubrication deprivation for undetermined reasons.NTSB DEN07WA005Accident · No injuriesForeign investigationCirrus Design SR22 · Karlsruhe-Baden, GermanyNTSB CHI07LA005Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Lake Village, INInadequate visual lookout by the pilot. A factor associated with the accident was that neither airplane was equipped with communications equipment.NTSB CHI07CA004Accident · No injuriesData collectionFinal reportCessna 172N · St Charles, MOThe pilot's failure to properly judge the landing flare and his inadequate recovery from the resulting bounced landing. A contributing factor was the inadvertent pilot induced oscillation (porpoise) after initial runway contact.NTSB ATL07CA003Accident · No injuriesData collectionFinal reportHadwise Varieze · Enterprise, ALThe pilot's improper starting procedure, which resulted in an uncommanded aircraft movement and collision with a hanger.NTSB NYC07CA002Accident · No injuriesData collectionFinal reportCutler VariEze · Perkasie, PAThe pilot's excessive rotation on takeoff, which resulted in a propeller blade strike, and subsequent forced landing to a field.NTSB MIA07WA001Accident · Serious injuriesForeign investigationPiper PA-23-250 · Arklins Island, BahamasNTSB MIA07CA002Accident · Minor injuriesData collectionFinal reportCessna 172C · Jay, FLThe pilot's improper in-flight planning and decision resulting in a total loss of engine power due to fuel exhaustion.NTSB LAX07CA013Accident · No injuriesData collectionFinal reportAviat A-1A · Woodlake, CAthe collapse of the landing gear during the landing roll out due to an encounter with rough uneven terrain. Also causal was the pilot's in-flight decision to land on the unsuitable mountainous uneven terrain with hidden obstructions.NTSB ATL07LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Alabaster, ALThe jammed landing gear hydraulic motor shuttle valve.NTSB SEA07LA005Accident · Minor injuriesLimited investigationFinal reportHatcher Fisher Celebrity · Anacortes, WAA loss of engine power during takeoff for undetermined reasons.NTSB NYC07CA004Accident · No injuriesData collectionFinal reportBeech BE-58 · Annapolis, MDThe pilot's improper in-flight decision to attempt to land on the wet runway, which resulted in an overrun. Factors in the accident were rain, and the gusty wind conditions.NTSB LAX07LA003Accident · 2 fatalLimited investigationFinal reportUlfeldt Kitfox IV-1200 · Gridley, CAThe pilot's failure to maintain an adequate airspeed while attempting a return to runway maneuver that led to a stall spin. The reason for the power loss was not ascertained.NTSB LAX07CA007Accident · No injuriesData collectionFinal reportCessna 172P · Glendale, AZthe student's inadequate compensation for the gusting crosswind and inadequate flare that resulted in a hard landing. The certified flight instructor's inadequate supervision of the flight is also causal.NTSB DFW07IA018Incident · No injuriesIncident investigationFinal reportBell 206-L4 · Abbeville, LAA fire in the baggage area for undetermined reasons.NTSB DFW07CA001Accident · Serious injuriesData collectionFinal reportChampion Citabria · Slidell, TXThe pilot's failure to maintain clearance from a parked vehicle.NTSB CHI07CA003Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Fargo, NDThe pilot's inadequate flare which resulted in a hard landing. Factors associated with the accident were the gusty winds and the pilot's lack of experience.NTSB ATL07FA002Accident · 4 fatalField investigationFinal reportCessna 177 · Stockbridge, GAThe pilot's attempted takeoff over the allowable takeoff gross weight of the airplane and his failure to maintain airspeed during climb after takeoff.NTSB SEA07LA004Accident · No injuriesLimited investigationFinal reportCessna 182M · Boise, IDThe pilot's failure to maintain adequate clearance while taxiing. A contributing factor was the temporary construction fence next to the taxiway.NTSB SEA07CA003Accident · No injuriesData collectionFinal reportCessna T182T · Spokane, WAThe pilot's excessive braking which resulted in a loss of aircraft control during the landing roll. A taxiway sign was a factor.NTSB DFW07CA003Accident · No injuriesData collectionFinal reportBoeing 75 · Sweetwater, TXThe pilot's failure to maintain directional control while landing.NTSB DEN07WA004Accident · Serious injuriesForeign investigationAgusta-Bell AB 206A · Villamblard, FranceNTSB ANC07WA002Accident · Minor injuriesForeign investigationBell 206L · Colville Lake, CanadaNTSB DEN07FA003Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau EA 300/L · Tucumcari, NMThe pilot's failure to maintain aircraft control during aerobatic flight, resulting in an inadvertent accelerated stall. Contributing factors include the low altitude for recovery from the loop and the high density altitude.NTSB DEN07FA002Accident · Minor injuriesField investigationFinal reportBeech 36 · Centennial, COthe loss of engine power for undetermined reasons. Contributing factors were the light pole and parked vehicles impacted during the forced landing.NTSB ATL07LA001Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Somerville, TNThe total loss of engine power for undetermined reasons.NTSB NYC07LA001Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hammonton, NJDisplacement of the idler gear assembly, which resulted in a loss of camshaft timing, and a subsequent engine failure. Contributing to the accident was the swampy terrain condition.NTSB SEA07LA002Accident · No injuriesLimited investigationFinal reportCessna 340A · Kalispell, MTThe fracture of the adjusting bellcrank in overstress due to binding in a linkage forward of the bell crank.NTSB LAX07LA002Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Hilo, HIInadvertent application of the lateral cyclic friction, which resulted in a loss of control and subsequent hard landing.NTSB CHI07LA002Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Marshall, MNThe failure of the nose gear to properly extend for undetermined reasons, which resulted in damage to the forward fuselage during landing.NTSB SEA07LA001Accident · Minor injuriesLimited investigationFinal reportOneil Oneil Glassair II-S · Richland, WALoss of partial engine power for undetermined reasons during the initial climb after takeoff. Trees were a factor during the landing roll.NTSB LAX07TA001Accident · Minor injuriesFinal reportErickson S64E · Ojai, CAThe pilot-in-command's improper remedial action, which resulted in a loss of helicopter control. Contributing factors were the retardant tank and snorkel designs.NTSB DEN07CA001Accident · Minor injuriesData collectionFinal reportBrantly Helicopter B-2 · Arkansas City, KSthe pilot's failure to maintain aircraft control during takeoff. A contributing factor was the low rotor RPM.NTSB CHI07CA001Accident · No injuriesData collectionFinal reportCessna 180K · Barton City, MIThe pilot's failure to attain a proper touchdown point and his inadvertent selection of a downwind runway, which resulted in the overrun. A contributing factor was the tailwind encountered during landing. Additional factors were the wet, turf runway, and the…NTSB ANC06LA144Accident · No injuriesLimited investigationFinal reportCessna TU206A · Juneau, AKThe separation of the number 6 cylinder assembly from the engine during cruise flight, which resulted in a hard forced landing in rough ocean swells. A factor contributing to the accident was the rough ocean swells.NTSB NYC06CA232Accident · No injuriesData collectionFinal reportCessna 172S · Cambridge, MDThe pilot's failure to maintain directional control while landing.NTSB CHI06CA277Accident · No injuriesData collectionFinal reportRockwell 112TC · Bolivar, MOThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control during the go-around attempt. Contributing factors were the crosswind and the gusts.