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 20060430011309IPiper PA32RT300T · Hamilton, NY(-23) On 4/30/06, at approximately 1530E, the pilot PIC [privacy data omitted] took off from runway 35; all instruments appeared to be working normally. At approximately 83 KIAS, as the plane was climbing thru 100 feet, the PIC and his wife who was sitting in…Incident 20060430010269IBoeing 717200 · Atlanta, GA(-23) Per logpage #782783 capt reported aircraft autopilot disconnected at 13000 feet during descent. Crew had no roll control. Both yokes held firmly. Afs override off and still no roll control. After 3-4 min controls released. Aircraft operated without…Accident 20060430009519APiper PA44180 · Phoenix, AZ(-23) Instructor simulated right engine failure inside final approach fix. Instructor believes he simulated engine failure via retarding throttle on right engine. During simulated single engine landing the student bounced the aircraft. Following bounce the…Accident 20060430008669AParten P68 · Kaluakoi, HI(-23) Due to the serious injuries sustained to the pilot, only a brief interview was conducted at the queens hospital, honolulu, Hawaii. The pilot stated that after a normal night takeoff that required a slight right turn to avoid raising terrain, the takeoff…Incident 20060430008269IMooney M20C · Smithfield, NC(-23) PIC stated on April 30, 2006 during a training flight he attempted a fuel tank change prior to landing at jnx. The fuel selector jammed in the "off" position. The flight instructor in the copilot seat took control while he unfastened his seat belt and…Accident 20060430007199ACndair CL6002D24 · Las Vegas, NV(-23) Four (4) baggage carts belonging to northwest airlines rolled down the ramp at night and struck a taxiing mesa airlines CRJ900. It is thought that the brake on the leading baggage cart failed for an unknown reason.Accident 20060430007179ACessna 172N · Billings, MT(-23) On April 30, 2006, at approximately 1600 mountain standard time, a Cessna 172N, N739AJ, registered to the pilot [privacy data omitted] collided with a sign post while taxiing to parking in Billings, Montana. The aircraft was substantially damaged and…Accident 20060430007149ARussel RV6 · Death Valley, CA(-23) The aircraft departed rwy 15 at furnace creek airport, Death Valley, CA., lost engine power, and crashed 1/4 mile from the airport at 1300 hrs, on 04/30/2006. The aircraft was destroyed. The pilot was fatally injured, one passenger had minor injuries…Accident 20060430006699ACessna 172S · Big Bear, CA(-23) During taxi, the right wing of the aircraft struck an airfield ramp light pole. The pole is located at the east end of the airfield. After waiting for a twin engine aircraft (n number unknown) to land, the pilot [privacy data omitted] taxied towards rwy…Accident 20060430006499AHelio H250 · Woodville, TX(-23) Pilot attempted landing after a thirty to forty minute local area flight, under VFR conditions, with one passenger, to their residential Private grass landing strip heading due north. Winds were calm. Pilot perceived aircraft was descending long; well…Incident 20060430006409ICessna T210M · Colorado Spring, CO(-23) The pilot [privacy data omitted] took off in his Cessna T-210 at approximately 1205L on April 30, 2006, from Colorado Springs airport, Colorado, for a local area pleasure flight with a friend. He flew in close proximity to the airport and accomplished…Incident 20060429013859IBeech 35C33 · Charleston, WV(-23) Aircraft was landed with the landing gear in the retracted position. The pilot stated that he had put the gear handle in the down position but failed to verify a gear down indication prior to landing. According to the pilot the landing gear warning horn…Incident 20060429010169IPiper PA28140 · Aiken, SC(-23) On April 29, 2006 at 1944 local, a Piper, PA-28-140, N140HH experienced an off airport emergency (precautionary) landing, at the savannah river site (nuclear facility), Aiken SC. The pilot reported to augusta approach (approximately 21 miles west) he…Accident 20060429008019ABeech C24R · Sacramento, CA(-23) Pilot was landing aircraft when he was distracted and failed to lower the landing gear.Incident 20060429007449IChris A1 · Las Vegas, NV(-23) The aircraft ran out of fuel, experienced an engine failure, and the pilot executed an emergency landing on a road. The emergency landing was hard and the aircraft stood on its nose. An A&P mechanic made a make-shift repair to the propeller. There was…Incident 20060429007419ICessna 140 · El Cajon, CA(-23) On April 29, 2006, N89424, a Cessna model 140 aircraft landed at Gillespie airfield, runway 27L. After clearing the active the pilot stated the aircraft was struck by a crosswind component causing loss of directional control. Attempting to regain…Accident 20060429006679ASchemp Discusb · Minden, NV(-23) The pilot reported that 1/2 hour into the flight when over the mountains east of Minden, NV (mev), he ran out of uplift conditions. The sail plane started to settle towards the terrain. He turned back towards the ridgeline hoping to encounter rising…Incident 20060429006089ILkheed SP2H · Missoula, MT(-23) During checkride shutdown of #1 engine, the pressure relief valve possibly failed, and burned out the feather pump motor. Aircraft declared in-flight emergency, and landed without further incident. (-23 amendment) no injuries no aircraft damage.…Incident 20060429005269IEMB EMB145LR · Springfield, MO(-23) On apri 29, 2006 a trans states airlines Emb-145LR, N811HK, d/b/a American connection flight 5546, enroute from austin, Texas (aus) to st. louis, Missouri (stl), diverted to Springfield, Missouri (sgf) due to smoke and flames in the cockpit. The…Incident 20060429005199ILuscom 8 · Hanford, CA(-23) The student after landing on the roll out hit the brakes too hard and the aircraft nosed over and hit the propeller. Minor damage to propeller, light damage to the engine mount. Instructor said it was just too late to do anything. Counseling was…Accident 20060428008629ACirrus SR20 · Willows, CA(-23) Student pilot was on a solo cross country flight and was making an approach to landing at the Willows airport. The student stated that the landing was hard and was followed by bouncing and porpoising. The student initiated a go around and proceeded to…Accident 20060428008349ACessna 170B · Fort Pierce, FL(-23) A/c inbound from marsh harbour, just about to touch down when gust of wind blew a/c to left into rwy sign, a/c rotated into grass, damage to both wings and wing spar, right main gear collapsed and propeller impacted rwy.Accident 20060428007109AScwzer G164B · Dewitt, AR(-23) On April 28, 2006 at 1300 central daylight savings time, a Grumman ag-cat 164-B, registered to [privacy data omitted] and operated by the pilot [privacy data omitted] collided with trees shortly after takeoff from runway 36 near de witt, Arkansas. The…Accident 20060428007039ACessna 182T · Madison, WI(-23) The pilot attempted to land on runway 21 at msn. The pilot thought that the wind was from 240 at 8 knots. The tower controller thought the wind was from 110 at 8 knots indicating a left quartering tail wind. The investigation established the wind was…Accident 20060428006539AHoward DGA15P · Cocoa, FL(-23) Pilot distracted during take-off checklist, failed to lock tailwheel for take-off. Tailwheel was not locked for crosswind landing.Accident 20060428006209ACessna 172S · Honolulu, HI(-23) On April 28, 2006, on touchdown aircraft N790SP, bounced into the air three times, as the aircraft settled back on the ground the aircraft landed and veered off of the runway. No injuries reported. N790SP sustained substantial damage.Accident 20060428005379AAirtrc AT502 · Monroeville, AL(-23) Aircraft experienced engine power loss after takeoff, pilot attempted emergency landing in freshly plowed opening in pinetree orchard. Aircraft went inverted upon contact with the ground and aircraft received substantial damage. No injuries reported.Incident 20060427015429ICessna 170B · Minneapolis, MN(-23) Airman reports to FSDO that he "muscled" the aircraft to the ground in a strong crosswind (greater than 15 knots) rather than going around and as a result scraped the wing, causing only superficial damage, maintenance agrees no structural damage…Incident 20060427009839ICessna 414A · Rapid City, SD(-23) On April 27, 2006, N902BA, a Cessna 414A, was taxiing for departure when its right wind tip strobe light struck the radome of a parked Beech 200. The aircraft was being marshalled from the left side.Incident 20060427009799IBeech C90A · Raleigh-Durham, NC(-23) At about 40 NM north of rdu airport, at 17,000 altitude, pilot noted smoke from behind the instrument panel. Panel pulled away and smoke developed to flames from the electrical connection to the pilot's windshield. Pilot requested descent. ATC unable.…Incident 20060427007389IAviat PITTSS2B · Redmond, OR(-23) Pilot discussed winds with the tower and was concerned as all four wind socks disagreed. The ASOS favored runway 4. Runway 4'S windsock did indicate a right crosswind. As the plane touched down and the pilot was moving her feet from the pedals up to the…Incident 20060427006769ICessna 210B · Houston, TX(-23) On a VFR flight from spring, Texas (kdwh) to grand prairie, Texas (kgpm) pilot reported that on approach to landing at kgpm, that the nose landing gear did not extend. Pilot and passenger verified that the main landing was down and locked. Pilot…Incident 20060427006359IPiper PA31350 · Fairbanks, AK(-23) [privacy data omitted] pilot could not lower landing gear normally. Lowered gear by emergency method. Got three down and locked indications. Declared emergency. Crash fire crew responded. Made uneventful landing.Incident 20060427006329IBeech H18 · Kotzebue, AK(-23) Aircraft experienced gear malfunction at red dog mine, diverted to otz, landed gear up, fire followed. Amendment to follow as data is gathered. [privacy data omitted]Accident 20060427006199AAmtr THORPT18 · Reno, NV(-23) The pilot-in-command, serving as an instructor to the aircraft owner, was in the right seat when the private pilot receiving instruction, flying from the left seat, was making his second landing at Stead airport. During the touchdown, the aircraft…Incident 20060427006069ICessna 177RG · Marathon, FL(-23) Aircraft N2043Q was 1 1/2 miles out on final approach to Marathon Airport (kmth), Florida. No green light indication was observed in cockpit after extending landing gear. Attempted to cycle gear several times and hand pump gear down without success.…Accident 20060427004749AAmtr MA5 · Kalispell, MT(-23) Aircraft landed normally on runway 20. Given taxi instructions to turn left on runway 12. Apparently, right brake locked up, and aircraft went up on its nose.Incident 20060427004739ILear 35A · Kansas City, MO(-23) On April 27, 2006 a bankair inc (bkaa) Learjet LR-35-A (N369BA) was enroute from centennial Colorado to cincinnati Ohio when number 1 engine oil pressure dropped to 25 PSI. Per bankair's procedures the engine was brought to idle and the crew declared an…Incident 20060426011169ILuscom 8E · South Woodstock, CT(-23) While landing on runway 19 with estimated winds of 10 to 15 knots, variable at 230 to 270 degrees the pilot in command lost directional control. The aircraft, due to mismanagement of the controls, gusty winds, and excessive use of brakes resulted in the…Incident 20060426010289IBeech B99 · Greensburg, IN(-23) The Beech B99 was being operated as a jump plane that had just completed its first flight of the day to 13,500 MSL. Pilot was distracted while entering the traffic pattern by a jumper that had landed off airport. He also reports being fatigued from…Incident 20060426008289IBbavia 7GCBC · Boulder City, NV(-23) At approximately 12:15 pm on April 26, 2006, the subject pilot (PIC) was acting as pilot in command and pilot flying when, during an attempted landing on runway 9R at Boulder City airport (61B), the aircraft left the runway. The owner of the aircraft, a…Incident 20060426007959IPiper PA34200T · Tampa, FL(-23) On Wednesday April 26, 2006 at 16:45 EST, a Piper PA-34-200, N80FN, registered to flite 3 LLC. Harrison TN., collided with the runway on landing at Tampa bay north airport X39, Tampa, Florida. Visual meteorological conditons prevailed at the time and no…Accident 20060426007049AAmtr RV7A · Northport, WA(-23) The pilot [privacy data omitted] of N20342 made a hard landing at his private airport near Northport, WA. According to the pilot the winds were excessively gusty and on touchdown, the nose gear collapsed. Instead of remaining on the asphalt runway, the…Incident 20060426006319ICessna 172S · Longmont, CO(-23) Student pilot [privacy data omitted] and instructor pilot [privacy data omitted] left jeffco airport (bjc) at approximately 10:35 l 04/26/2006 on an instructional flight. They were flying a Cessna C-172 owned by micair and landed at Longmont (2V2)…Incident 20060426005599ICessna 310 · Rogers, AR(-23) On April 26, 2006, at 2145 cdst, a Cessna 310, N5259A, received minor damage during landing when the right main landing gear failed during landing at Rogers Arkansas. The airplane was registered to Arkansas aerobatics company, and operated by the pilot…Accident 20060426005189AAmtr Kitfoxiii · Lewiston, ID(-23) The pilot [privacy data omitted] purchased this Kitfox iii last fall and was taking flight instruction from [privacy data omitted] to satisfy insurance requirements. Both pilots were interviews separately and gave collaborating accounts of the accident.…Accident 20060425026999ARobsin R22BETA(-23) The accident was initially reported to the chicago dupage FSDO by an anonymous caller after the date of occurrence. The south bend FSDO received this report on may 16, 2006. The pilot removed the wreckage and transported it back to his hangar in…Incident 20060425011619IBeech 58 · Norfolk, VA(-23) Landing gear collapsed while aircraft was on roll-out after landing. Post incident investigation found landing gear down side of dynamic brake relay failed. Pilot reported he retracted flaps while on the runway.Accident 20060425010089ABoeing 777223 · Dallas-Ft Worth, TX(-23) On April 25, 2006, approximately 1730 CDT, an American airlines' Boeing 777, N789A, flight 945 encountered moderate turbulence during descent into Dallas/fort Worth international airport (dfw). There was no damage to the aircraft. One flight attendant…Incident 20060425009379ICessna T210M · Weslaco, TX(-23) Pilot was operating N761FX, a Cessna T210 aircraft, on a local flight in the mcallen/Weslaco Texas area. Pilot in command was demonstrating a landing procedure to his passenger. They had completed three touch and go landings and on the fourth landing…