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 19991030034099IPiper PA28161 · Port Ludlow, WA(-23) While enroute on a VFR flight from tacoma narrows, WA to Friday harbor, WA the engine lost power, near Port Ludlow, WA due to ignition harness problems. The pilot made an emergency landing southbound on cedergrove drive, Port Ludlow, jefferson co, WA…Incident 19991030033879IBoeing 7374B7 · Charlotte, NC(-23) Left main landing gear wheels locked after touchdown. Both left m/l/g tires blew, damaging left m/l/g doors, left wing inbd. Leading edge and trailing edge wing flaps and left m/l/g shock strut support structure and components. Imterior (passenger…Accident 19991030029649ACessna 210K · Ponca City, OK(.19) On October 30, 1999, at 1800 central daylight time, a Cessna 210K, N1162M, was substantially damaged during a forced landing in a field near Ponca City, Oklahoma. The airplane was registered to and operated by the private pilot. The pilot and his three…Accident 19991029047309ACessna 152 · Gainesville, FL(.4) The student pilot was conducting his first solo cross-country flight, and was en route to his first destination airport. While approaching the airport, he was unable to make contact with the tower and decided that he was lost. He attempted to return to…Accident 19991029044659ABeech A36TC · Pasco, WA(-23) A/c landed gear up causing substantial damage to airframe.Accident 19991029044329APiper PA22150 · Newberry, SCY-23) the pilot enroute from thompson, GA. To salisbury, NC, had an in-flight fire and made an emergency landing in a soybean field near the Newberry county airport, Newberry, SC. The aircraft, a PA-22-150, registration number N2648P, flipped upside down on…Accident 19991029041329ACessna 150F · Bay Springs, MS(.4)The pilot took off from runway 16 and lost partial engine power on initial climb. The pilot decided to return to the airport and stalled the airplane during the turn. The airplane subsequently collided with trees and then the ground off the departure end…Incident 19991029041249INancng CJ6A · Rockford, IL(-23) [privacy data omitted] a airline transport pilot, while flying N6351R a experimental nanchang CJ6A aircraft allowed the fuel to be exhausted. The aircraft landed in a corn field 3 miles from Rockford (rfd) airport. There were no passengers and no…Incident 19991029032649ILodi, CA(-5) Parachute jumer Mr. James fullerton, had logged 255 jumps using his own equipment PD-230 raven ii MPGON8-93, his las jump was from 13,000 feet at the Lodi airport, California. His main parachute was not deployed and the reserve had an auto open device…Incident 19991029031059IBbavia 11BC · Bettles, AK(-23) Pilot made a normal take off out of bottles to the north (runway 01) at about 75 degree altitude, 400' from the end of the runway. Pilot was about to reduce power when the engine quit. Pilot made a right bank turn, dumped the nose to land on the ramp.…Incident 19991029030399IPiper PA24 · Twentynine Palm, CA(-23) Aircraft began to sputter on climb out. Pilot managed to land aircraft on road. No damage or injuries occurred. Owner is going to completely remove and replace entire engine, and return to service. Old engine is going to be scrapped due to high time.Incident 19991029029889IPiper PA24180 · Norwich, NY(-23) Aircraft departed Eaton airport (oic) for a flight from Norwich, NY to cortland, NY (N03). On climb out, the aircraft headed south, then east over the town of Norwich, then west toward cortland. According to deputy jack porter, he saw and heard the…Incident 19991029029509IPiper PA28R200 · Rockwall, TX(-23) Instructor and student originated from mesquite flight training school and were shooting approaches and performing touch and go landings in mckinney (txi). They they proceeded back to mesquite (hqz) under IFR flight with hood installed and student in…Accident 19991028045899ACessna 152 · Cornelia, GA(-23) Student pilot,[privacy data omitted] , was on a solo cross country flight from greenville, SC (gyh) to Habersham County Airport (ajr). The student pilot, [privacy data omitted], was qualified to conduct the flight and was adequately briefed and endorsed…Accident 19991028042989ACessna 172N · Pineville, LA(-23) On October 28, 1999, a Cessna 172 was substantially damaged when the pilot ran off the runway at Pineville, Louisiana. The student pilot, Mr. James allen ross , was attempting to land on runway 35 at 6:20 p.m. CDT. Mr. Ross stated that the brakes were…Incident 19991028042319IBeech 36BEECH · Cleveland, OH(-23)N7512N cleared to corss runway 23L and into position and hold on runway 23R. Aircraft taxied to 23L and held instead. Controller instructed aircraft to taxi an additional 1000FT. And trun right onto 23R and hold. Aircraft took off on 23L (wrong runway)…Incident 19991028042029IAmtr Skybolt · Rhinelander, WI(-23) On October 28, 1999, at 3:15 p.m. cdst a Skybolt, N36JK, contacted trees on the approach to pine grove airport, Rhinelander, WI. The private pilot was able to continue a go around and make an uneventful landing. The aircraft received minor damage. The…Incident 19991028041159ICamron N133 · Fairborn, OH(-23) During landing approach the winds shifted, directing the ballon toward a light pole that it originally planned to clear laterally. Pilot attempted to left over the pole, but hooked a lamp on the climb. Broke the lamp off, minor damage to the ballon…Incident 19991028038209IMaule M4220C · Monroe, GA(-23) Aircraft was landing on runway 03. The aircraft touched down normally, the pilot loss control of the aircraft and it veered to the right and the left wing tip scraped on the runway, causing minor damage to the wingtip and attach point of the wing tip.…Incident 19991028037559IPiper PA28R200 · Wickanberg, AZ(-23) Pilot reported that he ws flying south of wickenburg, AZ when the engine started missing. He then headed toward wickenburg airport. The pilot then performed emergency procedures. The pilot state he noticed the fuel in the left tank was empty, but he…Accident 19991028033669AHiller UH12E · Castroville, CA(.19) On October 28, 1999, about 0915 hours pacific daylight time, a Hiller UH12E, N5374V, operated by r and b helicopter, inc., collided with a power line in Castroville, California. Thereafter, the helicopter impacted the ground and was substantially…Incident 19991028032449IBag JETSTM3101 · Indianapolis, IN(-23) After starting the right engine the captain signalled the ground personnel to pull the chokes and disconnect the ground power unit (gpu) before he started the left engine. When the chokes were pulled the aircraft rolled forward stricking the gpu with…Accident 19991028032129APiper PA32300 · Russian Mission, AK(.19) On October 28, 1999, about 1500 Alaska daylight time, a wheel equipped Piper PA-32-300 airplane, N31606, sustained substantial damage during landing at the Russian Mission Airport, Russian Mission, Alaska. The airplane was being operated as a visual…Accident 19991028032079ALoral GZ22 · Mogadore, OH(.19) On October 28, 1999, at 1841 eastern daylight time, the goodyear airship "spirit of akron", N4A, was substantially damaged during a collision with trees following an uncontrolled descent near Mogadore, Ohio. The certificated commercial pilot received…Accident 19991028030739ACessna 172G · Itta Bena, MS(.19) On October 29, 1999, about 1100 central daylight time, a Cessna 152, N1171F, registered to a private individual, impacted with the ground during a forced landing near Itta Bena, Mississippi. Visual meteorological conditions prevailed at the time, and no…Incident 19991028030049IBlanca 1730 · Ithaca, MI(-23) During take off pilot lost directional control and hit a landing light. Minor damage to aircraft. No injuries.Accident 19991028029679ABeech B60 · Angel Fire, NM(.19) On October 28, 1999, approximately 1505 mountain daylight time, a Beech B-60 duke, N243RC, was substantially damaged following departure from the runway during takeoff roll at Angel Fire Airport, Angel Fire, new Mexico. The private pilot, the sole…Incident 19991028029379IBeech B35 · Knoxville, TN(-23) On final approach to dkx, engine began to run rough, and lose power. Pilot elected to land in a field short of the runway.Accident 19991027047389ACessna 172B · Denver, CO(.4) The instructor was performing soft field touch and go landings with his student. During the third landing on runway 17R, a gust of wind blew the aircraft off to the left of the runway 2 to 3 feet. The airplane went into the grass and impacted a runway…Accident 19991027044549ASnias AS350BA · Westbury(-23)Aircraft departed republic airport (krfg) for east 34th. St. heliport (K6N5). While enroute to 34th st pilot experienced a severe vibration in the aircraft. Pilot slowed aircraft and made a precautionary landing to a field in old Westbury l.I. On short…Accident 19991027042949ACessna 172P · Waukon, IA(-23) Mr. Beneke was executing a cross wind landing and lost control of the a/c. the a/c hit three fence posts and came to rest in a roadside ditch.(.19) on October 27, 1999, at 1605 central daylight time, a Cessna 172, N52569, was substantially damaged when…Accident 19991027041879ACessna 207 · Bethel, AK(.4)The commercial certificated pilot arrived at his company offices and conducted a preflight inspection of the accident airplane at 0815 in preparation for a VFR scheduled domestic passenger flight to a remote village. The flight was delayed due to poor…Accident 19991027040449ACessna 172M · Mackay, ID(-23) Flight was from snadport, Idaho to hailey, Idaho. Pilot elected to make a precautionary land on provate grass strip because of concern for fuel to reach destination. Over shot runway and landed 200 feet off the end of runway. Aircraft substantially…Incident 19991027038669IPiper PA28161 · Chicago, ILOn October 27, 1999, aricraft (N81023) cleared for takeoff from runway 4L approximately 1045AM. The student pilot was at the controls, as the aircraft climbed through about 150AGL the engine suddenly lost power, the floght instructor took over the controls…Incident 19991027038369ICessna 172N · Denver, COMr. Shaw departed bjc after checking the local weather and flew to fort collins-loveland airprot to pratice instrument approaches. The wind at the fnl airprot was very strong and after several approaches he decided to return to bjc airprot. Upon arriving at…Accident 19991027037299ACessna 210L · Medina, OH(.19) On October 27, 1999, at 1839 eastern daylight time, a Cessna 210L, N76N, was destroyed during an attempted landing at Medina Municipal Airport (1G5), Medina, Ohio. The certificated commercial pilot and one passenger were fatally injured, and two…Incident 19991027034399ICessna 150F · Petersburg, IL(-23) IGL1920000004 while on descent into capital airport, springfield, Illinois, on his 1st cross country solo flight, the student pilot and sole occupant of N6933F, a Cessna 150, experienced roughness in engine operation and elected to land at a restricted…Incident 19991027033989IPiper PA28151 · Mckinney, TX(-23) Fuel depletion off airport landing - no visible damage to aircraft. No known bodily injury to sole occupant.Incident 19991027033449IPiper PA28RT201 · Van Nuys, CA(-23) Aircraft departed bur (IFR departure) and found that power could not be reduced. Throttle control was frozen in the full throttle position. Bur tower recommended landing at vny. Aircraft was landed at vny airport without further incident. The aircraft…Incident 19991027031649IBeech 58P · Dallas, TX(-23) Upon landing, nose gear failed to remain extended. Shortly thereafter on rollout, right main gear failed.Incident 19991027031389IBeech B19 · Moses Lake, WA(-23) Instructor was conducting touch and go practice with student. While climbing out after a touch and go, instructor initiated a simulated engine failure at approx. 100 feet AGL. The student applied landing flaps and lowered the aircraft nose to preserve…Incident 19991027031099IPiper PA22108 · Masontown, WV(-23) The pilot stated that while at a cruise altitude of 3000' MSL, enroute from fairmont municipal airport (4G7) to valley point airport (WV29), he encountered an in-flight fire that originated at the lower left portion of the firewall area. The pilot made…Accident 19991027031009ABbavia 8KCAB · Grand Junction, CO(.19) On October 27, 1999, approximately 1135 mountain daylight time, a Bellanca 8KCAB, N8707V, operated by kempton air service, was substantially damaged when it collided with terrain during landing roll at Walker field, Grand Junction, Colorado. The…Accident 19991027030909ACessna 190 · Somerville, NJ(.19) On October 27, 1999, about 1642 eastern daylight time, a Cessna 190, N195EL, was substantially damaged during landing at the Somerset Airport (smq), Somerville, new jersey. The certificated private pilot/owner and passenger received minor injuries.…Incident 19991027030409IPiper PA32301 · Kodiak, AK(-23) On return deadleg from akhiok to Kodiak, engine began to vibrate and make popping noises. Pilot was over ugak bay at 7000 ft in clear skies. Pilot heard a pronounced clunk and noticed oil access door flew open and left side of cowling buckled. Pilot…Accident 19991027029719AAirbus A300B4605R · Miami, FL(.19) On October 27, 1999, at approximately 0440 eastern daylight time, an Airbus A300-605, N70054, encountered clear air turbulence enroute to Miami, Florida. The commercial flight was operated by American airlines as flight 918 under the provisions of title…Accident 19991026047009AAmtr RANSS12 · Gainesville, VA(.4)The pilot stated he was too slow and the airplane stalled during a right turn. He was unable to recover before the airplane impacted trees. The pilot did not report any mechanical problems with the airplane. (-23)pilot was flying low over trees, lost…Incident 19991026033059IBbavia 7KCAB · Minneapolis, MN(-23) After a local flight, the pilot was taxiing back to the ramp after dark. Because of construction at the airport, he knew that he had to cross a dirt bridge across a trench to get to the ramp. He stopped to determine exactly where the bridge was. It was…Incident 19991026030309IBeech N35 · Albuquerque, NM(-23) According to eye witness and the damage to aircraft indicates gear was not down prior to landing.Incident 19991026030199ISwrngn SA227AC · Billings, MT(-23) On 10/26/99 at 0912 a big sky airlines, inc. fairchild SA-227-AC, n#704C, experienced a failure of the aircraft to properly pressurize. Flight #2550 returned to Billings without further incident. Subsequent troubleshotting by maintenance revealed a tear…