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 19990724009479AAmtr STARDUSTER2 · Winslow, AZ(Tty) acft took off inw rwy 4, started losing power and altitude, turned to avoid obstacles, hit a tree and impacted ground. (.19) on July 24, 1999, at 0915 hours mountain standard time an amateur-built experimental starduster ii, N102E, collided with a tree…Accident 19990724009459APiper PA22135 · Palatine, NYAcft crashed into a field under unknown circumstances, the pilot/sole occupant suffered fatal injuries, the acft has substantial damage. (-23)during a left turn course reversal the aircraft entered an accelerated stall which progressed into a tailspin. After…Accident 19990724009442AScappoose, ORUnregistered ultralight collided in mid air with N61887, an experimental gyrocopter, the pilot of the ultralight suffered fatal injuries and theultra light was destroyed, the 2 POB N61887 suffered fatal injuries and that acft was destroyed, other…Accident 19990724009441AAmtr Sportcopter · Scappoose, ORAcft collided in mid air with an unregistered ultralight, the 2 POB N61887 suffered fatal injuries and that acft was destroyed, the pilot of the ultralight also suffered fatal injuries and the ultralight was also destroyed, other circumstances are unknown.…Accident 19990723046259ACessna 182R · Fargo, ND(-23) The flight was conducted under 14 CFR part 91 for the purpose of obtaining night currency. The private pilot departed Fargo Hector International Airport and remained in the traffic pattern for runway 17. On the first landing the pilot stated that he…Incident 19990723039289IPiper PA46350P · Myrtle Beach, SCOn Friday, July 23, 1999, at 1041 local time Piper malibu N063SB collided with Piper archer N701GW. The evollision occurred on taxiwat b adjacent to a run up area for runaway 35 at Myrtle Beach international airport (myr). There were no injuries to the…Incident 19990723026529IDoug DC983 · Cleveland, OH(-23) Crew reported, on take off at rotation, a bird was injested into the right engine. Engine stalled several times, engine failure checklist completed.Incident 19990723024309IConaer LA4200 · Anchorage, AKOn July 23, 1999, at approximately 1600 hours N9571R, an LR-4-200, experienced gradual loss of power during the take off phase, pilot declared emergency and landed at departure airport (mrl). Investigation revealed that number four fuel nozzel was clogged,…Incident 19990723023269IMooney M20C · Glenwood Spring, CO(-23) Pilot stated he did not lower landing gear and landed gear up, causing minor damage to aircraft.Incident 19990723018259IPiper PA28161 · Norwood, MA(-5)PIC gilday landed the aircraft runway 28 (owd) turned off into taxiway engine failed, called tower, tried to start engine; after a few minutes engine caught fire.Incident 19990723018189ICASA C212200 · Bethel, AK(-5)On July 23, 1999, at approximately 1850 hrs, an arcitc transport service Casa 212-CC departed Bethel, AK.. On climb out, the co-pilot noted that the srl light flickered on and off. After resetting the srl computer circuit breaker, the light went out. He…Accident 19990723009849APiper PA28160 · Pueblo, COAcft experienced engine failure and made hard lndg rwy 17/35 at Pueblo, CO. Wing broken and flipped over on back. (-23) a/c departed runway, at about 300 ft altitude the engine quit, pilot elected to turn and try to land at airport. The a/c stalled and hit…Accident 19990723009739ACessna 210B · Newton, NJAcft took off and the windshield became covered in oil, the pilot returned to the arpt and attempted to land the acft, and the acft struck trees while attempting to land, the acft was destroyed, the 2 POB have serious injuries, other circumstances are…Accident 19990723009729ACessna 152 · Berriem Springs, MIEtractedshed into a field under unknown circumstances and sustained substantial damage. (.19)on July 23, 1999, at 1815 eastern daylight time, a Cessna 150, N95534, operated by Andrews University, was substantially damaged on impact with terrain following a…Accident 19990723009679ACessna T210F · Albuquerque, NMOn rollout the nose gear collapsed. A fuel line was severed and the aircraft caught fire. (.19)on July 23, 1999, at 1733 mountain daylight time, a Cessna T210F, N6726R, was destroyed by fire after the nose landing gear collapsed during landing roll at…Accident 19990723009669ACessna 150L · Udall, KSOn departure, no aileron control. Aircraft cartwheeled onto side of runway. (.19) on July 23, 1999, approximately 1730 central daylight time, a Cessna 150L, N6726G, piloted by a private pilot, sustained substantial damage when it impacted terrain, following a…Accident 19990723009659ABeech C23 · Tulsa, OKGear collapsed on touch down. (.4) during final landing approach the airplane touched down hard resulting in substantial damage. The pilot was demonstrating a power off landing. During the landing flare, he noticed that his 'aiming point' was 'moving in the…Accident 19990723009649ACessna 172G · Dover, DE(.4) The student pilot landed the airplane long and fast, and could not stop it before it went off the end of the runway and into some trees. The pilot was supposed to initiate a go-around once the airplane passed a prescribed mark on the runway, but did not…Accident 19990723009629ABoeing A75L3 · Fort Worth, TXForced landing at golf course, climb out reduced power attempted to make turn, lost power, landed on top of golf cart. (.19) on July 23, 1999, at 1115 central daylight time, a Boeing A75L3 airplane, N59646, was substantially damaged when it impacted a golf…Accident 19990723009549ABeech 77 · North Dawson, GAEngine failed furing descent. (-23) no narrativeAccident 19990723009539AAyres S2R · American Falls, IDAcft lost power, pilot landed in field, collided with fence. (-23) during aerial application the aircraft lost power. Pilot landed aircraft in a field, collided with a fence, causing substantial damage to aircraft. No injuries to pilot.Accident 19990723009529ABeech 23 · Vidalia, GAAcft took off from field, hit fence. (-23) airman exercised poor judgement attempting to fly an unairworthy aircraft. See attached.Accident 19990723009519AAirtrc AT301 · Drew, MSCrashed on takeoff. (.19) on July 23, 1999, about 1500 central daylight time, an air tractor 301, N2368R, registered to ward air service inc., was substantially damaged during takeoff at Ruleville-Drew Airport, Drew, Mississippi. The commercial-rated pilot…Accident 19990723009509ARobsin R22BETA · Spring Green, WIR-22 helicopter was pollinating a corn field when the rotor struck a power line, and the acft crashed, other circumstances are unknown. (.19)on July 23, 1999, at 1255 central daylight time, a Robinson R22 beta, N2313D, piloted by a commercial pilot, sustained…Accident 19990723009439APiper PA60601P · Oklahoma City, OKAcft was on a maintenance check flight when it crashed shortly after take-off near the south end of the rwy, the 2 POB suffered fatal injuries, the acft was destroyed by fire, other circumstances are unknown. (.19) on July 23, 1999, at 1113 central daylight…Accident 19990723009429ABeech G18S · Minneapolis, MNAviation charters air taxi crashed shortly after take-off and sustained substantial damage, the pilot/sole occupant was not injured, other circumstances are unknown. (.19) on July 23, 1999, at 0723 central daylight time, a Beech G18S, N621KE, operated by may…Accident 19990722047379ADoug DC3CS4C4G · Charlotte, NC(.4) Waiting on the ramp for taxi instructions, the copilot brought to the captain's attention that the gear lock handle was out of the down and locked position. The latch handle would not return to the mid-position. The captain then placed the gear handle in…Incident 19990722038539IBeech S35 · Rochester, INRough running engine. Precauionary landing. K.c. siery, mechanic at Rochester, Indiana, found nothing wrong after thoroughtly checking on the ground.Accident 19990722037169APiper PA25235 · Fabens, TX(.4) On July 22, 1999, approximately 0910 mountain daylight time, a Piper PA-25-235 agricultral airplane, N6736Z, was substantially damaged when it impacted a power line, power line pole, and a residential brick fence after encountering windshear during…Incident 19990722032619IFokker F28MK0100 · Middletown, PA(-23) The #1 hydraulic system low quantity light came on in cruise at FL29. A non-eventful landing was made at the destination airport, Middletown (MDT). Maintenance personnel at MDT determined the low hydraulic quantity was caused by a leaking o-ring in the…Incident 19990722029789IPiper PA34200 · Myerstown, PA(-23) 9/9/99 - A Mr. Dave hildebrand (717)886-2184 called to report an incident that occurred on 7/22/99, involving PA-34 N42866 having a propeller strike a taxiway light and continue flight. Upon return to deck airport later that day the prop was removed and…Incident 19990722029369ICessna 210E · Mena, AR(-23) On July 22, 1999, at 2100Z, a Cessna 210E, N4910U, registered to pegasus of batesville, inc and operated by Mr. Timmerman, declared an emergency to memphis center due to excessive elevator flutter/vibration during cruise enroute to fort worth (ftw). The…Incident 19990722026019IPiper PA28140 · Billings, MT(-23) The pilot stated he flared high and landed hard at Billings, Montana. When the aircraft came in contact with the runway, the nose wheel tire blew out and the prop hit the ground. The aircraft then porpoised and on the second landing, the nose wheel rim…Incident 19990722018989ICessna 172P · Kansas City, MO(-5)During taxi to the run-up area, the engine quit running. The pilot restarted the engine using hot start procedures. The engine ran rough after re-start, so the pilot elected to return to the parking ramp. On the way back to the ramp, the engine quit…Incident 19990722014989IDhav DHC8102 · Pittsburgh, PAThe pilot stated that on August 22, 1999, at 1320 local time, allegheny ailrines (pcaa) flight 3911 encountered unexpected turbulence. The flight was enroute from harrisburg, PA (MDT) to Pittsburgh., PA (pit) at 14,000 feet and approximately 12 miles east of…Accident 19990722009859ACessna 172E · Colorado Spring, COAircraft slid off runway into ditch during landing. Bent prop, nose gear, and wingtip. (-23) student pilot on third solo, had completed two successful touch and goes on runway 15 the wind switched and was favoring runway 33, pilot was landing with both main…Accident 19990722009839ACessna 185 · Kodiak, AKN171 reported N4949E out of power and landing in valley approx 5 west Kodiak, Alaska. (.19)on July 22, 1999, at 1225 Alaska daylight time, a float equipped Cessna 185 airplane, N4949E, sustained substantial damage during an off airport forced landing about…Accident 19990722009829ATmpson Naviona · Keokuk, IAAircraft landed in field 1/2 sm se runway 26 at Keokuk, Iowa. (-23) Mr. John evans landed the navion N4902K short of the runway at Keokuk, iowas, due to engine failure. Mr. Evans and his passenger ( Mrs. Evans ) sustained minor injuries. A written statement…Accident 19990722009809APiper PA32300 · Mcgrath, AKAcft crashed enroute, other circumstances unknown. Pilot reported mayday, 15SW mcg engine out. (.19)on July 22, 1999, about 1600 Alaska daylight time, a wheel equipped Piper PA-32-300 airplane, N4811T, sustained substantial damage during a forced landing…Accident 19990722009589ABell OH13H · Sparta, GATexas helicopter corp. OH-13H/M47A helicopter lifted off from a trailer and crashed while still tethered, other circumstances are unknown. (-23) take-off was attempted with helicopter secured to the left side of trailor.Accident 19990721046319AAirtrc AT502B · Marvel, AR(-23) Aircraft had load of damp fertilizer (approximately 3,800 pounds) when a takeoff was attempted with an outside air temperature of approximately 95 degrees f. the aircraft cleared a 12 inch rise at the end of a 2,500' long runway, however, the main…Accident 19990721042899AN5230W · Alvarado, TX(-23) On July 21, 1999, ay 1100 CST, a Piper PA-28-160, N5230W, owned by ronald w. connolly at[privacy data omitted] struck a barbed wire fence while on a approach into Luscombe airport. The accident occurred while Mr. Connolly was taking his private pilot…Accident 19990721042779ACessna 152 · Frisco, TX(-23) The pilot lost directional control during a practice soft field takeoff, with the nose wheel elevated, before becoming fully airborne. The a/c exited the runway to the left while remaining on the ground, and the nose landing gear became mired in a…Incident 19990721035369ICessna T210N · Eugene, OR(-23) Mr. Lamont found the aircraft battery was discharged. Mr. Lamont jump-started the aircraft, and took-off. While attempting to retract the landing gear, the electrical charging system failed and Mr. Lamont smelled smoke fumes in the cockpit. Mr. Lamont…Incident 19990721034329IEMB EMB120 · Palm Springs, CA(-23) The abovementioned aircraft returned to Palm Springs airport shortly after takeoff due to smoke emanating from the left engine, serial #AO-0019. Psp maintenance department troubleshot the engine to no avail. Aircraft was ferried to the swia engine shop…Incident 19990721033109ICessna 210 · Baco Raton, FL(-23) 07/21/99, This aircraft landed gear up and sustained substantial damage due to incident, insurance totaled aircraft out and prior to insurance total, aircraft was jacked and performed gear retraction with no defects. Pilot states that gear folded upon…Incident 19990721025159ICessna T210H · Montrose, CO(-23) Pilot was practicing touch and go landings at Montrose co. (mtj). When landing gear was lowered the main gear would not lock in the down position. He tried to lower the gear manually with no results. He contacted a mechanic by radio who directed him…Incident 19990721023819ICessna 210 · Three Forks, MT(-23) Helena FSDO incident no. INM05519990030, gear-up landing. Private pilot (cert. Issued 12/97) stated he was distracted by other air traffic and forgot to lower landing gear. 44709 letter issued. Pilot counseled to seek additional flight instruction.…Incident 19990721023239IBeech 95B55 · Harrisburg, PA(-23) On July 21, 1999, at 1110 EDT, a Beechcraft B-55 owned by baron colemill, inc. and piloted by fitzwilliam w. king jr., lost electrical power while receiving vectors at Capital City Airport, new cumberland, PA. Marginal VFR conditions prevailed for the…Incident 19990721022789IBeech A36TC · Olathe, KS(-23) Pilot reported gear motor circuit breaker popped when gear extension was attempted. After second attempt, pilot elected to crank gear down. Pilot stated he turned the crank until he had three green lights and the handle broke free. Normal landing was…