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 20060506010179IMooney M20K · Sarasota-Braden, FL(-23) On may 06, 2006, at approximately 1930 EST, N228RM, a Mooney M20K registered to lasersoft imaging inc., sustained minor damage when the left main gear, which partially extended, on approach, collapsed after landing at the Sarasota…Incident 20060506008219IAmtr NIEUPORT17 · Chandler, AZ(-23) Pilot's statement: pursuant to our visit at chd this morning, the following is what happened from my perspective: I was in a 2-ship take-off from kchd on Saturday, may 5, 2006. The purpose of the intended flight was to have breakfast at nearby williams…Incident 20060506007889IAlmqui Bushmasterii · Palmetto, FL(-23) On may 06, 2006, at approximately 1545 EST, N53BM, an experimental amateur built bushmaster ii registered to the pilot sustained minor damage on landing at airport Manatee (48X) in Manatee, Florida. The personal flight originated from 48X moments…Accident 20060506007769ACessna 150G · Coleman, TX(-23) On may 6, 2006, approximately 1720 CDT, a Cessna 150 airplane, N3815J, was substantially damaged when it ran out of fuel and struck the ground after takeoff from the Coleman Municipal Airport in Coleman, Texas. The private pilot suffered facial…Accident 20060505030519ACessna 182F · Canby, OR(-23) Pilot landed short of grass strip private runway. Aircraft nose gear hit 12 inch berm dividing two grass fields causing subtantial damage to aircraft. No clear transition area between two fields, however pilot owned field and has personal knowledge of…Accident 20060505010039AUrocop EC120B · Patterson, LA(-23) During a climbing turn the cyclic moved un-commanded to the forward right, and collective moved upward. The pilot was unable to compensate for these un-commanded control movements. Entire hydraulic system removed and sent for further evaluation by NTSB.…Accident 20060505008709ACessna 172S · Muscle Shoals, AL(-23) Student pilot's first solo flight. First take off pattern and landing with no problems. The pilot taxied back for another takeoff. On takeoff roll the aircraft started to drift to the left. The pilot was unable to maintain directional control of the…Accident 20060505008399APiper PA28R180 · Chester, CT(-23) On 05/05/06 at approximately 1842 zulu hrs 1 pilot and 2 passengers aborted take-off from runway number 35, at (snc), Chester, CT. (PIC was interviewed immediately after the accident). He stated that the aircraft had a loss of lift at full engine power…Accident 20060505008099AAmtr Rutandefiant · Coeur D Alene, ID(-23) Pilot failed to lower the nose gear prior to landing causing the aircraft to skid on the lower nose fuselage over 2,000 feet down the runway. This particular aircraft's design is unique whereas the vertical stabilizer/rudder are located under the…Incident 20060505007999IAmtr VANSRV4 · Saint George, UT(-23) Pilot landed in strong gusty winds. When taxiing to hangar, he turned down wind and was unable to control the attitude of the aircraft. The tail lifted and the propeller struck the pavement. Pilot may have mis-managed flight controls or wind exceeded…Incident 20060505007839ICessna 210D · Ash Flat, AR(-23) On may 5, 2006 at 1615 CST a Cessna 210 (N3754Y), piloted by [privacy data omitted] made a gear up landing at the Sharp county airport (cvk). Upon approach the pilot attempted to extend the landing gear but only the nose gear would extend. After…Accident 20060505006719ABeech 23 · Kingman, AZ(-23) On may 05, 2006 at Kingman Airport Kingman, AZ., at approximately 0830, student pilot [privacy data omitted] owner and operator of a Beechcraft BE-23-23, N8750M, crashed on landing when following a twin aircraft for touch and go on runway 21. Aircraft…Incident 20060505006439ICessna 172M · Cleveland, TX(-23) Pilot was doing touch and go's as she was making a landing the plane porpoised once on the main gears then settled down then bounced again on the main gears she then touched the nosewheel down and the plane veered to the right and left the runway. The…Incident 20060504016739ICessna 150L · Indian Head, MD(-23) Crew lost power, landed in open field, after on ground aircraft response and engine normal, no further problems. Checked fuel filters before taking off all clean.Incident 20060504013809ICessna 172S · Fort Worth, TX(-23) Student conducting practice touch and go's lost control of aircraft, struck prop, and broke off tail tie down hook. Firewall skin wrinkles. Poi dispatched this morning 5/5/2006 to review student and flight instructor records and to coordinate…Incident 20060504013189IBraero BAE125800A · Lincoln, NE(-23) On may 4, 2006, at approximately 1758 local CDT, a Hawker BAE-125-800A, N71MT, experienced an inflight loss of control during a maintenance test flight northwest of Lincoln, Nebraska. The aircraft had just come out of extensive maintenance and…Incident 20060504011559IDorner DO228202 · Grand Canyon, AZ(-23) During taxi and with the use of a ground guide, this aircraft struck the tail of a parked aircraft. No injuries and minimum damage to both aircraft.Incident 20060504011499IBeech V35 · Murfreesboro, TN(-23) Pilot induced gear up landing due to distraction of aircraft exiting the runway.Incident 20060504011299ICessna 172S · Lincoln Park, NJ(-23) Pilot landed long on runway 01 and ran into a pole and chain at the airport perimeter resulting in damage to the propeller and spinner, the right side of the cowling, right-hand wing strut, right-hand main gear strut, nose gear tire fairing and the tail…Incident 20060504008209IAmtr MA33MR912 · Anchorage, AK(-23) While taxiing on romeo (r) taxiway, the nose wheel brake assembly collapsed and the nose fork dug into the pavement. With a gusty wind on his tail and when the nose fork struck the pavement, the wind picked up the ultralight and flipped it over, causing…Accident 20060504008149AAmtr Barracuda · Monett, MO(-23) The pilot was attempting to land with the right main landing gear extended and the left main and nose gears retracted because of a landing gear system malfunction. He shut down the engine and turned off the fuel on base leg to minimize damage to the…Incident 20060504007879ICessna 172P · New Bedford, MA(-23) On may 5, 2006 pilot in command [privacy data omitted] reported to the new england FAA communications center that he had been involved in an inflight fire incident the previous night out of New Bedford airport (ewb). The PIC stated a few moments after…Accident 20060504007759AAmtr Glasairiii · Daytona Beach, FL(-23) As the pilot turned base for landing on runway 5 at Spruce Creek Airport he lost engine power and was not able to maintain control of the aircraft. At approximately 10 feet off the ground the aircraft stalled and impacted the runway causing substantial…Accident 20060504007739ABell 206B3 · Fallbrook, CA(-23) On may 4, 2006, about 0930 pacific daylight time, a Bell 206B3, N2763R, crashed into trees while conducting an aerial spraying operation near Fallbrook, California. Both pilots sustained minor injuries. The helicopter, owned and operated by pacific…Accident 20060504007709AIndusa T211THORPEDO · Saline Valley, CA(-23) During approach and landing at Saline Valley, CA airport, aircraft landed approx 200 yds short of runway after pilot allowed aircraft to become too low and too slow to recover. Aircraft sustained substantial damage with main landing gear and prop…Accident 20060504007659AAmtr Renegade · Port Angeles, WA(-23) [privacy data omitted] lost power in cruise and did emergency landing on private property west of airport. Pilot not injured. Aircraft is ultralight of canadian registry. Substantial damage.Incident 20060504007499IAmtr Helicycle · St Louis, MO(-23) The pilot reported that he was flying for about 10 minutes and making an approach to the metro west heliport just west of sus. On short final at about 100 ft AGL and 45 knots the helicopter began to shake violently. He lowered the collective to hasten…Incident 20060504006869IBeech 58 · Tuscaloosa, AL(-23) The pilot [privacy data omitted] stated that on take off roll, at rotation speed the crew entry door opened. He aborted the take off and came to a stop on the runway and he and the passenger seated in the right front seat [privacy data omitted]…Accident 20060504006779AHughes 269C · Kings Park, NY(-23) The aircraft departed hpn, where it is based, at approximately 0845 am and proceeded to isp on an instructional flight. On the return flight to hpn at approximately 1200 feet, a rapid knocking sound was heard followed by a loss of oil pressure and a…Incident 20060504006639IDiamon DA20C1 · Tucson, AZ(-23) On may 4, 2006 at 1930 MDT a katana DA-20, N976CT registered to norfolk & whei LLC, had the nosewheel break off on landing at san juan pueblo airport, espanola, new Mexico while on a solo cross country. Visual meteorological conditions prevailed at the…Incident 20060504006389ICessna 152 · Byron, CA(-23) May 4, 2006, Cessna 152, N6165M, approximately 1510 local time at the Byron Airport (C83) in Byron, CA student pilot was performing his 4th solo landing on runway 23. The wind was a right crosswind at between 7 and 10 knots. The student pilot landed the…Accident 20060503014319AHughes 269B · Sullivan, OH(-23) Pilot was cruising about 600' when he felt and heard a loud "bang" which was likely the left side tailboom brace breaking at the cluster fitting, which resulted in a subsequent forced landing. Pilot had no pedal control initiated autorotation aircraft…Incident 20060503011339IBbavia 11BC · Weedsport, NY(-23) On 5/03/06, at approximately 11:00 am, an Aeronca AR-11-BC, N4045E, landed at whitford's airport, Weedsport, NY, on runway 10/28. Upon landing the engine quit, prompting the pilot/owner, [privacy data omitted] to exit the aircraft and attempt to "prop…Incident 20060503010569ICessna 310L · Denver, CO(-23) After takeoff pilot heard "bang noise" when he retracted the landing gear. Pilot observed unsafe landing gear indication in cockpit. Pilot contacted the tower and flew by tower, the tower reported the nose landing gear appeared to be only partially…Accident 20060503009619AScwzer SGS126D · Aguila, AZ(-23) Glider pitched up on tow. The tow rope broke. The glider started a turn, stalled, entered an incipient spin and the impacted the ground.Accident 20060503005419APiper PA22150 · Rangley, CO(-23) While landing at rangely Colorado (4V0) on 05-03-2006, 1045 local time, civil aircraft N6946B, a Piper PA-22, piloted by [privacy data omitted] nosed over causing substantial damage due to the inadvertent application of the brake. There were no injuries.Accident 20060503005309APiper PA28181 · Columbia, CA(-23) After a normal approach, and 2-3 seconds after landing, the plane suddenly veered to the right as the left wing lifted, due to a sudden strong gust of wind. The pilot applied left aileron and rudder but "was along for the ride" as the airplane exited…Incident 20060502023139IEMB EMB145LR · Chicago, IL(-23) Aircraft landed 22R at ord. At initial brake application aircraft began to veer to the right. The aircraft eventually departed the right side of the runway coming to rest in the grass approximately 2500 ft from the departure end of the runway.Accident 20060502011799ACessna 172D · Lumberton, NJ(-23) The student was attempting his fifth solo flight. His last solo flight was on 09/08/2005. The student has a total of about 1.4 hrs of solo time in four previous solo flights, this is out of a total of about 74 hrs of flight instructions. After an hour…Accident 20060502009489ARobsin R44RAVENII · Rocky Point, NC(-23) Pilot was returning from myrtle beach after a series of photography flights there. He noted a flashing tail rotor gear box chipls light, which then became steady. He initiated a precautionary landing in a field next to route US117, just north of state…Incident 20060502007549IBell 206B · Intracoastalcit, LA(-23) Severe inflight compressor stall, causing yaw action. Pilot completed successful autorotation to the ground.Incident 20060502007249IEMB EMB145XR · Houston, TX(-23) Aircraft N12166, flight 3161, blew both left main tires on takeoff. The flight departed george bush Intercontinental airport Houston, Texas (iah) at 4:02 pm CDT enroute to minneapolis, Minnesota. There were 48 souls on board (45 pax and 3 crew). The…Accident 20060502006789ACessna 182L · Abita Springs, LA(-23) Pilot made several attempts (6-7) to get the aircraft in the air. Witnesses say the aircraft was not making power, the pilot got the aircraft in the air and at 200-250 ft, AGL, the aircraft engine lost power, and banked to the left and crashed in the…Incident 20060501009049IAirbus A300B4203 · Toronto, CN(-23) Express net airlines operated an Airbus A-300-B4203 aircraft (N372PC) from dayton, Ohio usa (kday) to Toronto, Canada (cyyz). While on approach into cyyz, the flight crew noticed a significant yaw to the right. Approximately 3 degrees of rudder was…Accident 20060501007669ARobsin R44RAVENII · Desert Center, CA(-23) [privacy data omitted] aircraft departed the Robinson helicopter company in torrance California at approximately 1300 hours with pilot and passenger on delivery flight to ontario, Canada. At approximately 1430 PST, approximately 20 miles east of blythe…Accident 20060501006959AAirtrc AT802A · Woodville, TX(-23) Restricted cat ag operating under part 137 with 5500 lbs of fertilizer left jasper, TX (kjas) VFR after a 20 min flt acft eng would not maintain RPM. Pilot made emergency landing at dykes ranch, rt 3, box 476, Woodville, TX 75979. Aircraft rolled,…Accident 20060501005999ABell 206B · Vinita, OK(-23) On may 01, 2006, at approximately 2000 hrs CST, a Bell 206B, piloted by an appropriately rated private pilot, substantially damaged the helicopter while attempting to autorotate, the aircraft came to a stop inverted. The aircraft was approximately 7…Accident 20060501005429ACessna 172N · Miami, FL(-23) Pilot failed to control aircraft during landing. Aircraft landed hard, causing loss of pitch control. The aircraft firewall and floor structure were damaged upon impact. The aircraft then bounced 4 times and came to a full stop on the runway surface.Incident 20060430015329ISaab 340B · Kalamazoo, MI(-23) During the takeoff roll at approximately 50 to 60 knots airspeed a "pop" was heard from the left engine and a sharp yawing moment was experienced. Power was reduced and the takeoff was aborted. The aircraft was taxied off the runway and stopped. The…Accident 20060430012159ACessna 172L · Mercersburg, PA(-23) During cruise flight aircraft descended into densely wooded area and collided with the earth.