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.
Accident 20000609011299AAmtr Kitfox · Spruce Pine, NC(-23) N715DZ departed avery county airport (7A8) for shiflet field (9A9) marion, NC. After 15 minutes and approx. 3 miles from 7A8 the non certified Rotax engine of the experimental homebuilt a/c stopped producing power and a forced landing in mountainous…Accident 20000609009609ACessna 182H · Hillsboro, OR(-23) During the cruise and landing sequence the pilot was overly concernedwith the a/c performance and perceived low airspeed indication for the power setting. On the first attempt to land he accomplished a go-around. On second attempt, landed mid-field fast…Accident 20000608043889APiper PA28R200 · Mesquite, TX(-23) On June 8, 2000 at approximately 16:30 central time, a PA-28-200, single engine airplane, N4861T was on landing roll at Mesquite airport when it lost control and veered off the runway into the grass where it suddenly spun around and came to a stop.…Accident 20000608040329ACessna 177 · Nacogdoches, TX(.4) During a simulated emergency approach to a landing area, at 75 feet AGL, the flight instructor told the student pilot to go-around. The student attempted to add full power; however, he could not fully turn off the carburetor heat. The instructor stated…Accident 20000608037079AN3148E · Hartford, MI(-23) On takeoff, pilot bounced twice in ground effect. On the second bounce, the nosewheel housing may have fractured jamming the nose wheel to the right. The nosewheel and rudder are interconnected to both rudder pedals and rudder nosesteer hand control.…Incident 20000608035879IBoeing 7373H4(-23)On June 8, 2000, at approximately 1413 CDT, southwest airlines flight 1542, a Boeing 737, N605SW, while enroute from dfw to stl, informed R31 that they had lost cabin pressurization and needed to start a emergency descent. During the decent, crew…Incident 20000608033899IStolam RC3 · Lake Pleasant, NY(-23)While on approach for a water Landing at Lake Pleasant, speculator, NY, pilot lowered the Landing gear causing the aircraft to flip inverted on contact with the water, coming to rest in approximately 10 feet of water.Incident 20000608033879ICessna 310F · Chambersburg, PA(-23)[privacy data omitted] was enroute from columbus, Indiana to allentown, Pennsylvania at 9000' altitude and the left engine lost power. Feathered propeller and diverted to Chambersburg, Pennsylvania. Maintenance found that the pin had dropped out of the…Incident 20000608033109IBeech 1900D · Elmira, NY(-23)On Thursday, June 8, 2000, at 1550 local, a commutair (d/b/a usair express), flight 4688, a BE-1900D, N855CA, diverted to elm enroute from ith to bgm due to a cargo door enunciator illumiating in flight. Maintenance inspected and found the cargo door…Incident 20000608032949IDhav DHC8102 · Binghamton, NY(-23)On Thursday, June 8, 2000 at 0843 local, an allegheny airlines (d/b/a usair express) DHC-8, N804EX, reported smoke in the cockpit inbound from bgm. The aircraft landed and taxied to the ramp without incident. The flight originated in alb as a maintenance…Incident 20000608032139IEMB EMB120ER · Buffalo, NY(-23)Pn Thursday, June 8, 2000 at 1742 local, a Continental express Emb-120, N15725, flight 3111, returned to buf after takeoff due to a #2 engine oil pressure drop. Maintenance inspected and found the oil level low. Oil was added to the #2 engine. It was…Incident 20000608032099IAerosp ATR42320 · Rochester, NY(-23)On Thursday, June 8, 2000, at 1755 local, a Continental express ATR-42-320, N14821, flight 3621, flight 3631, returned to Rochester international airport, Rochester, NY with the number oe engine shut down for a torque fluctuation. Maintenance deferred…Incident 20000608030059IUnivar 415C · Galesburg, IL(-23)Aircraft departed macomb, IL and was climbing in the peoria, IL area. The engine failed and the pilot made an emergency landing in a field. There was no damage to the aircraft and very slight damage to the crops. The landowner contacted the highway…Incident 20000608020939ICessna R172K · Chapel Hill, NC(-23) The pilot made a hard landing and the nose wheel assembly came apart.Incident 20000608020729IN60TS · Troutdale, OR(-23) Weather factors: aircraft is equipped with floats. Landing was attempted on the columbia river in rough water as described by the pilot. Witness stated there was some swells and waking. Witnesses also stated that the aircraft bounced once and then…Incident 20000608018169IDoug DC3C · Erie, PA(-23)On June 8, 2000, at 0935, a DC-3, registered to miami valley avaition (vlla) as N932H, landed at Erie International Airport (eri) with the number 2 engine shut down due to the loss of engine oil pressure. Trouble shooting by maintenance revealed metal…Incident 20000608017839ICessna 150H · South Charlesto, WV(-23)Estimated 25 knots gust of wind hit aircraft after alnding during rollout. Aircraft left runway and ran into hanger.Accident 20000608013189ABoeing 737500 · Nashville, TNAccording to the FAA inspector, the passenger left his seat and approached a flight attendant at one of the aft entry doors and told her he needed some air. She directed him to reseat himself three separate occasions, the third of which he grabbed her hair…Accident 20000608011049ABell 206B · Bridgeport, WA(-23) Airman had just landed helicopter ina large depression (approx. 1 acre) that was being used as a field refueling site. The area was sporadically covered with two feet high alfalfa plants. The landing area had a mild slope (less than 5 degrees) slope…Accident 20000608010899AAmtr Lancairiv · Bountiful, UT(-23) On Thursday, June 8, 2000 robert e. froelich, holder of FAA pilot certificate #1350465 departed tooele valley, Utah airport (tvy) enroute to Bountiful Skypark airport, Utah (btf). After crossing over the top of the class b airspace Mr. Froelich…Accident 20000608010869ABeech 95B55 · Erie, PA(-23) The a/c departed the dunkirk county (NY) airport at about 10:00 pm for a VFR flight to Erie, PA. (Eri). The pilot said his fuel tank indicators read approx. 1/4 on the right tank and just above the "white dot" indication on the left fuel tank. About six…Accident 20000608010539ACessna 172M · Davis, NC(-23) Pilot was landing in a crosswind and lost directional control. Aircraft went into trees on the edge of the runway. (.4)on June 8, 2000, about 1130 eastern daylight time, a Cessna 172M, N4422Q, owned by a Private individual impacted with tress at a…Accident 20000608009869APiper PA28235 · Houston, TX(-23) Piper N9407W was clearing for takeoff on rwy 17, sgr. And made a left downwind departure to the north, the PIC reported to sgr twr that the engine lost power. The a/c was given priority to rwy 17. He was however unable to make the airport, and landed 2…Accident 20000608009169APiper PA28181 · Minneapolis, MN(-23) During climb, engine quit when a/c was at 200 ft AGL. A/c crashed into a swamp. A/c was destroyed, occupants received minor injuries. During post crash investigation, the engine crankshaft was found to be broken at the #3 rod bearing journal forward…Accident 20000608008889ACessna 150G · Oxford, MS(-23) Aircraft departed Oxford airport (uox), with a student pilot in left seat and CFI in the right seat, on a local training flight. Witnesses stated aircraft made a normal take-off and at approxiamtely 300 feet altitude AGL, as the aircraft was over the…Accident 20000608008779AEnstrm F28C · Kennewick, WA(-23) The pilot was hired to hover his heli over cherry trees to dry them off from a recent rain. In the process he stated that he experienced what appeared to be a loss of power. During subsequent investigation he later concluded that he had manuevered the…Accident 20000608007199AMooney M20D · Hector, CA(-23) Pilot made an emergency landing due to lack of fuel. Pilot stated he had fuel pump problems. Engine run test was performed for mechanical purposes. No mechanical discrepancies were found. Engine run test was satisfactory. (.4) on June 8, 2000, at 1025…Accident 20000607036879APiper PA25235 · Maddock, ND(-23) On June 7, 2000 at 11:15 local time a Piper PA-25-235 registered to sabbe brothers flying services crashed during a turn while performing aerial application. Visual meteorological conditions prevailed at the time and no flight plan was filed. The…Incident 20000607035079ISwrngn SA227AT · Birmingham, AL(-23)On landing roll-out the aircraft started to veer to the right. The pilot reported that he had no steering, and was unable to correct. The pilot managed to get the aircrft stopped just as the right propeller struck the runway sign. The propeller and…Incident 20000607026669IBoeing 767222 · Chicago, IL(-23)See attached sheetIncident 20000607021119IBeech 1900D · Pittsburgh, PA(-23) On approach to venango regional airport (fkl) franklin, PA, (an uncontrolled airport) the pilot selected gear down and the right main gear down lock indicator light did not illuminate. The pilot elected not toland at (fkl) and deviate to Pittsburgh…Incident 20000607019929ICessna 402C · Hyannis, MA(-23) Pilot engaged autopilot after take-off and experienced an abrupt pitch up input. Pilot stated that he tried to disengage autopilot but it would not disconnect and he experienced a severe control problem. Pilot declared an emergency and landed on runway…Accident 20000607014409AAmtr SA300 · Spicewood, TX(-23) On June 7, 2000, at 1530 CDT, a starduster ii sa 300 tailwheel equipped experimental airplane, N1011Z, was substantially damaged when it nosed over during landing roll at the Spicewood airport near Spicewood, Texas. The commercial pilot, sole occupant…Accident 20000607009489ABlanca 1731ATC · Del Rio, TX(-23) On June 7, 2000, at approximately 1451 hours, a Bellanca 1731ATC, N39827 owned and operated by[privacy data omitted]crashed 10 miles norhtwest of laughlin afb, Del Rio, TX. VFR flight conditions prevailed and the pilot filed a flight plan. The aircraft…Accident 20000607007819ACessna 172H · Foley, AL(-23) On June 7, 2000, about 19:20 hours central daylight time, N2849L, a Cessna-172H, was being operated by[privacy data omitted] while conducting takeoffs and landings from a private unimproved airfield approximately 1000' feet in length located at 9645…Incident 20000606035219IAmrgen AA1 · El Cajon, CA(-23)Pilot attempted to taxi his Grumman American trainer aircraft from parking area, lost control and taxied into another parked aircraft. (Mooney N226C) the propeller of the Grumman struck the right wing of the Mooney causing damage to the propeller of the…Incident 20000606033479ICessna 177RG · Orlando, FL(-23)On 06-06-2000, N5AW a Cessna 177RG landed gear up on runway 18R at Orlando International Airport. No mechanical factors found. Pilot forgot to extend the landing gear.Incident 20000606032629IPiper PA28150 · Tonopah, NV(-23)June 6, 2000, at 0955 PDT, the student pilot took off from Tonopah Airport (tph), in N5737W, a Piper PA-28-150, praticing flight maneuvers for his checkride. During his flight at approximately 1045-1100 PDT, the student decided to perform soft field…Accident 20000606010049ALuscom 8A · Greenville, TX(-23) On June 6, 2000, N45880 was attempting a landing at Greenville Majors Airport, when the pilot suddenly lost control of the aircraft. The aircraft came to rest on the west side of runway 35. The pilot stated that the landing was normal until the iarcraft…Accident 20000606009659AScwzer G164B · Welsh, LA(-23) Engine quit while enroute to reloan fertilizer. A/c landed in rice field and flipped. Power turbine section of engine would not turn.Accident 20000606006139ACessna 185B · Moab, UT(-23) On Tuesday, June 6, 2000 at approximately 0800 MDT Cessna 185 N185RL, piloted by scott e. chew, holder of FAA pilot certificate #523135832 aborted his takeoff from Mineral Canyon airstrip near Moab, Utah. The aircraft had earlier departed hidden…Accident 20000605042149APiper PA22150 · Gulkana, AK(-23) On departure from Gulkana runway 32, at an altitude of approximately 200 feet AGL, the engine quit. The pilot initiated emergency procedures and maneuvered to land ahead on the highway. Highway traffic forced a decision to land short of the highway in…Incident 20000605033639IDoug DC982 · Cedar Rapids, IA(-23)Pilot requested a missed approach. On second attempt aircraft departed runway surface at about 3,700 feet from approach end of runway nine at Cedar Rapids, IA airport, and continued off runway for about 2,215 feet before returning to runway surface.…Incident 20000605033039IBoeing 727247 · Omaha, NE(-23)Delta airlines flight 427 diverted into Omaha, NE, due to problems with the air conditioner packs resulting in cabin temperature overheat. Contract maintenance found the zone temperture control valve sticking open. The valve was cycled manually to close…Incident 20000605032699ICessna 172RG · Teterboro, NJ(-23)On 06/05/2000 at approximately 0010, at Teterboro Airport, [privacy data omitted] acting as pilot in command of Cessna N6257R landed with the nosewheel door jammed shut and prevented the nose gear to extend. Damage was minor and there were no injuries.…Incident 20000605032599IPiper PA34200 · Olive Branch, MS(-23)Pilot made normal approach to olv runway 36. Normal landing, felt mains touched but not nose gear. Nose gear unsafe indicator light came on. Throttles were advanced but props struck runway, engines were idled and shut down. Investigation revealed…Incident 20000605032459IDorner DO328100 · Binghamton, NY(-23)On June 5, 2000, N442JS, dornier 328, operated by psa (vnvaa), declared an emergency and LANDE3D at Binghamton airport (kbgm). The flight was enroute from Washington, DC, (kdca) to burlington, VT, (kbtv). The crew noted a cas message "emergency parking…Incident 20000605028039INamer SNJ5 · Utica, MI(23)After landing, during roll out, the right landing gear slowly retracted and the aircraft came to rest on the right wing tip. Reason for failure was spilt in hydraulic line to gear actuator from unknow causes. Damage was minor.Incident 20000605027099IPiper PA34200 · Baco Raton, FL(-23)A/c took off pbi to bct. Aircraft had prior damage due to a ground incident Boca aviation, a repair station and employer of pilot callander, performed mainteance, but did not follow acceptable procedures for approving the aircraft for service prior to…Incident 20000605021849ICessna TR182 · Fremont, NE(-23) Pilot stated he had been practicing instrument approaches with an instructor at 5,000', for two days prior to incident. During practice they did not slow down airplane, or put landing gear down. Pilot stated he went by himself to practice GPS…