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 20060225003539APiper PA28RT201T · Parker, CO(-23) On February 27, 2006 at approximately 0845 MDT, N2939V, a Piper arrow model PA-28RT experienced engine propeller overspeed problem. The commercial pilot performed a precautionary landing in an open field. The aircraft sustained substantial damage. The…Incident 20060225003439IPiper PA28RT201T · Aspen, CO(-23) On February 25, 2006 at approximately 1520 MDT, N3005N, a Piper arrow model PA-28RT-201 experienced a gear up landing at the Pitkin county airport (ase) Aspen, Colorado. The aircraft sustained minor damage. The private pilot was not injured upon landing…Incident 20060225003249IBlanca 14132 · Marana, AZ(-23) Aircraft was on a demo flight for a potential buyer. The buyer was in the passenger seat and the PIC was in the left seat. On final approach, the PIC had the passenger operate the flap handle and he claimed he operated the landing gear switch, held his…Accident 20060225003139AHughes 269C1 · Saugus, CA(-23) The helicopter was heading in a westerly direction in pico canyon wash when it struck three high voltage power wires that transverse the wash north to south. The helicopter landed on the right hand side of the helicopter approximately 200 feet west of…Accident 20060225002549ABoeing 757232 · Boston, MA(-23) Delta flight #2030, B757-232, N697DL, 02/25/06, 2000 EST, (Boston, MA to ft. myers, FL) was preparing for push-back when the delta ramp deicing crew spotted more ice on the leading edge of the left horizontal stabilizer. The person in the bucket of the…Accident 20060225001869ABeech 9555 · Sikeston, MO(-23) After landing runway 02, while on the way to the taxiway, the pilot attempted to raise the flaps for more positive control in gusty winds (approximately 20 mph). The pilot inadvertently raised the gear handle instead. The nose gear completely collapsed.…Accident 20060224030849ACessna 150G · Rockford, OH(-23) Pilot picked up a passenger at battle creek, mi (kbtl) at 1330 and was flying back to phillipsburg, OH (3I7) when the engine stopped abruptly. He attempted an emergency landing in a field. The aircraft impacted terrain near Rockford, OH. Aircraft…Incident 20060224009289ICessna 172N · Carbondale-Murp, IL(-23) [privacy data omitted] - the airman was conducting touch and go landings on runway 18R at kmdh. On the second landing, with a slight crosswind from the left, the airman flared with a higher than normal pitch up to prevent a hard landing. The airman…Incident 20060224008879IPiper PA28181 · Toledo, OH(-23) Pilot rented aircraft with GPS that he had no formal instruction in use, only reading of manual and practice at a couple non tower airports. Pilot intended to land at 0G6 airport, an uncontrolled airport with runway 7/25 but inputted into the GPS the…Accident 20060224003609ABbavia 7ECA · Forrest City, AR(-23) On February 24, 2006, at 10:30 CST, a citabria 7ECA, N9007L, while being "hand-propped" by the pilot, started at a high power setting, and the propeller struck the pilot's head, it then executed a tight right hand circle on the ramp and the left wingtip…Incident 20060224003309IPiper PA28R200 · Fort Polk, LA(-23) Aircraft was at 6000 ft, in cruise flight when the prop started having vibrational problems, then the engine quit, pilot was vectored to a small dirt strip, landed with no injuries or damage to aircraft.Incident 20060224003229ISmithk Pulsarseries · Cedar City, UT(-23) During the landing the pilot came in a little fast for runway 02 at the Cedar City airport. He stayed in ground effect for awhile. When the plane settled to the ground it came down fast and hit hard on the nose gear. A bolt on the nose gear broke and…Incident 20060224003099IBeech C23 · Cahokia, IL(-23) The pilot [privacy data omitted] was landing runway 12 with an 8 knots crosswind from the south when the aircraft touched down. The pilot [privacy data omitted] failed to remove the crosswind crab from the aircraft at touchdown and when the nose gear…Accident 20060223030449ACessna 150L · Hillsboro, OR(-23) Student pilot conducting slow flight and stall maneuvers at 3000 feet. Power reduced to idle and engine lost power. Student pilot stated the propeller had stopped rotating. Mayday call to ATC, pilot then commenced to trouble shoot the aircraft systems…Incident 20060223003319IBeech 95B55 · Tulsa, OK(-23) On aircraft landing gear collapsed. Both propellers impacted the runway and the aircraft slid down centerline approximately 750 feet before coming to rest with nose right of centerline.Accident 20060223003009ACessna 182D · Staunton, VA(-23) Pilot attempted a low fly over traffic on interstate 81, mile marker 231, Staunton, VA. The aircraft's right wing struck static cable between high tension wire towers. The right wing separated from the aircraft, aircraft impacted lt. north bound lane…Incident 20060223002079IHughes 269C · Billings, MT(-23) Instructor states that during an instrument instructional flight the engine suddenly became very rough, the instructor took control and entered an autorotation performing a partial power recovery to a touchdown. No sustained injuries and the aircraft…Accident 20060223001739ACessna 182E · Austin, CO(-23) The pilot departed telluride, CO on 2/23/06 at approximately 0900 MST with two other people on board. He flew to Austin, CO at approximately 1059 and while buzzing a farm house and buildings he hit power and utility lines. The aircraft hit the ground…Accident 20060223001719ACessna 172L · Long Island, NC(-23) On 02/23/2006 [privacy data omitted] was the pilot-in-command conducting a 14 CFR part 91 instructional flight with a student, [privacy data omitted] , in a Cessna 172L, N3803Q, registered to and operated by sba leasing LLC. The student pilot made the…Accident 20060222011889ACessna 172R · Mitchellville, MD(-23) On 02/22/2006 at approximately 0842 local time, N3536C, a Cessna CE-172 departed warrenton-fauquier airport (W66) on an IFR flight to Freeway Airport (W00), Mitchellville, MD. The aircraft was piloted by a non-instrument rated, private pilot [privacy…Accident 20060222007519AAmtr LC41550FG · Stafford, VA(-23) The aircraft, a Lancair columbia 400, departed winston-salem airport, NC (int) enroute to shannon airport, fredericksburg, VA (ezf) on February 22, 2006. The aircraft arrived in the area of shannon airport at approximately 2315 local time. Weather…Accident 20060222005009ARobsin R22BETA · Scottsdale, AZ(-23) On February 22, 2006 about 1135 mountain standard time, a skid-equipped Robinson R22 helicopter, N7512G, was destroyed during an uncontrolled descent and collision with desert terrain, about 8 miles north of Scottsdale, Arizona. The helicopter was being…Accident 20060222003289ARobsin R22MARINER · Anchorage, AK(-23) After touchdown the helicopter skidded on the ice and struck N247W a bell 47 causing substantial damage to both helicopters.Incident 20060222002579IBoeing 757222 · Omaha, NE(-23) N520UA, B-757-222, being operated as united airlines flight 696 enroute from den to oma advised ATC that they had a flight control problem. The crew had received an icas message for leading edge slat disagree. With the flap lever in #1 position they…Accident 20060222002219ACessna 182P · Goldendale, WA(-23) On February 22, 2006 commercial pilot [privacy data omitted] and passenger [privacy data omitted] both employees of wings of wenatchee, departed the wenatchee pangborn airport (eat) enroute to portland international airport (pdx). The flight was an…Accident 20060222002209AAmtr Pittsspecial · Fulton, MO(-23) The pilot departed elton hensley memorial airport, Fulton, Missouri, (ftt) enroute to sky-gofarms airport (73MU) located approximately 4 miles north of ftt. The purpose of the flight was to practice takeoffs and landings at the sky-go airport. As the…Accident 20060222001629ABeech 58P · Burlington, WA(-23) N469MD, a Beech be 58P, registered to h & w management services, inc., departed bellingham, Washington at about 1846 PST, while on an IFR flight plan enroute to ogden, Utah. The aircraft had been handed off to seattle center and was given instructions…Incident 20060221009169ICessna 402B · West Palm Beach, FL(-23) On February 23rd, 2006 the pilot [privacy data omitted] was operating Cessna 402B, registration number N400AR from stuart, FL (sua) to West Palm Beach, FL (pbi). Visual flight rules prevailed. Upon landing there was a failure of the trunion (p/n…Incident 20060221008899IBeech V35B · Cleveland, OH(-23) N1883W was landing on rwy 24-CGF, weather was VMC 170@8 KTS clear & 10 miles, it was a normal landing. During roll out the pilot experienced directional control problems due to a flat tire. The aircraft veered to the right of center line and went off…Incident 20060221004139IPiper PA44180 · Huntsville, AL(-23) Pilot stated that the approach for landing was normal and that they had three (3) green gear down lights indicated. Pilot then stated that on rollout after landing the nose gear collapsed causing damage to the nose area and both engines. Initial…Incident 20060221002919IUnivar 415C · Fayetteville, NC(-23) Aircraft had completed pre take-off procedures and began taxiing towards the runway when the pilot observed fire coming from under the cowling of the engine. The pilot aborted the take-off and shut down the engine.Incident 20060221002199IBeech T42A · Reidsville, NC(-23) During takeoff shortly after lift off pilot raised gear, the door opened in flight and pilot landed on remaining runway with the gear up.Incident 20060221001699ISwrngn SA226TC · Casper, WY(-23) Nose gear tiller steering failed on take-off roll.Incident 20060220011319IBoeing 737724 · Newark, NJ(-23) Cala flt. 1002, a B-737-824 N73275 was holding with brakes set on taxiway "s" facing north as directed by ewr ground control. Cala flt. 589, a B-737-724 N38727 was taxiing behind flt 1002 from west to east, on taxiway "k", as directed by ewr ground…Incident 20060220009939IUnivar 108 · Auburn, IN(-23) Student pilot mismanaged controls during gusty crosswind wind landing. Student applied excessive braking to aircraft during landing roll which caused aircraft to nose over and prop struck pavement.Accident 20060220004259ACessna 172N · Muncie, IN(-23) On February 20, 2006, at 1744 EDT, a Cessna 172N, N75593, registered to flying squirrels, inc., and operated by student pilot [privacy data omitted] departed from Johnson field in Muncie, Indiana, (mie) to perform local touch and go maneuvers. During…Accident 20060220003479ABeech V35 · San Antonio, TX(-23) After completing the instrument approach to Stinson airport, the pilot in command of N510LM failed to maintain adequate air speed, and stalled N510LM. The aircraft struck the ground and became airborne again, before hitting a grove of trees. There were…Incident 20060220003209ICessna 560CESSNA · Dallas, TX(-23) Blew main tire on landing, aircraft lost directional control, second main tire blew and aircraft realigned with runway and came to a stop. PIC reported probably FOD. Freezing drizzle ice accumulation on taxiway reported by PIC. Probably had ice on…Accident 20060220002739APiper PA28140 · Backus, MN(-23) Practice emergency landing, private pilot allowed aircraft to develop a high sink rate and a cross wind over some trees added to the sink rate. Instructor did not have time to recover after the private pilot told the instructor "you have the aircraft."Accident 20060220002259APiper PA28235 · NM(-23) On February 20, 2006, at 0720 MST, a Piper PA-28-235 owned by [privacy data omitted] and operated by the pilot [privacy data omitted] [privacy data omitted], experienced loss of power during cruise flight and performed an emergency landing west of rio…Incident 20060220001709ICessna T210M · Abilene, TX(-23) The pilot/owner recently acquired N761ME, a Cessna T210M. On the first flight after annual inspection he decided to fly the aircraft at/near avenger field (ksww) in sweetwater, Texas, due to all of the engine cylinders being replaced. The pilot departed…Incident 20060220001559ICessna P210N · Loa, UT(-23) While in cruise flight at 16,500 feet MSL pilot heard mufflered explosion followed by complete engine failure. Pilot was unable to restart engine and was directed by air traffic to an airport at Loa Utah. Pilot was unable to glide to the runway and…Accident 20060219006049APiper PA28161 · Schaumburg, IL(-23) CFI stated that both he and the student visually checked fuel tanks to verify fuel capacity. One tank was full, the other had .9 hour used. During the process of conducting a soft field takeoff, which appeared to be normal, student pointed out that the…Incident 20060219003559ICndair CL6002B19 · Salt Lake City, UT(-23) On February 19, 2006, skywest airlines flight #20A (SKW20A) departed the Salt Lake City International Airport enroute to grand junction, Colorado. After takeoff SKW20A was cleared to climb to flight level 210. During climb out the crew received a "l…Incident 20060219002159ICessna 182R · Dalmatia, PA(-23) The subject aircraft departed (kipt) in VMC conditions enroute to (kcxy) airport, when the pilot observed an oil pressure drop to the red line, 10 minutes after departure. The engine began to shake violently, with loud banging, and then quit. The pilot…Accident 20060219001399ABell 222B · Galveston, TX(-23) Helicopter N306CH a Bell 222-B departed houston hobby airport at 0100 local, VFR, enroute to an oil tanker moored in the sabine lightering area approximately 85 miles se of Galveston, Texas. Pilot received a weather briefing from flight service prior to…Accident 20060218006279ACessna 421C · Indianapolis, IN(-23) Departed salt lake city (U42) to lukin, cincinnati (luk) decided to land at ind for fuel. When selecting gear down no main gear down indication. The pilot cycled gear twice no help and the third time with emergency extension nitrogen bottle still no…Incident 20060218004169IAmrgen AG5B · Inverness, FL(-23) On February 18, 2006, at 1035 EST, an American general aircraft, N621FT, operating on a personal flight, encountered a left main landing gear brake failure, during taxiing, and struck a parked aircraft, N475PS, at Inverness, Florida. Visual…Accident 20060218002319ACessna 150L · Fruitland Park, FL(-23) Engine began to run very rough, the pilot shut down the engine and made an emergency landing. Over shot the intended landing site, the right wing was taken off by a utility pole, the airplane contacted the ground and came to rest upside down. A passerby…Accident 20060218002299ABbavia 7FC · Dover-Foxcroft, ME(-23) Pilot reported that after takeoff and on climb at approximately 1,000 to 1100 feet altitude, the engine quit. The pilot stated that several attempts to restart the engine was made with no success. Subsequently the left wing hit trees and the nose of the…