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 20010826020529ASchler ASK21 · Eagleville, TN(-23) During solo flight, loss thermal lift and forced to land in soy bean field, short of airport. Glider received substantial damage on landing.Accident 20010825039229ASocata TB20TRINIDAD · Amherst, NH(-23) N470SP departed boire field in nashua, NH (ash) approximately at 0723 local on 8/25/2001. Runway 32 was used for the departure with no abnormalities reported by the tower controller on duty. At approximately 600 feet AGL the aircraft was observed by the…Accident 20010825039209ACessna 402B · Bahamas(-23) On August 25, 2001, about 1845 eastern daylight time, a Cessna 402B, N8097W, registered to skystream inc. and operated by blackhawk international airways inc, as a 14 CFR part 135 air taxi flight, crashed shortly after takeoff from runway 27 at Marsh…Accident 20010825034489AN2099A · Augusta, ME(-23) Student pilot - unsupervised solo. Misjudged flare during landing, bounced aircraft. Nosewheel collapsed.Accident 20010825034039ABoeing 7373G7 · Kansas City, MO(-23) On August 25, 2001 at 0612 UTC (0112 am CDT) a Boeing 737-300 (N306AW), operated by america west airlines (awxa), as flight 598 exited off runway 27 while landing at the Kansas City International Airport (kmci), Kansas City, MO. The crew was at the end…Accident 20010825029249ABeech 95C55 · Jacksonville, FL(-23) During the 7th touch and go the left MLG failed to extend. FAA inspection found the left main landing gear extension rod bent. The FAA inspectors opinion is that the position of the gear switch was changed during gear transition causing damage to the…Incident 20010825028729IBell 214* · Eldorado, CA(-23) Shortly after takeoff the bucket and cable started to swing from right to left and for some reason the bucket and cable got over the top and wrapped around the tail boom. The tail boom had very minor damage and no injuries to the flight crew.Accident 20010825028489AN34DQ · Auburn, WA(-23) On 08/25/01, david hiatt (253-333-8143) departed Auburn airport. While over lake tapps, the engine quit. He made an emergency landing on lake tapps parkway e. highway. Aircraft had substantial damage. No injuries to pilot. On 09/27/01 Mr. Hiatt came to…Incident 20010825028099IPiper PA28151 · Tangier, VA(-23) Pilot lost control of the aircraft during crosswind landing.Incident 20010825027949ICessna 182S · Waynesboro, VA(-23) Pilot stated that he made a steeper approach than normal, due to obstructions. He further stated that his rate of descent was greater than usual, and after the aircraft touched down on the main gear, the nose wheel impacted the runway with enough force…Incident 20010825027279ICessna 172RG · Van Nuys, CA(-23) Pilot reported unsafe gear. He tried several cycles, then tried to hand pump it down - all failed to secure a down and locked position. Elected to land gear up at Van Nuys.Incident 20010825025249ICessna 172N · Ogden, UT(-23) Enroute at 11,500' MSL, exhausted fuel supply and forced landed off airport on paved two lane road.Incident 20010825024299IEMB EMB145ER · Kansas City, MO(-23) An express jet (dba Continental express) Embraer EM-145, flight #4269, enroute from cle to mci, according to the situation report-preliminary incident report, contacted ATC and requested emergency equipment to be on standby due to a #1 hydraulic system…Accident 20010825023599AAmtr Pietenpolair · Healdton, OK(.19) On August 25, 2001, approximately 0745 central daylight time, a john greenlee x-aircamper homebuilt experimental airplane, N899JG, registered to and operated by the pilot, was substantially damaged during a forced landing after a loss of engine power…Accident 20010825022699ABbavia 7FC · Reno, NV(.19) On August 25, 2001, at 1028 hours pacific daylight time, a champion 7FC, N9857B, was substantially damaged during a landing ground loop at the Reno/Stead Airport, Reno, Nevada. The commercial certificated pilot and one passenger were not injured. The…Incident 20010825022519ICessna 421B · Houma, LA(-23)On Saturday August 25, 2001, pilot departed Houma/Terrebonne airport at approximately 3:30 pm for a test flight around the Houma area. Approximately five minutes into the flight the pilot noticed the gear up light was blinking. Pilot put the gear handle…Accident 20010824038159ABell 206L3 · Cameron, LA(-23) Pilot reported that the helicopter started to vibrate and shudder. He lowered the collective to slow the helicopter down and the engine quit. He entered an autorotation and deployed the floats. When he tried to decelerate the helicopter for an…Incident 20010824030159IBoeing 737 · Cleveland, OH(-23) [privacy data omitted]Accident 20010824028629ANamer SNJ5 · Raton, NM(.19) On August 24, 2001, approximately 1930 MDT, a north American SNJ-5, N2686D, registered to and operated by snj aviation adventures LLC, was destroyed when it impacted terrain while maneuvering 1/2 mile north of Raton municipal airport, Raton, new Mexico.…Accident 20010824028449ALear 25 · Ithaca, NY(-23) On Friday, August 24, 2001 at 0542 local time, a Learjet LR-25-25 aircraft, operated by ameristar jet charter, inc. took off from runway 32 at Tompkins County Airport (ith), Ithaca, new york. Royce a. read, certificate number 441542305 piloted the…Accident 20010824026299AN18260 · Chillicothe, OH(-23) Aircraft attempted to land at piqua, Ohio (I17) at approximately 0640 EDT. Dense ground fog existed at the time according to eyewitness reports. Aircraft had departed xenia (I19), VFR and received advisories from dayton approach until in the vicinity of…Accident 20010824025769ARyan ST3KR · Camarillo, CA(.19) On August 24, 2001, at 1820 hours pacific daylight time, a Ryan ST3KR, N48742, was substantially damaged during an off-airport emergency landing near Camarillo, California, following loss of engine power in cruise flight. The airline transport…Incident 20010824025369IBeech B36TC · Santa Ana, CA(-23) Pilot forgot to put the gear down. Pilot does not remember hearing gear horn activate. Pilot was instructed by ATC to go-around two times just prior to impact but did not comply with those instructions.Incident 20010824025279ICndair CL6002B19 · Pittsburgh, PA(-23) On 08/24/01, N830AS, a CL-600-2B19 aborted take-off from Pittsburgh international airport after receiving master caution warning and chimes (brake over heat and aural message). The aircraft taxied back to the ramp with out further incident. Maintenance…Incident 20010824024979ICessna R172E · Albuquerque, NM(-23) On August 24, 2001, at 1615 MST, a Cessna 172, N7873N registered to kirtland aero club lost power after takeoff from runway 8 at Albuquerque International Airport. Pilot reported fuel odor after making right turn at approximiately 800 feet AGL. Engine…Accident 20010824024629APiper PA28235 · Joplin, MO(-23) This aircraft struck the ground at over 200 mph, upright and slightly nose low. Evidence indicates that the engine was running and the propeller was spinning. A witness saw the airplane with very bright landing lights but turned the corner and did not…Accident 20010824023949ACessna 150J · Hyannis, MA(-23) Pilot and passenger departed Hyannis intending to complete T/0'S and landings at Hyannis airport. Engine failed at approximately 300 feet AGL on initial climbout. Pilot stated that the engine failed without warning. Pilot turned toward the airport but…Accident 20010824023559APiper PA28161 · Ardmore, OK(.19) On August 24, 2001, at 1727 central daylight time, a Piper PA-28 single-engine airplane, N81833, was substantially damaged when it impacted a drainage pipe during takeoff roll at the Ardmore Downtown Executive Airport, Ardmore, Oklahoma. The airplane…Incident 20010824022599ICessna 172P · Schroon Lake, NY(-23) No fss briefing obtained prior to flight. Pilot overshot runway while making second landing attempt on closed runway.Incident 20010824021869IBoeing A75 · Suches, GA(-23) Aircraft was departing the High valley airport to return to gwinnett county. There was a thunderstorm on the other side of the ridge adjacent to the airport of departure. After a normal takeoff roll, the aircraft was lifted off at approximately 55 mph.…Incident 20010824021849IPiper PA28181 · Prescott, AZ(-23) The pilot was landing at night. He was using runway 21R. This runway is narrower than the other one. After landing, the airman advised ATC that he was unfamiliar, and was instructed by ATC to, "taxi to the end and turn left." According to airman, it was…Incident 20010824021039IBeech 1900D · Pittsburgh, PA(-23) On August 24, 2001, at 1028 EST., air midwest flight #5537 landed on runway 28L after reporting an unsafe gear problem. During approach the landing gear indication system circuit breaker popped and would not reset. The ARFF responded and the aircraft…Incident 20010823027929IAmtr GRADNTONYX28 · Liberty Island, NJ(-23) French citizen operating a paramotor (motorized parasail) attempted to land on the torch of the statue of Liberty national monument. Parasail became entangled on the torch during the attempted landing. Pilot not certificated in the us, but stated he…Incident 20010823027779ICessna 172RG · Deland, FL(-23) Mr. Tobin s. williamson, pilot-in-command of N9520B (a Cessna 172RG), was giving flight instruction to Mr. Bradley k. sullivan a commercial pilot working on his flight instructor rating. They were practicing touch-and-go landings at Deland municipal…Accident 20010823026109APiper PA46310P · San Antonio, TX(.19) On August 23, 2001, at 1641 central daylight time a Piper PA-46-310P, N4362A, was substantially damaged when it impacted terrain during the initial takeoff climb from the Kestrel Airpark Airport, bulverde, Texas. The airplane was registered to klinck…Accident 20010823025919APiper PA18150 · Vanhorn, TX(-23) On August 23, 2001, at approximately 1730 central daylight time, a Piper PA-18 airplane, N91178, registered to and operated by the us border patrol of marfa, Texas, was destroyed when it impacted terrain in the vicinity of van horn, Texas in culberso…Accident 20010823025499AChris A1 · Nucla, CO(-23) Aircraft crashed, burned, and destroyed while attempting landing. Pilot and passenger died. Aircraft was in a steep right turn when the right wing tip struck the ground. The aircraft cartwheeled, propeller and spinner hitting ground next, followed by…Accident 20010823024579ACessna 172 · Cabot, AR(-23) On August 23, 2001, at 1030 central daylight time, a Cessna 172 airplane, N9154B, was substantially damaged during the engine start procedure when it started unexpectedly, began moving uncontrolled, and then impacted terrain. The airplane was registered…Accident 20010823023939ACessna 182R · Elizabethtown, KY(-23) On August 23, 2001, at approximately 1530 EDT, a Cessna 182R, N5419E, sustained substantial damage during landing rollout on runway 5 at the Elizabethtown airport (ekx), Elizabethtown, KY. The airplane was operated under day VFR, 14 CFR 91, by an…Accident 20010823023829ANavion L17B · Newaygo, MI(-23) On 08/23/2001 at 1745 local time the pilot of Navion N1017B reported loss of engine power while enroute back to the aircrafts home base. The pilot reported that the engine restarted at least twice after the initial power loss but ran only momentarily…Incident 20010823023681IPiper PA28151 · Norwood, MA(-23) N4299L was running up short of runway 28 on taxiway "b" at owd and was number one for takeoff. N4299L was being flown by a flight instructor and student pilot. N41983 was behind N4199L on taxiway "b" and number 2 for takeoff. N41983 called for takeoff…Incident 20010823023209IBeech V35B · Jackson, MS(-23) Pilot received clearance to taxi onto runway 16L @ jan taxied straight forward into sun making it hard to see that the taxi way turned right onto runway, pilot went straight, ran off taxiway onto wet ground. Right main landing gear sunk into soft ground…Accident 20010822037949ACessna 152 · Weatherford, TX(-23) On August 22, 2001, at approximately 0910 CDT, a Cessna 150 aircraft, N4755B, registered to ashish v. coswami and operated by aer mistral, inc., meacham field (ftw), fort worth TX, collided with a semi-tractor/trailer after an attempted landing at…Accident 20010822036389APiper PA22150 · Sparrevohn, AK(-23) On August 22, 2001, at or about 1000 adt, a tundra tire equipped Piper PA-22 airplane N6949B, sustained substantial damage maneuvering after landing about 38 miles southwest of Sparrevohn, Alaska. The airplane was being operated as a visual flight rules…Accident 20010822036349AAmtr Avidflyer · Birchwood, AK(-23) Pilot took off from Birchwood Airport. On climbout the spark plug in one of the two cylinders broke and spark plug wire fell off. Engine would not make power on only 1 cylinder. Pilot landed in an open area near railroad track. On roll out aircraft l.h.…Incident 20010822033209IGulstm 560 · Jacksonville, TX(-23) The crew stated they just leveled off at FL390, when they began to power back the master warning 10,000 ft light came on, so they requested lower. ARTCC issued FL280, at FL380 the crew reported pressurization problems and that they needed to level off.…Accident 20010822026409APiper PA18150 · Enderlin, ND(-23) The aircraft, N4329Z was observed flying over a field where a witness was harvesting wheat. The aircraft reportedly pulled up, did a stall followed by three of four rotations of a spin and then impacted the ground. The pilot suffered fatal injuries and…Accident 20010822026239ACessna A188B · Bancroft, WI(-23) On August 22, 2001, at 9:3O cdst a Cessna 188, N91138, made a forced landing in a corn field approximately 1/2 mile east of 2nd ave. Bancroft, WI. The aircraft received substantial damage. The commercial rated pilot reported no injuries. This was a…Incident 20010822025719IMooney M20C · Liberty, MO(-23) On August 22, 2001, Mr. Larry d. wright operated Mooney-20-C, N9282M, on a flight from lee's summit municipal airport, lee's summit, Missouri, to Roosterville Airport, Liberty, Missouri, to meet his flight instructor for instrument training. At…Accident 20010822024469ACessna 150M · Murrieta/Temecu, CA(-23) The pilot reported that the training flight departed French Valley Airport, (F70) Murrieta hot springs, California, at about 12:00 pm. During climb out from runway 18, the student turned west bound and continued to climb to an altitude of 2200 feet. The…