NTSB investigations, 2012
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 2012 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") = 2012 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 WPR12CA269Accident · No injuriesData collectionFinal reportCessna 170B · Pullman, WAThe pilot’s failure to maintain directional control of the airplane while landing in gusting crosswind conditions and the flight instructor’s delayed remedial action.NTSB ERA12CA408Accident · Minor injuriesData collectionFinal reportCessna 195B · Millington, TNThe pilot's failure to maintain directional control during the landing roll.NTSB ERA12CA407Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Lake Wales, FLThe flight instructor’s inadequate supervision of the student pilot’s power management, which resulted in a hard landing. Contributing to the accident was the student pilot's premature power reduction during the landing flare.NTSB ERA12LA401Accident · Serious injuriesLimited investigationFinal reportBeech 400A · Atlanta, GAThe flight crew's failure to obtain the proper airspeed for landing, which resulted in the airplane touching down too fast with inadequate runway remaining to stop and a subsequent runway overrun. Contributing to the accident were the failure of either pilot…NTSB DCA12WA098Incident · No injuriesForeign investigationBoeing 747 · Jeddah, Saudi ArabiaThe General Authority of Civil Aviation of the Kingdom of Saudi Arabia (GACA) has notified the NTSB of an accident involving a Boeing 747 that occurred on June 18, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the GACA investigation…NTSB CEN12LA381Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Farmersville, OHThe pilot did not maintain directional control of the airplane on takeoff after noting reduced engine power in high density altitude.NTSB CEN12IA377Incident · No injuriesIncident investigationFinal reportPiper PA-28R-200 · Lacon, ILThe propeller blade’s failure due to a fatigue crack that originated from a surface gouge that resulted from foreign object damage to the propeller blade that occurred at an unknown time.NTSB CEN12CA405Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Glencoe, MNThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB WPR12LA267Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Scottsdale, AZThe flight instructor’s failure to maintain adequate rotor rpm during a practice autorotation, which resulted in a loss of helicopter control and subsequent hard landing.NTSB WPR12IA296Incident · No injuriesIncident investigationFinal reportCirrus Design SR20 · Deer Valley, AZThe pilot's failure to maintain directional control during taxi due to excessive taxi speed.NTSB WPR12CA270Accident · No injuriesData collectionFinal reportFisher Harold R 320 · Adelanto, CAThe pilot's failure to maintain clearance from a fence during takeoff initial climb. Contributing to the accident was the pilot's decision to not use all of the runway distance available for takeoff and the high density altitude.NTSB WPR12CA268Accident · Minor injuriesData collectionFinal reportCessna 182P · Woodland, CAThe pilot's failure to maintain a proper descent path during the approach to land, which resulted in a hard, bounced landing, and his improper retraction of the flaps during the subsequent attempted go-around.NTSB ERA12CA439Accident · No injuriesData collectionFinal reportCessna 172S · Frederick, MDThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB DCA12IA096Incident · No injuriesIncident investigationFinal reportAirbus A320 · Las Vegas, NVthe failure of the right main landing gear door retraction flexible hydraulic line in the Green hydraulic system, which led to prolonged operation of the power transfer unit and subsequent overheating and loss of pressure in the Yellow hydraulic system,…NTSB CEN12LA379Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Lakeview, ARThe pilot's improper flare and recovery from a bounced landing.NTSB CEN12FA378Accident · 4 fatalField investigationFinal reportIar Brasov IS-28B2 · Wallis, TXThe pilot’s failure to maintain adequate airspeed during an emergency situation, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s acute coronary event, which resulted from his severe…NTSB CEN12CA393Accident · Serious injuriesData collectionFinal reportNational Ballooning 858 · Pierce, NEThe balloon pilot’s encounter with increased wind during landing, which resulted in a hard landing and a passenger’s injury.NTSB ANC12CA053Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Skwentna, AKThe pilot’s selection of unsuitable terrain for taxi.NTSB WPR12LA265Accident · Serious injuriesLimited investigationFinal reportRoetman Ryland K JR Eagle · Rexburg, IDA loss of engine oil pressure, which led to the subsequent uncommanded loss of thrust and decrease in the propeller rpm during a low-level aerobatic maneuver.NTSB WPR12CA266Accident · No injuriesData collectionFinal reportCessna 182H · Meadow Creek, MTThe pilot's misjudged approach and improper landing flare, which resulted in a hard landing.NTSB ERA12LA405Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe pilots’ operation of the airplane with an insufficient supply of engine oil, resulting in engine seizure and total loss of engine power.NTSB ERA12LA400Accident · No injuriesLimited investigationFinal reportBarney Oldfield Baby Lakes · Anderson, SCA total loss of engine power as a result of an inadequate amount of lubricating oil in the engine. Contributing to the accident was the pilot's improper preflight inspection.NTSB CEN12LA384Accident · Minor injuriesLimited investigationFinal reportPeterson-Feder-Splinter Starduster TOO · Lake Dallas, TXA partial loss of engine power on takeoff due to a stuck intake valve on the No. 2 cylinder.NTSB ANC12CA054Accident · No injuriesData collectionFinal reportCessna 172 · Skwentna, AKThe improper decision of the driver of the all-terrain vehicle to enter an active runway.NTSB ANC12CA052Accident · No injuriesData collectionFinal reportPiper PA-18 · Willow, AKThe pilot's decision to land on an unsuitable landing surface into bright sunlight, which resulted in a loss of control.NTSB ERA12LA397Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Biddeford, MEA total loss of engine power due to water contamination of the fuel. Contributing to the accident was the pilot/owner’s inadequate preflight inspection.NTSB ERA12FA395Accident · 1 fatalField investigationFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Westminster, MDThe pilot's inadequate preflight inspection, which failed to ensure that the elevator quick-fastener was properly secured, resulting in an inflight elevator control disconnect and subsequent loss of control during the ensuing emergency landing. Contributing…NTSB ERA12CA416Accident · No injuriesData collectionFinal reportCessna 172M · Churchville, MDThe tractor operator's failure to confirm the landing airplane's position before entering an active runway, which resulted in a ground collision.NTSB ERA12CA404Accident · No injuriesData collectionFinal reportCessna 172K · Tupelo, MSThe pilot's improper recovery from a bounced landing.NTSB CEN12IA383Incident · No injuriesIncident investigationFinal reportCessna 560 · Ozark, MOThe airplane’s collision with a deer during the landing roll.NTSB CEN12CA380Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Sheboygan, WIThe pilot’s failure to maintain directional control during the takeoff roll.NTSB CEN12CA375Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Ipswich, SDThe pilot's failure to abort the takeoff, which resulted in a runway excursion.NTSB ERA12LA399Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Mariner · Oak Island, NCThe pilot's failure to properly execute the helicopter practice autorotation recovery, which resulted in a collision with the water.NTSB ERA12CA396Accident · No injuriesData collectionFinal reportCessna 150M · Gulf Shores, ALThe student pilot's improper flight control inputs and the flight instructor's delayed remedial action during the attempted go-around, which resulted in an aerodynamic stall.NTSB CEN12LA374Accident · No injuriesLimited investigationFinal reportYakovlev Yak-52 · Loveland, COThe pilot’s inadvertent closure of the pneumatic system valve, which resulted in the nose landing gear not fully extending before landing. Contributing to the accident was the pilot's reliance on the mechanical landing gear position indicators instead of the…NTSB CEN12CA372Accident · No injuriesData collectionFinal reportCessna TP206A · Alpine, TXThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a runway excursion.NTSB CEN12CA370Accident · Minor injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Erie, COThe student pilot’s improper performance of a soft field takeoff procedure, which resulted in a loss of airplane control, and the flight instructor’s delayed remedial action to correct the situation.NTSB ANC12LA051Accident · No injuriesLimited investigationFinal reportDehavilland DHC-2 · Talkeetna, AKThe loss of engine power after departure due to the separation of an engine cylinder.NTSB WPR12LA263Accident · No injuriesLimited investigationFinal reportCessna A185F · Winnett, MTA momentary loss of engine power, which led to an emergency descent at night during which the airplane collided with a wire. The reason for the loss of engine power could not be determined because postaccident examination and operation did not reveal any…NTSB ERA12LA394Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Ocilla, GAA failure of the No. 2 cylinder connecting rod due to a lack of lubrication, which resulted in a total loss of engine power.NTSB DCA12LA091Accident · Serious injuriesLimited investigationFinal reportBoeing 737-724 · Winnie, TXthe flight crew's penetration of a rapidly developing thunderstorm cell in an area of forecasted convective activity. The serious injuries were the result of a misunderstanding between the captain and cabin crew regarding the potential for turbulence.NTSB WPR12LA259Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 II · East Wenatchee, WAThe pilot’s failure to adequately monitor the environment and maintain clearance from the power lines while maneuvering at low altitude.NTSB WPR12CA258Accident · No injuriesData collectionFinal reportStemme S10-VT · Warner Springs, CAThe pilots’ failure to maintain directional control while landing in a gusting crosswind.NTSB ERA12WA426Accident · Minor injuriesForeign investigationCessna 150M · Licey, Dominican RepublicOn June 12, 2012, about 2140 universal coordinated time, a Cessna 150M, Dominican Republic registration HI-561, was substantially damaged during a forced landing following a propeller tip separation. The foreign certificated pilots received minor injuries.…NTSB ERA12CA392Accident · Minor injuriesData collectionFinal reportBowles Chris Kitfox 5 · Owenton, KYThe pilot's failure to attain the proper airspeed during takeoff, and the flight instructor's delayed remedial action, which resulted in a loss of airplane control. Contributing to the accident was the flight instructor's lack of previous experience in the…NTSB CEN12LA368Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Hooker, OKThe pilot’s loss of airplane control after a partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine revealed no evidence of mechanical malfunctions or failures, which resulted in an…NTSB CEN12LA362Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Mt. Vernon, MOThe pilot’s decision to continue the landing on a short grass runway with a tailwind after touching down beyond the touchdown point, and his subsequent failure to stop the airplane before colliding with trees off the end of that runway. Contributing to the…NTSB WPR12LA256Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Riverton, WYAn engine overspeed shortly after takeoff for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR12CA257Accident · No injuriesData collectionFinal reportCessna 182A · Colfax, WAThe total loss of engine power during cruise flight due to the missing carburetor drain plug, which had not been secured with safety wire.NTSB ERA12CA393Accident · No injuriesData collectionFinal reportNorth American AT-6C · Delmar, DEThe pilot's failure to go around after not attaining the proper touchdown point, which resulted in a runway excursion and noseover.