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 20071103826749ICessna 152 · Pottstown, PA(-23) The instructor and student were landing on runway 28 at the ptw airport. The instructor was at the controls demonstrating a landing to a student who has not yet obtained a student pilot certificate. The instructor stated everything appeared normal until…Accident 20071103826369ARobsin R22BETA · Parma, ID(-23) During hovering autorotation instruction, the aircraft struck the ground hard on the right skid. The hard landing resulted in damage to the aircraft skids and the tail boom was bent in the area where it attaches to the aircraft frame. The entire tail…Incident 20071103824459ICessna 177RG · Albany, GA(-23) Pilot stated he was in the pattern, lowered gear and did not get "gear down" green light. Bulb tested good. Recycled the gear 3 times, tried emergency gear extension. No green light. Observed main gear down each time, opened pilot's door and pulled on…Incident 20071103824349IPiper PA28140 · Spanish Fork, UT(-23) On 11/03/07 at Spanish Fork airport (U77) a Piper PA-28, N15868, struck a deer with its left wing. The leading edge had minor damage. The incident occurred during flight instruction, on take-off as part of a touch-n-go. There were 2 people onboard, a…Accident 20071102829809AAmtr DSA1 · Alburg, VT(-23) After conducting a low-level (approximately 100 feet above ground level (AGL)) inverted pass down the centerline of the runway (runway 21) at Northern Lights Airport, VT (VT46), the aircraft crashed into trees adjacent to the departure end. The aircraft…Incident 20071102829509IPiper PA23250 · Hickory, NC(-23) Instructional flight conducting pattern work runway 06. Student heard scraping noise on landing and initiated a go-around. The nose of the aircraft pitched up excessively and yawed/rolled left. CFI perceived an engine failure and took controls, lowered…Incident 20071102827749IBbavia 7AC · Selma, CA(-23) The pilot CFI [privacy data omitted] was conducting a flight review for private pilot [privacy data omitted]. On preceding landing the airplane almost groundlooped, the tail came around from the left side with the plane stopping on the right shoulder of…Incident 20071102827729ICessna 177RG · Baton Rouge, LA(-23) Pilot attempted a landing in a crosswind with a fuel imbalance. The aircraft ran off the runway and struck a runway sign. Minor damage to the aircraft. No injuries. The pilot was landing on runway 31. The wind at the time was from 350 degrees at 6 knots.Accident 20071102827509AKellyk KELLYF1D · Stead, NV(-23) This was the first flight for this pilot in this aircraft. Both the engine and propeller were replaced with a different make and/or model. Prior to departure, a high power engine run-up was successfully performed. The fuel tank was topped to five…Accident 20071102827049AAmtr Trishsride · Greenville, PA(-23) On November 2, 2007, at approximately 08:35, a vans RV-10 amateur built experimental aircraft, U.S. Registered N289DT, crashed onto route 58 in Greenville, PA. The pilot, who was the sole occupant on board, sustained fatal injuries. Crash impact forces…Accident 20071102826459ABbavia 7AC · Fort Worth, TX(-23) On November 2, 2007 at approximately 1830 central daylight time (CDT), a single engine aeronica champ AR-7-AC, N81800, owned by flywithrobert LLC, 6329 wallingford dr., Fort Worth, TX 76133, after landing on a part 91 personal flight, veered off to the…Incident 20071102824759IDoug DC873F · Wichita, KS(-23) On November 02, 2007 at 0626 local time, aircraft N880UP, flight #918, while enroute from louisville, Kentucky, (sdf) to ontario, California (ont) was diverted to Wichita, KS (ict), ATCT was contacted at Wichita and declared an emergency landing due to…Accident 20071102824629ACessna TP206A · Boulder, CO(-23) On Friday, 11/02/07, at approximately 1:45 pm local time, aircraft N4635F, a Cessna 206, registered to front range skydivers, inc. 222 willow street Colorado springs, Colorado, 80903, crashed short of runway 8 at Boulder Municipal Airport. The pilot…Accident 20071102824169AInterp XJ · Independence, OR(-23) Shortly after takeoff from rwy 34 at 7S5, at a height of approximately 75 feet AGL the nose of the aircraft pitched down abruptly. The aircraft simultaneously turned approximately 100 degrees to the left and impacted the ground approximately 300 feet to…Incident 20071101832039ICessna 172P · Brookfield, WI(-23) At approximately 1830L on Thursday, November 1, 2007, N172WM, a Cessna 172P, struck a deer while landing at Capitol Airport (02C) in Brookfield, WI. The pilot was able to complete the landing safely. Weather was not a factor. The pilot indicated there…Incident 20071101831519ICessna 172N · Morgantown, WV(-23) [privacy data omitted] student pilot was practicing touch and gos on rwy 36 at mgw. The aircraft bounced several times in the landing attempt and the propeller struck the runway. The student pilot secured the engine and the aircraft was towed to the…Incident 20071101830929ICessna 182J · Springfield, IL(-23) Pilot stated in an interview that he felt an unusual vibration in the nose gear after he departed from his last airport. Pilot requested equipment standing by in the event of nose gear problems. Nose gear tire was flat on landing, no damage reported.…Incident 20071101830379IMooney M20A · Longview, TX(-23) After landing at the Longview airport and aircraft was taxiing, the left main landing gear collapsed. Examination found that the new tire had insufficient clearance at take off speed and the retraction had bent one of the retract tubes. Additional minor…Accident 20071101827929AWrbas CH601XL · Lewistown, MO(-23) On nov. 01, 2007 at approximately 1635 hours local time, the pilot [privacy data omitted] departed Sharpe Farms Airport for the initial test flight of a newly certificated experimental aircraft. According to witness statements within minutes after…Accident 20071101827899AMooney M20E · Lafayette, IN(-23) On 11/01/07 at approximately 17:00 EST a private pilot operating a M20E, N5912Q was enroute from kppo to M91. The weather was VFR and no flight plan was filed. Just past klaf the engine began to run rough, the pilot then heard a loud bang and then the…Accident 20071101827579APiper PA28151 · Alliance, OH(-23) Aircraft failed to stop after brakes were applied, resulting in collision with ditch, road, and passing vehicle at the end of the runway approximately 1150' after touchdown. Aircraft sustained substantial damage to both wings, propeller, and engine…Incident 20071101827539IGulstm G1159A · Fort Lauderdal, FL(-23) On November 1, 2007, at approximately 2300 eastern standard time (EST) a Gulfstream model 1159A, registration number N165G, serial number 414 landed at Fort Lauderdale Executive Airport (kfxe) on a 14 CFR 91 flight. After touchdown on runway 08 the…Incident 20071101827219IAmtr CHALLENGER2 · Walcott, IA(-23) The aircraft experienced engine failure. Pilot attempted to land on a gravel road. A truck slowed then stopped in front of the aircraft so the pilot veered and landed in a crop field. Upon landing one of the main landing gear collapsed.Accident 20071101826379AAyres S2RG10 · Lenorah, TX(-23) On November 1, 2007, at approximately 1800 CDT, the pilot of an Ayres S2-R agricultural aircraft, N32984, experienced loss of power and subsequently made an emergency landing during an agricultural spraying operation in the vicinity of the town of…Incident 20071101826149IBeech 1900D · Lees Summit, MO(-23) Air midwest flight 4680 was enroute from adams field (lit) little rock, Arkansas to Kansas city international airport (mci), Kansas city, MO at cruising altitude of 16,000 feet. Kansas city air route traffic control center (ARTCC) cleared the aircraft…Incident 20071101824739ICessna T210N · Sedalia, MO(-23) The aircraft departed kmez enroute to kdmo after receiving an annual inspection and new paint. Upon arrival at kdmo, the pilot noticed an unsafe gear indication after selecting gear down. Personnel on the ground communicated to the pilot that the main…Incident 20071031830449IBeech C24R · Rome, NY(-23) On 10/31/2007, at approximately 1850, aircraft landed on runway 15, with a total electrical failure, and landing gear retracted. Emergency equipment was dispatched to the aircraft as a precaution. No injuries were reported. While PIC was being vectored…Accident 20071031827489APiper PA18150 · Stockton, CA(-23) Aircraft N4153M, PA-18-150, flipped over while taxiing in a plowed field in Stockton, CA on 10/31/07 at 1730 PDT. Substantial damage to aircraft and no injuries to the pilot or passenger.Incident 20071031826229IAmtr RV4 · Mc Minnville, OR(-23) The airplane left the runway to the right following landing and sustained damage to the left main landing gear and the aft area of the fuselage. The pilot in command stated he was checking out another pilot from the rear seat where he had no rudder…Accident 20071031824159ADyesam RANSS12AIRLE · Cottage Grove, OR(-23) Approximately five minutes after taekoff at 2500 feet AGL the engine stopped. The pilot attempted to execute an emergency landing in a field approximately 1000 feet in length. The airplane touched down on an abrupt rise in the field approximately 300…Incident 20071031824089ICessna 150J · Dawson, GA(-23) Aircraft departed Dawson (16J) for a solo cross country, student pilot [privacy data omitted] was PIC, enroute to fitzgerald (fzg). The pilot [privacy data omitted] stated when he was over his first way point the engine started to miss. He pulled back…Incident 20071031023329IPilats PC1245 · Crossville, TN(-23) Human factors: first flight without a second crewmember. Always flown in an air carrier environment. Distracted, heavy airport use at the time, several aircraft in uncontrolled airport situation. Rushed procedures/checklist. Low flight in this…Incident 20071030831499IBeech 95A55 · Michigan City, IN(-23) Pilot stated that he had taken off from runway 20, mgc and was returning to land same runway and forgot to lower landing gear. Pilot was reexamined (44709) on 06/27/2007 for an incident with the same aircraft and airport. Pilot lost control of aircraft…Incident 20071030831239IPiper PA34220T · Willmar, MN(-23) Nose gear failed to extend, elected to land on grass runway with gear retracted.Accident 20071030827962APiper PA28181 · Phoenix, AZ(-23) Both N309PA & N923PA were in the runup area, holding short at the end of runway 74, preparing for takeoff at dvt. The student pilot of N309PA was preparing for his first solo flight and was positioned just to the left and slightly aft of N923PA, which…Accident 20071030827949ACessna 152 · Turlock, CA(-23) After conducting a normal landing and takeoff the pilot attempted a no-flap, forward slip to landing. He landed with excess airspeed at approximately midfield. When the pilot realized there was insufficient runway to stop he considered a go around…Accident 20071030827801APiper PA28181 · Phoenix, AZ(-23) Both N309PA & N923PA were in the runup area, holding short at the end of runway 74, preparing for takeoff at dvt. The student pilot of N309PA was preparing for his first solo flight and was positioned just to the left and slightly aft of N923PA, which…Incident 20071030827299IPiper PA44180 · Concord, CA(-23) 10/30/2007, 11:50 Local time. N633T a Piper PA44-180 owned and operated by pacific states aviation, piloted by a CFI took off from Concord airport ccr. The aircraft was on downwind when the emergency exit departed the aircraft. The tower was advised and…Incident 20071030826239ICndair CL6002B19 · Omaha, NE(-23) N828AS, CL-600-2B19, being operated by atlantic southeast airlines as flight 4914, declared an emergency on approach into Omaha, NE, due to a gear disagreement message. The crew extended the landing gear by using the free fall method. The aircraft…Incident 20071030824419ICessna T210K · Houma, LA(-23) The incident occurred about 2:45 the afternoon of the 30th of October, at the Houma, LA airport (khum). Pilot was flying N727FA from new iberia. The trip originated from kbtr with a stop at L38 before proceeding to new iberia. Pilot made a VFR approach…Incident 20071030824129IAirbus A319112 · Richmond, VA(-23) 10/30/2007 18:50 EDT usair flight 1673, climbing out of FL190 to FL200 aircraft had 3 explosions in the number 1 eng. Flame reported by passengers and flight attendant. Thrust oscillated greatly. Aircraft returned to ric without shutting down engine.…Incident 20071029831139ICessna 172RG · Minneapolis, MN(-23) Aircraft nose gear would not come down in flight. Pilot attempted to correct with alternate gear procedure to no avail and elected to land with the nose gear up.Incident 20071029830429ICessna 172RG · Warrenton, VA(-23) Pilots stated that upon landing the nose landing gear and main landing gear collapsed. Investigation revealed that the landing gear was operational at the time of the incident and no defects were found by a maintenance ops check. The downlock system was…Accident 20071029828099ACessna 172R · Brookings, SD(-23) The student pilot [privacy data omitted] was flying N77LU conducting touch-and-go landings on runway 12 at the Brookings, SD airport. He touched down on runway 12 and was distracted by another aircraft passing overhead when the aircraft drifted off the…Accident 20071029827569AHughes 369E · Columbus, OH(-23) At 1300 feet MSL and air speed between 60-70 knots, there was a mechanical failure and loss of engine power. The helicopter shuttered and the engine made a very loud squealing/grinding/sucking sound which was accompanied by a shaking and a pronounced…Accident 20071029826989ARobsin R22BETA · Unalaska, AK(-23) Robinson helicopter model R-22 reportedly crashed while hovering over a beach on umnaki island. It was reported that while hovering in gusty winds the helicopter's tail rotor came in contact with the ground and the pilot subsequently lost control of the…Incident 20071029826869IDoug DC1030F · Valencia(-23) During climb out the crew felt a vibration and had smoke in the cockpit. The number one engine oil quantity went to zero and the oil pressure was fluctuating. The number one engine was shut down and the vibration ceased and the smoke cleared. Number one…Accident 20071029825169ARaythn HAWKER800XP · Santa Ana, CA(-23) Aircraft aborted takeoff twice due to apr (auto performance reserves) light illuminating. On third attempt, crew aborted takeoff at approximately 85 knots. On last aborted takeoff, left main gear tires shredded, hydraulic line in left wheel well…Accident 20071029824189APiper PA22150 · Canon City, CO(-23) Aircraft had completed 5 touch and gos on a local flight. On sixth landing, pilot felt a "pop" and aircraft began to settle right wing low. Pilot held right wing up and applied slight left brake to maintain runway heading. As speed slowed, right main…Incident 20071029823859IBolkms BK117A4 · Hamburg, PA(-23) Aircraft was cruising @1800 MSL in a north direction at which time a bird strike occurred. Pilot made an emergency landing in a shopping center parking lot. R/h windshield broken, r/h aft cabin window broken and dent in #2 engine cowl.