FAA incident reports
234,323 FAA reports of aviation accidents and incidents, from the FAA’s Accident/Incident Data System (AIDS) through its Aviation Safety Information Portal. An incident falls short of an accident: a bird strike, say, or a gear-up landing without substantial damage. The NTSB investigates accidents separately, and its record of an accident is the fuller one.
Reports, newest first
Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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.
Incident 20120927023979IBishop Raymond Max Aero Spec 2150 · Mesa, AZThe airmen was performing slow flight manuvers when the engine lost power. An emergency was declared to iwa tower and then an attempt to reestablish power was made. Once power was restored, the airmen climbed to altitude and determined the aircraft was…Incident 20120927023549ICessna 210E · Fort Worth, TXOn September 27, 2012, at approximately 1250 LCL, N4916U, a Cessna CE-210E aircraft, sustained minor damage during a gear up landing at Meachum Airport (kftw) Fort Worth, TX. The pilot-in-command, [privacy data omitted], holder [privacy data omitted],…Accident 20120927023099ALake LA-4 · Kenosha, WIPilot performed successful run up and departed runway 7R at Kenosha. During the take off roll, engine began sputtering. Pilot continued roll and became airborne. Engine quit and pilot attempted emergency landing in parking lot. Aircraft struck a small hill,…Incident 20120927022029IPacific Aerospace 750XL · Randleman, NCAt approx 1445 the ranger group all veteran parachute team conducted a demo jump at victory junction in Randleman, NC. One team member, [privacy data omitted], conducted a low turn maneuver at approximately 100' and his chute did not recover from the turn. He…Incident 20120927021429IAviat A-1B · Sheridan, WYOn 09/27/2012 at approximately 1945 hrs. MDT, N13HY an Aviat Aircraft Inc. Model A-1B husky aircraft sustained minor damage while landing at Sheridan county (kshr) airport, WY. The lone occupant on board was not injured. Weather at the time was visual…Incident 20120927021219IBoeing 737-81Q · Concord, NCPilot attempted to make a positioning right turn onto runway 020 from taxiway b at the jqf airport. The aircraft right main tire truck went off of the taxi/runway intersection pavement and the right engine nacelle broke a taxi light. The aircraft came to rest…Incident 20120927020719IInfinity Powered Parachutes Infinity CLASSIC2006 · St. George, UTAircraft encountered downdraft from near by hills while manuevering clear of a launching balloon. The powered parachute settled hitting a dirt burm by the road side. After hitting dirt burm it slid down a slope damaging prop, prop hoop and some side rails. No…Incident 20120927020159IFairchild 24 G · Mt. Vernon, WAOn September 27, 2012, approximately 15OO PDT, a Fairchild 24G, N19143, received minor damage resulting from a loss in directional control during landing roll at runway 22 at skagit regional airport. The private pilot, owner, and the sole occupant of the…Incident 20120926024949ICessna 182 · Minden, NEThe airman was enroute from Texas to Nebraska on a night VFR flight. At approximately 0223 UTC, and 12 nautical miles from his destination, he notified air traffic control that he had ran out of gas. The closest airport was Minden, Nebraska and he questioned…Accident 20120926024069AInfinity 2003 · Merrill, MIPilot failed to clear trees at the end of the departure runway. Takeoff initiated at runway midpoint.Incident 20120926022359ICessna 206H · Topeka, KSDuring the takeoff roll the right hand wheel fairing came loose. Upon landing the wheel locked up and the aircraft went in to the grass off the right side of the runway at midfield.Accident 20120926022059ABeech E33 · Greeley, COOn 9/26/2012 at approximately 1500 hrs. MDT, N7133N, a Beechcraft model E33 bonanza aircraft sustained substantial damage after making an off airport landing near greely-Weld county (kgxy) airport. The sole occupant on board was uninjured. Weather at the time…Incident 20120926020959IPiper PA-24-260 · La Crosse, WIAircraft landed gear up.Accident 20120926020359ACessna 208B · Statesboro, GAOn 9/26/2012 @ approximately 1300L dst I was a participant in a telephone conference call with 3 atl FSDO operations inspectors. The purpose of the phone conference was to question the PIC and the CFI that were aboard acft N127AR when the accident occurred.…Accident 20120925025229ACessna 175A · Spearfish, SDOn September 25, 2012, at approximately at 1800 MDT a Cessna 175 executed a forced landing approximately 12 miles west of Spearfish, south dakota. VFR conditions prevailed. The aircraft was destroyed and the pilot and passenger were uninjured. The pilot holds…Accident 20120925023289ARobinson Helicopter R22 Beta · Anchorage, AKR-22 helicopter hover autorotation:the CFI was PIC for the flight with a student in which simulated power failures at a hover (hovering autorotations) were being practiced. The student rolled throttle to idle position, but simultaneously pulled up collective…Incident 20120925023089IMooney M20J · Wheeling, ILN201UW was cleared to land on rwy 16 at Chicago Executive Airport (kpwk). The pilot did not extend the landing gear and thus landed "gear up" on rwy 16. There were no reported injuries and the aircraft sustained minor damage.Accident 20120925022289ACessna 172P · Richmond, KYCessna N53720 model 172P was being operated as an instructional flight for 141 school okzs performing touch and go's at the Richmond Madison County Airport I39 09/25/2012. According to pilot statements student was in the 5th landing pattern approaching the…Accident 20120925022009ADavis Mark Davis KR-1 · Albuquerque, NMOn September 25, 2012 at 1411 MST, an amateur built mark Davis Davis KR1, N6155X, with expired registeration, crashed during landing at Double Eagle II Airport, Albuquerque, new Mexico, while in route to mount vernon, Illinois. Visual meterological conditions…Incident 20120925021709IStaffeld Gary C Staffeld DR109 · Granbury, TXAircraft struck deer on landing roll out.Accident 20120925021629ACessna 150 · Saint John, AZOn 09/26/2012 a report was received by regional operations center that on 09/25/2012 at approximately 1100 am a pilot stated that he was attempting to land on a dirt strip. The pilot stated that he had lost control of his aircraft and impacted a sand burm…Accident 20120925020919AMccleery Gregg A Rans S6ES · Elverta, CAThe engine run-up was normal. Then seconds after the aircraft was maneuvering to establish a normal climb the engine shut down in flight. The loose of power resulted in aircraft continued on its northerly flight path the aircraft executed an off field landing…Incident 20120924028649IBeech A36 · Uvalde, TXSept. 24, 2012, a pilot landed his Beech A-36 gear up after he had performed two touch and go's at the Uvalde airport. This incident was not reported at the time. At the time of the incident, the pilot was told it was not a reportable incident. This incident…Accident 20120924022099ASikorsky S-76C · Theodore, ALWhile hovering backwards from lift off point and turning right the tail rotor blades went into a parked bell 206 helicopter main rotor bladeAccident 20120924021739AMcdonnell Douglas Heli 369FF · North Las Vegas, NV9-24-2012 At 16:00 local time, N911BL, a MD-369FF (MD530F) public use aircraft was involved in an accident during an instructional flight. The pilot in command and the pilot under instruction were performing practice autorotions. On the tenth autorotation,…Incident 20120924021519IDowner Bellanca 14-19-2 · Lancaster, CAOn 09/04/2012, N7658B, a Bellanca 14-19, landed at fox field, Lancaster, CA. On landing rollout, the right main gear retracted, N7658B'S right wing tip contacted the ground. N7658B turned off of the runway to the right, dragging the right wing tip to a stop.Incident 20120924020379IDassault/Sud FAN JET Falcon · Rutland, VTOn Monday, September 24, 2012, a Dassault falcon (DA-20) landed on the centerline of runway 19 at Rutland -Southern Vermont regional airport (rut) in VFR weather with light winds. When the PIC applied the brakes the aircraft veered to the left on the runway.…Accident 20120923023269APiper PA-12 · Fairbanks, AKDate of accident was 9/23/2012 @ 2200 uct. Pilot, said he was flying to his hunting camp south east of Fairbanks, Alaska. He ran the right wing tank dry, and switched to the left tank and the engine would not restart. The aircraft landed in the tundra and…Incident 20120923022619IPiper PA-24 · Fernandina Beac, FLThe PIC made an intentional gear-up landing on closed rwy 36 after several unsuccessful attempts to fully extend the landing gear (the gear would only extend part of the way).follow-up inspection of the acft by the PIC and mx personnel after removal of the…Incident 20120923022609IGulfstream American AA-5B · Lakeland, FLThe PIC while initiating landing during a pleasure flight, conditions clear & calm and all indications appeared normal until touchdown. The pilot stated she experienced a hard landing and subsequent single bounce and decided the appropriate action was to…Accident 20120923022599ACessna 172B · Jacksonville, FLSouthern region operations center & the NTSB reported to this office that remnants of a small aircraft was sited and recovered off the coast near Jacksonville. Reports indicated the piece, a wing section containing the fuel tank was recovered from a fishing…Incident 20120923022369IDehavilland DHC-6 Twin Otter · Perris, CA1 Fatal when two skydivers collided under canopy over Perris. One skydiver deployed her reserve parachute about 400 feet above ground struck her head in a canal. She was transported unconsious by helicopter.Incident 20120923022239ICessna 175 · Kill Devil Hill, NCPilot stated during final approach to runway 2 established a good stable approach, descended to the flare just past the numbers and touched down about less than a quarter of the way down the runway. To that point the approach to landing and flare seemed…Accident 20120923022039ANavion Navion A · Lompoc, CAAfter take off, engine lost power on right downwind leg. Pilot turned fuel boost pump on, had no effect. Pilot turned back to runway for landing. Landed in field 250 yards short of runway.Incident 20120923021789ILindros Carl Tte Lancair IV · Burbank, CAWhile in cruise flight, the engine began to run rough. An emergency was declared and landing was performed. Maintenance personnel found the following: number 6 cylinder exhaust valve rocker arm had come loose from the cylinder attachment.Incident 20120923021469IBeech 76 · Fort Lauderdale, FLDuring training flight in multiengine aircraft, PIC performed inflight shutdown of right engine using emergency checklist to simulate engine failure. During the attempt to restart engine propeller would not unfeather. Multiple attempts were made to restart…Incident 20120923021419IBeech 23 · Milledgeville, GAOn 09/23/2012 approximately around 1050AM EDT aircraft registration N8741M a Beechcraft BE-23 departed kennesaw ga (kryy) on route to Milledgeville ga (kmlj). The aircraft was routed over hartsfield/jackson atlanta airport (katl) then direct to Milledgeville…Accident 20120922023069ACessna 182Q · Fort Thomas, KYOn final approach to luk the pilot experienced a loss of engine power resulting in an uncontrolled decent into a heavily wooded ridgeline. The aircraft was destroyed during the crash sequence. Pilot and passenger sustained minor injuries. Reviewed by dws…Accident 20120922021999ALindstrand Balloons 210S · Albuquerque, NMOn September 22, 2012 at 0745 MDT, a hot air balloon, N608RR, a Lindstrand model 210S, experienced a hard landing one mile north of the montano bridge, west side of Albuquerque, new Mexico over the rio grande river, while on a commercial balloon ride. Visual…Accident 20120922021699AAir Tractor AT-502 · Firebaugh, CAAt aproximately 5:10 pm the pilot was departing a private agriculteral airstrip for the first spraying application for the day. The aircraft was full of fuel and had approximately 400 gallons of chemical to be sprayed on board. The pilot had not asked the…Incident 20120922021599IBeech E-90 · Longmont, COOn 09/22/2012 at approximately 1802 hrs. MDT, N500MS a Beechcraft model E-90 king-air aircraft sustained minor damage while landing at Longmont (klmo) airport, CO. The lone occupant on board was not injured. Weather at the time was visual meteorological…Accident 20120922021499ACessna 172S · Land O Lakes, FLOn September 22, 2012, ar 0155 EDT, a Cessna 172, N21750, collided with the ground at Land O Lakes, Florida while on a flight to tampa executive airport (kvdf). Visual meteorological conditions prevailed at the time. The aircraft was destroyed and the pilot…Accident 20120922021229APiper PA-28-140 · Maryville, TNPilot departed (tys) mcgee tyson airport located in aloca Tennessee at approximatley 0700. Pilot landed at his personal 1900' grass strip located at [privacy data omitted] Maryville Tennessee, approximatley 8 nautical miles from (tys). Pilot had 36 gallons of…Incident 20120922021189IDehavilland DHC-6 Twin Otter · Williamstown, NJAt approximately 12:00PM,[privacy data omitted] a licensed skydiver with about 50 jumps, made a skydive in Williamstown, NJ at skydive Cross Keys. The skydiver jumped solo from 5000', deployed her parachute and was in control. She flew herself downwind of the…Incident 20120922020929IAeronca 15AC · Lakeville, INDuring water taxi in a flying cable snapped causing the aircraft to list slightly to the left. This was the only damage which occurred. This is one of four cables which is attached from the bottom of the aircraft to the pontoon.Accident 20120922020149APiper PA-28R-180 · Roanoke, TXOn September 22, 2012 at approximately 1330 hours, N4567J, a Piper PA-28R-180 operated by the aircraft owner crashed following takeoff from runway 17 at north west regional airport, Roanoke , Texas (52F), during an instructional flight to familiarize the…Incident 20120922019739ICessna 172S · San Marcos, TXThe pilot landed nose low striking the nose tire right main and propeller the aircraft travelled over 1600 feet departing the runway after 1000 feet and came to rest off the runway and in the grassIncident 20120922019379IBell 205A-1 · La Grande, ORThe pilot was dipping water from a remote pond with a bucket on a 100' long line for usfs fire fighting use. During the climb with a full bucket the pilot heard a bang and the aircraft rolled slightly to the rt. The power the engine was developing had been…Incident 20120921024269ICanadair CL-600-2A12 · Denver, COOn 9/21/2012 at approximately 1430 hrs. MDT, N125PS, a Canadair Ltd. Model CL-600-2A12 challenger aircraft sustained no damage after making an emergency landing at Denver International (kden) airport. There were no injuries to the ten occupants on board.…Accident 20120921023719ACessna 150G · Corinth, MSAt 1600FT the aircraft lost power and began to circle and descend near crx. The aircraft landed in a soybean field, and flipped over. No injuries to pilot or passenger.