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 20091111023139ACamron A250 · Napa, CACommercial sight seeing flight. Erratic wind changes throughout the flight. They were not forcasted when pilot received weather briefing. Attempted three approaches and missed them due to wind shifts being too erratic. Finally lined up with a field which was…Incident 20091111020349IMooney M20C · Edgewood, NMMr. Brewer stated that after he departed santa rosa (sxu), the cabin door became unlatched and he decided to land at Edgewood, NM (1N1) to close and properly latch the door. Because of the wind noise he didn't hear the gear warning horn and failed to extend…Accident 20091110053659ABeech 35-B33 · Chico, CAPilot stated that while on final approach at the airport of destination, the engine stopped producing power. She immediately switched gas tanks but the engine did not restart. She landed approximately 200 yards short of the runway. The pilot stated that the…Incident 20091110025699ICessna 172G · Vienna, OHAbove airman, who is a student pilot, was flying underneath the yng trsa airspace flying eastbound when he nicked the 5NM northern boundary of the yng class d airspace.Incident 20091110022539IAirbus A319 · Dallas, TXShortly after takeoff, dal ATCT called Airbus P4MIS to inform them that the overwing slide exited the aircraft. The aircraft returned to dal without incident.Accident 20091110021359AAmtr Mullicoupe · Siloam Springs, AROn November 10, 2009, at 13:30 CST a younkin Mullicoupe experimental, N273X, register to jr younkin took off from Siloam spring airport (kslg) in Siloam spring Arkansas. Visual meteorlogical conditions prevailed at the time of the accident, and a VFR flight…Incident 20091109051509IBell 407 · Brighton, COBell 407, N912GX, S/N53785 operated by a commercial pilot. During cruise flight crew heard a noise coming from the rear of the aircraft and decided to land. Upon approach, the chip light came on about 20-30 ft AGL and at 10 ft AGL. Engine quit. Pilot landed…Accident 20091109051139ABeech B200 · Greer, SCOn 11/09/2009, aircraft N337MT, s/n BB-1628, a king air 200 had already been inducted into maintenance at gsp, in Greer SC. The pilot and two passengers went on a local flight. The aircraft was inbound for a second approach when both engines flamed out just…Accident 20091109050989ACessna 150L · Thomasville, PAPilot walked into rotating propeller arc and received serious injury to left arm, after using ground vehicle battery to assist with aircraft engine start.Incident 20091109022649IBeech 76 · Houston, TXThis was an instructional flight. The student was practicing single engine landings at David Wayne Hooks airport (dwh) in preparation for a practical test. Due to high volume of traffic landing at dwh, the student pilot extended his downwind leg and delayed…Incident 20091109020289ICessna 152 · Denton, TXAirman zhang, a student at us flight academy, was attempting to land on runway 35 at dto airport on November 9, 2009, in N5403H, a Cessna 152. She stated that the tower cleared her to land, however she was too close to the aircraft on final, so she elected to…Accident 20091108054119AAero Comman 100 · Fort Lauderdale, FLOn November 8, 2009, approximately 1840 eastern standard time, N4139X, an Aero commander 100, registered to a private pilot, crashed into the everglades north of interstate 75 (I-75), near weston, Florida. Visual meteorological conditions prevailed in the…Accident 20091108053809ACessna A188B · Ripley, MSThe pilot reported the aircraft lost power as he was attempting to land on runway 3 at the Ripley, MS (25M) airport. The aircraft crashed approximately 250 feet from the end of the ruway in a pasture. Aircraft damage was substantial. The aircraft didn't…Accident 20091108053789ABeech A36 · Spring Branch, TXThe action listed in # 32 is intended for the instructor. During cruise flightat 9000 feet MST, N91TD deviated from its course and entered a steep circling descent terminating with an inflight failure of the airframe and subsequent impact with the ground. The…Incident 20091108052829ICessna 150J · Topeka, KSAt approximately 1730 local time a Cessna CE-150J, N61176 was inbound to Forbes Field, KS (foe) when the aircraft encountered a loss of power and made an emergency landing off-field on us highway 24 about 8-10 miles northwest of foe. There were no injuries or…Incident 20091108052569IEurocopter EC 135 T2+ · Greensboro, NCDuring cruise flight at 2500 feet AGL, aircraft struck large bird approximately 18 inches below the top of the vertical fin. Aircraft sustained minor damage, but after feeling vibrations, the pilot landed at the nearest available field. Aircraft was trucked…Incident 20091108052509ICessna 172S · Cleveland, OHInstructor and student pilot on VFR cross country departed burke lakefront heading to ksky (sandusky airport). While looking up a frequency to contact Cleveland they flew more toward the west than planned and entered the class b airspace without a clearance.…Accident 20091108051979ACessna 150L · Galion, OHPilot lost control of aircraft during rollout and hit runway lights.Incident 20091108051169ICessna 421B · Mccook, NEN69771, CE421B, was enroute from grinnell, IA, to Colorado springs, CO. The aircraft diverted to Mccook, NE because of a rough running left engine. Maintenance found that the right bendix 1200 series magneto on the left engine had a defective distributor…Incident 20091108051119IGrumman Ame AA-5B · Boone, NCPilot attempted takeoff. Pilot aborted takeoff and was unable to stop. Aircraft ran off the end of the runway into a creek at the north end. The wings sustained leading edge damage. There was no apparent damage to the engine, the propeller or other area's of…Incident 20091108050969ISaab Aircra 340B · Dulles, VAColgan flight crew was repositioning a Saab 340-B from the maintenance hanger to the gate for service. The aircraft was centered on the taxiway following ATC ground instructions. A mobile lounge with a driver and 26 passengers was operating parallel to the…Accident 20091108050929ACessna 172N · Luray, VAOn take-off from Luray Caverns Airport (W45) on runway 22 pilot failed to establish proper climb rated, at appromatly 8 ft above the runway the aircraft stalled and touched back on the runway, bounced once and landed 3/4 of the way down the runway. The pilot…Accident 20091108021389AAmtr Skyboltbm · Altus, OKOn the morning of Sunday, November 8, 2009, airport personnel stated that the pilot of N6644, an experimental homebuilt aircraft, had given approximately three rides to friends and associates. Airport personnel said the pilot's normal routine was to take off…Incident 20091108020339ICessna 152 · Tishomingo, OKPilot obtained weather briefing prior to departure. Pilot departed cassville municipal airport in cassville, MO for paris, TX at 10:45AM local time. Enroute to paris the pilot became disorientated as to their location. While circling to attempt to regain…Accident 20091107051709ACessna 150H · Paoli, INOn November 7, 2009, N22896, a Cessna 150H, departed moton field, tuskegee, al (K06A) for fayetteville, TN (kfym), an intermediate fuel stop, enroute to bloomington, IN, to overnight. After the aircraft was fueled, he departed kfym for bloomington, IN (kbmg).…Accident 20091107051379ACessna 172S · Middletown, DEThe solo student pilot was performing a touch and go landing on runway 17 at Summit Airport, Middletown, DE. The throttle was moved foward rapidly to commence the take off and inadequate right rudder was used. The aircraft departed the left side of the…Accident 20091107051099APiper PA-32-301 · Jacksonville, FLOn November 8, 2009 N100LW serial number 14408 was piloted by Mr. Paresh patel certificate number 2855017 was involved in an accident at Herlong Airport (heg) Jacksonville FL.Mr. Patel states he was landing on run way 11 when he experiance a cross wind witch…Incident 20091107050979IMcdonnell D MD-88 · Atl, GADuring taxi out for takeoff in Atl, the right engine had a fire during the start. The crew ran the appropriate checklists and dishcarged both fire bottles into the engine. The fire was not extinguished. Smoke entered into the cabin and a passenger evacuation…Accident 20091107050939ALockwood Ai AIR-CAM · Mount Victory, OHThe aircraft departed from denfield, ontario, Canada where floats were installed and was enroute to springfield, OH. The aircraft accident occured approximately 200 yards east of the approach end of runway 15 at mt. Victory, Ohio. The landing gear was not…Incident 20091107022669ICessna 414 · Roswell, NMOn November 07, 2009, at approximately 07:40 MST, the pilot of N645WC was intending to fly from Roswell international airport (krow) to carlsbad airport (kcnm). While taxiing approximately 50 yards to perform a full power run up, the pilot made a 90 degree…Accident 20091107022299APiper PA32R300 · Marana, AZOn 7 nov. 2009, at approx 1653 mountain standard time, a Piper PA-32-R-300, N2165M, experienced a partial loss of engine power during descent into tucson international airport (tus). The private pilot made an emergency landing on a roadway approximately 34…Accident 20091107021769APiasec PV18 · Adelanto, CAThe aircraft was an experimental exibition being flow from Adelanto, CA. To flabob, CA. When it experienced an unknown problem in flight, and it contacted the static line of a transmission tower, approximately 187 feet AGL. The helicopter descended rapidly…Accident 20091107021739ANamer T6G · Carson City, NVPilot reported that he took off on runway 9 and made one pass around the airport. Landed on runway 9 at about 1000 am PST, and on roll out with flaps down the engine was cut to idle and the pilot reported he had no rudder input for tail wheel steering. The…Accident 20091107021499AAmtr Hornet · Bonham, TXOn November 7, 2009, at 0800 central daylight time, a wicks air center, LLC Hornet, N651WA, impacted the ground near Jones Field Airport (F00) in Bonham, Texas. Witnesses report weather conditions of low clouds and fog at the time of the accident. The…Accident 20091106053899AEngineering 415-C · Xenia, OHOn March 2, 2010 during routine surviellance of the maintenance facility at I19 it was discovered that on November 6, 2009, aircraft N93415 had struck a tree during landing on runway 25.Accident 20091106051009AChampion 7GCBC · Kenai, AKAccording to the pilot, the aircraft was manuvering next to some hills when it contacted high wind gusts and he lost control whereas the aircraft contacted the ground and crashed. However the passenger told the inspector that the aircraft was landing.Accident 20091106025929AZenith Airc Zodiac 601X · Agnos, AROn November 6, 2009, at approximately 1030 central standard time (UTC + 6), N538CJ, a Zenith aircraft company, experiential zodiac experienced an in flight breakup and crashed approximately 7 miles from cherokee village, Arkansas (ar). The pilot was fatally…Incident 20091106022639IMooney M20K · Banning, CAReported to have a gear up landing. Unable to interview pilot up to this point. Will continue attempts to contact pilot. Pilot contacted this office after registered letter was sent. Pilot stated he was flying from john wayne airport, CA to Banning airport,…Incident 20091106022579INavion Navionh · El Monte, CAAborted takeoff due to unsecured cowling. Left wing struck ground. Minor damage to aircraft. No injuries.Accident 20091106022419ACirrus SR20 · Santa Barbara, CAMr. Bruce familian stated that he made a normal approach for landing on runway 15L at Santa Barbara, CA. He stated that he made a normal flare and touch down on the main gear. He said when the nosewheel touched down that the airplane immediately popped up…Incident 20091106021659ICessna 172M · Denton, TXOn November 6, 2009, at approximately 0100 local time, pilot in command, Mr. John richter was instructing Mr. Yulei (lee) wu during takeoff at Denton Municipal Airport. Just before rotation, Cessna, CE-172, N12180 struck a deer. The impact dented the left…Incident 20091106021509IPiper PA31P · Houston, TXOn 11/06/2009 at 1039 CST, pilot-under-instruction attempted to takeoff from kcxo airport on runway 14. Both pilots and tower personnel state that the aircraft started to veer to the right after takeoff roll and then veered left off the runway. The aircraft…Incident 20091106020409ICessna 172N · Craig, MTPilot depleted the aircraft fuel supply and performed an emergency landing on interstate highway I-15 at Craig, Montana.Incident 20091105052229IPiaggio P180 · Jacksonville, FLOn November 5, 2009 at approximately 1643 EDT a Piaggio P180, N147SL, s/n 1083, registered to hap's aviation, c/o avantair was in route from orl to tet when the pilot reported smoke and excessive heat in the cabin and a sick passenger and diverted to…Accident 20091105051959AGrumman Air G-111 · Ft. Pierce, FLThe initial take-off roll/acceleration seemed normal. Pilot rotated at approx 90-92 KTS. Takeoff appeared normal until about 20 ft in the air. The landing gear was in transit up at 96-98 KTS when the left engine started banging. The left engine completely…Incident 20091105051339IEmbraer EMB-145LR · Buffalo, NYOn 11/05/2009 at 07:11 EST an EMB-145LR (N579RP) operated by chqa as flight 6004 was at cruise when the crew reported a #2 engine fire indication. The crew ran the qrh, discharged both fire bottles, and shut down the #2 engine. The aircraft diverted into buf…Accident 20091105051049ARobinson He R44 · Morovis, PROn November 5, 2009, at approximately 12:55 local time, a Robinson helicopter model R-44 with registration number N440M, piloted by commercial pilot isbelia reyes departed from fernando luis ribas dominici airport (sig) on a 14 CFR part 91. Around 13:10 local…Incident 20091105050859IRockwell IN 114A · Sparta, TNUpon landing rollout aircraft nose gear malfunctioned. Aircraft departed runway to the left and struck runway marker.Incident 20091105020279ICessna 172RG · Starkville, MSAircraft N5104U made a gear up landing at Starkville (kstf) in the grass adjacent to the runway 36. No injuries and minimal damage to the aircraft.Incident 20091104052239IBombardier CL-600-2C10 · Moline, ILPrior to departure roll, the x-flow caution light illuminated. The pilot reset the system, the light extinguished.