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 20060323013409IBoeing 737522 · Philadelphia, PA(-23) At 1727 eastern standard time, flight 563, returned to Philadelphia International Airport (phl) and landed on runway 27L after reporting smoke in the cabin. During this incident the crew reported smoke in the cabin after take-off. Both lav smoke…Incident 20060323011219ICessna R182 · Manassas, VA(-23) Pilot did the landing checklist and was stopped at the gear down portion and was distracted by the tower calling and saying he lost radar contact and another aircraft in the pattern and did not resume the checklist. The director of aviation safety and…Incident 20060323005699IMooney M20C · Elizabethtown, NC(-23) The pilot was conducting take offs and landings. During a simulated emergency landing approach, the pilot failed to extend the landing gear. As a result, the aircraft landed gear up.Accident 20060323004409ACessna 340A · Melbourne, FL(-23) The airplane was on final for landing at mlb on runway 9L when it crashed in a small parking area behind a building, about 1.5 miles west of the runway. The airplane was in a near vertical, nose-down descent when it impacted, based on witness reports. A…Accident 20060323004019ARobsin R22BETA · Kailua-Kona, HI(-23) After completing flight operations in the traffic pattern, the aircraft requested to operate on ramp area bravo, between ramp kilo and taxiway delta. After arrival at the area the aircraft was observed to roll on it's side with the blades striking the…Incident 20060323003459IPiper PA60600 · Dallas, TX(-23) Aircraft departed ADS, encountered engine problems. Requested return to ADS. The number 2 engine stopped running. Shut down and secured engine. On landing had three green. Touched down and on roll out nose gear collapsed. Left engine prop struck the…Incident 20060322013839IPiper PA24260 · Churchtown, PA(-23) During cruise flight aircraft developed a vibration. The engine began to lose power and subsequently failed. The pilot selected the nearest field to land the aircraft.Incident 20060322012849IEMB ERJ170100SU · Syracuse, NY(-23) On March 22, 2006, at 1618 EST, a republic airlines CRJ-170, N829MD, declared an emergency while on approach 12 miles south of syr, due to a lavatory fire. Fire and rescue trucks responded and prepared for a possible evacuation on the runway. On final,…Accident 20060322011999ALear 35LEAR · Philadelphia, PA(-23) On March 22, 2006 a bankair, inc (bkaa), Learjet LR-35, N58EM, was cleared to depart runway 27L at Philadelphia International Airport (phl) to charolette (clt). The normal, before taxi, runup and inline checks were completed. According to crew…Incident 20060322011639ICessna S550 · Richmond, VA(-23) Main wheels failed to rotate upon landing. Aircraft skidded to a stop on runway 2 at ric. Maintenance inspected the brake system and did not find any defects. The chdo office will be providing follow-up on the aircraft and the operator.Incident 20060322011189IEMB EMB135ER · Newark, NJ(-23) On 03/22/06, at approximately 1725, aircraft tookoff from ewr enroute to alb. While in-flight crew heard and felt a loud vibration followed by a buzzing sound. Crew contacted C2XA maintenance control to try and identify the problem. At this point,…Incident 20060322005789ICessna 172N · Crystal River, FL(-23) This was a VFR flight and the pilot stated he was landing and heard that there was another aircraft behind him and he hurried himself to exit the runway quickly at too high a rate of speed thus hitting a cement implanted runway light thus collapsing the…Incident 20060322005099IBeech C90 · Omaha, NE(-23) N28TM BE-90C operated by executive Beechcraft, inc. was scheduled to fly from Kansas city international airport to yankton, SD. While enroute at 14,000 feet the pilot noticed a torque fluctuation on the right engine gauge, suspecting a faulty gauge…Accident 20060322005049ADoug MD900 · Mesa, AZ(-23) During a photo flight northeast of the Mesa ffz, with the pilot and crew chief aboard, the main rotor pitch cases were damaged by contact with the perimeter bolts of the main rotor hub assembly. The flight included +6/-69 degree bank angles, +35/-35…Incident 20060322004329IAirbus A319112 · Boston, MA(-23) Us airways inc., flight #944, philadelphia pa to Boston ma was disembarking passengers at Boston's us airways gate B-6 when the jet bridge collapsed hitting the L-1 door of aircraft N721UW (A-319-112), injuring one us airways mechanic and one passenger…Accident 20060322003819ACessna 172G · Collins, MO(-23) Pilot and three pilot-rated passengers departed joe foss field (fsd), sioux falls, SD at 0904 CST on an IFR flight to springfield-branson regional airport (sgf), springfield, MO. At 1254 CST and approximately 33 NM nw of sgf, PIC reported a loss of…Accident 20060322003789AAmtr EXEC162F · Morgan, UT(-23) On March 22, 2006, at 1530 MST, a rotorway international amatuer built helicopter N520DK, s/n 6776, piloted by [privacy data omitted] with one passenger onboard crashed on top of a ridge line above Morgan ut. The flight departed the pilot's [privacy…Incident 20060322003709IBac AVRO146RJ85A · Omaha, NE(-23) N519XJ, avro-146-RJ85A, was being operated by mesaba airlines, as northwest flight 3635, between Omaha, NE. And minneapolis, MN. During take off from Omaha, the oil quantity dropped to zero on the number two engine. The crew shut down the number two…Incident 20060322003199IDhav DHC2* · Port Gamble Bay, WA(-23) Aircraft was climbing thru 2600' enroute from lake union seaplane base to victoria, bc, Canada when pilot noticed slight engine hesitation, the lost power and began emitting smoke from the engine. Pilot executed an emergency landing in Port Gamble Bay.…Accident 20060321008719ACessna 172RG · Bridgeport, TX(-23) On March 21, 2006, [privacy data omitted] was providing flight instruction to the pilot [privacy data omitted] the pilot [privacy data omitted] retracted the landing gear instead of the flaps during an attempted go-around from rwy 17 at Bridgeport…Incident 20060321007929ICndair CL6002B19 · Lincoln, NE(-23) ASH7274 was issued taxi instructions from gate 4 at the Lincoln airport to runway 36 via taxiway kilo with a back taxi on runway 36. ASH7274 began taxiing on the ramp area and prior to reaching taxiway kilo the aircraft taxied off the ramp. Note: the…Incident 20060321007369IDoug DC982 · Denver, CO(-23) American airlines flight 2065 struck runway with the tail of the aircraft while landing on 35L. The point of impact on the runway was 575 ft beyond the threshold.Accident 20060321007069APiper PA23250 · Emporia, KS(-23) Pilot encountered icing conditions while enroute to ict from mkc. Aircraft became incapable of climbing or maintaining altitude. Aircraft continued to descend until it struck a tree approximately 3 miles southeast of the Emporia Municipal Airport.…Accident 20060321007009AExtra EA300S · Greenfield, CA(-23) On March 21, 2006, the pilot of an Extra-300, N124X, was performing aerobatic maneuvers at metz field located at Greenfield CA. Witness stated that after about 15 to 20 minutes, the aircraft looked like it was trying to land. After crossing over the…Accident 20060321004979APiper PA18A150 · Dillingham, AK(-23) Told to inspector on phone by accident pilot's father [privacy data omitted]: pilot [privacy data omitted] and second airplane with father flying were enroute to hunting cabin. Father [privacy data omitted] went ahead to cabin and landed. Pilot [privacy…Accident 20060321004519AWthrly 201B · Hondo, TX(-23) The aircraft was doing calibration runs and during the left pull-up and turn, the emergency dump deployed the remaining water in the tank (approx 60-80 gals). The plane pitched up and rolled to the right. The plane crashed killing the pilot…Accident 20060321004379ABeech C23 · Mena, AR(-23) On March 21, 2006 approx 10 am, aircraft N2160W, a Beechcraft BE-23-C23 departed Mena Arkansas airport (M39) on 35 runway. The aircraft took off VFR flying north from Mena airport, an uncontrolled field for approx 8 miles to acorn, AR, and turned…Accident 20060320011719APiper PA23250 · Morristown, NJ(-23) On the first leg of operator's daily pne-mmu-buf cargo run, subject aircraft was cleared by mmu tower for the visual approach to runway 5. After selecting gear down pilot stated that he did not get a right main gear down and locked indication (green…Incident 20060320009319IAirbus A300F4605R · Minneapolis, MN(-23) There was a loss of control on landing causing the aircraft to slide off the north side of runway 10L at msp. The captain was given a line check as a result of this incident.Incident 20060320008959IPiper PA44180 · Dekalb, IL(-23) During flight instruction for CFI MEL, the aircraft attempted to land with the gear up at Dekalb airport, IL. The pilot heard a metallic sound of something dragging on the runway, executed a go-around and noticed the landing gear had not been extended.…Accident 20060320005559AGulstm 500B · Shreveport, LA(-23) Pilot was flying an ILS approach to runway 14 at Shreveport Regional (night, IMC) and descended below the glidepath in the final stages of the approach. Aircraft intially struck an approach light 600 feet from the approach end of the runway, then hit…Accident 20060320003929APiper PA34200T · Branson, MO(-23) A pilot and three passengers on board seneca N21RR departed runway 11 at m. graham clark-taney county airport (plk), point lookout, MO, on an IFR flight plan to lubbock, Texas. The flight was cleared to 4,000 feet by sgf ATCT and entered IMC conditions…Incident 20060320003449IBoeing 757222 · Coraopolis, PA(-23) At 0718E, united airlines flight 308, a B757, diverted and landed on runway 28L, after the left engine was shut down due to an oil pressurization problem. The aircraft was enroute from klax to kbwi and diverted into kpit with the #1 engine shutdown.Incident 20060319008279ICndair CL6002B19 · Asheville, NC(-23) On March 19, 2006 N8783E, a Bombardier CL-600-2B19, operated by pinnacle airlines inc., departed Asheville NC airport with a destination of covington, Kentucky. While climbing through 17,000 feet the captain smelled smoke. A few seconds later the…Accident 20060319006469ABbavia 7EC · Zellwood, FL(-23) Tail wheel steering springs became unattached to steering arm causing pilot to lose directional control of aircraft on landing roll-out.Incident 20060319005779IMooney M20K · Zephyrhills, FL(-23) On Sunday March 19, 2006 at 13:55 EST, a Mooney M-20, N498E, registered to house cycle world, inc. tampa, Florida, collided with the runway on landing at Zephyrhills airport (zph), Zephyrhills, Florida. Visual meteorological conditions prevailed at the…Accident 20060319004919ABeech F33A · Wickieup, AZ(-23) On March 19, 2006, at approximately 07:51 pm mountain standard time, a Beech-33-F33A, N41PT, serial number CE-1175 departed henderson executive airport, las vegas, Nevada with a destination to scottsdale AZ. On March 19, 2006, approximately at 8:40,…Accident 20060319004819AUrbana UFM10SAMBA · Lancaster, SC(-23) Pilot attempted to land on runway 03 and bounced twice, after the second bounce the pilot induced power to abort the landing. The aircraft pitched up to an approximately 75 degree angle of attack, stalled, and rolled to the left impacting terrain 150'…Incident 20060319004319IPiper PA23250 · Frederick, MD(-23) On approach, the landing gear failed to extend properly. Repeated attempts failed leaving the left main extended and the right main and nose gear retracted. The pilot made an emergency landing with minimal damage. Investigation revealed that a landing…Incident 20060319004299ICessna 750 · Wichita, KS(-23) On March 19, 2006, at 10:52 local time a netjets inc. operated aircraft N983QS enroute from dallas/fort worth TX (dfw) to telluride co (tex), flight crew diverted to Wichita, KS (ict) because of hydraulics system problems. It was reported that the nose…Incident 20060319004289IBeech D35 · Santa Rosa, CA(-23) Pilot statement indicated he had made several take off and landings before incident. Pilot placed a tool bag behind the pilot seat on the floor. The cloth handle on the tool bag wrapped around the emergency down crank handle behing the pilot seat. This…Incident 20060319003509INancng CJ6A · Everett, WA(-23) After performing a full stop landing the pilot started a left turn to taxi off the runway, during this turn the right main gear collapsed partially. Result was minor damage to the main gear door and down lock switch mechanism.Incident 20060318011689IBeech D55 · Teterboro, NJ(-23) Pilot requested to land at "teb" after departure, stating that the door opened inflight. Aircraft was cleared to land on rwy 6, on low approach, "teb" twr advised PIC that his gear was not down, and pilot went around and was cleared to land on rwy 1.…Incident 20060318009929IMooney M20F · Juneau, WI(-23) The aircraft landing gear collapsed at touchdown at Dodge County Airport (unu). The propeller struck the ground and the aircraft skidded to a stop on its belly. The aircraft suffered only minor damage to the belly skins, antenna and the propeller. The…Incident 20060318009269IAmrgen AA5 · Columbus, IN(-23) On March 18, 2006, a 1972 American gruman AA5, was being operated by a student pilot at the Columbus Indiana municipal airport (kbak). Purpose of the flight was to conduct take-off and landings, at a control towered airport, IN preparation for his…Accident 20060318006509ACirrus SR20 · Orlando, FL(-23) Loss of oil pressure on downwind leg. Engine quit. Overshot runway and ran off end on emergency landing.Incident 20060318005679IAerovd L39C · Lexington, NC(-23) [privacy data omitted] who was PIC of the L-39 made an approach to Lexington airport when the aircraft hit hard on the runway. The aircraft then became airborne and landed hard again. At this time, the brakes were applied and both main gear tires blew.…Incident 20060318005469IPiper PA18150 · Denver, CO(-23) Aircraft had recently undergone maintenance which included an stc'd brake system modification. The effect of this modification is improved braking capabilities for aircraft equipped with tundra tires. The pilot was performing touch and go's. the pilot…Accident 20060318004849APiper PA28180 · Easley, SC(-23) Pilot reported that after reaching an altitude of 3000' feet he leveled for cruise and retarded the throttle and turned off the fuel pump. At that time the engine ran rough and lost power. The fuel pump was turned on and the throttle was not responsive.…Incident 20060318004309IBell 206L3 · Intercoastal Ci, LA(-23) Pilot landed on VE-245 (petroleum platform in the gulf of Mexico) to pick up fuel. He parked his a/c facing north and on the east side of the landing platform (east side of the red line). After refueling and starting the a/c, he picked the a/c up into a…